**Tempo della query: 1.64 ms** **Memoria query: 0.182 MB memoria prima della query: 2.865 MB** **Righe restituite: 148**
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 mejrs_menu AS m
LEFT JOIN mejrs_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 | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 150 | Using where; **Using filesort** |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | Sql825895_1.m.component_id | 1 | |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
24 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
23 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
22 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
21 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | **Chiamata uguale alla linea sottostante.** |
20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
18 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
17 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
16 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:423 |
14 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
13 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
12 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
11 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:539 |
10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:145 |
8 | PlgSystemLanguageFilter->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:674 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.57 ms** **Dopo l'ultima query: 3.26 ms** **Memoria query: 0.029 MB memoria prima della query: 3.125 MB** **Righe restituite: 16**
SELECT joomlatablename,tablepkID
FROM `mejrs_falang_tableinfo`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | mejrs_falang_tableinfo | ALL | NULL | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | 16 | |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
30 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
29 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
28 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
27 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:144 |
26 | FalangManager->_loadPrimaryKeyData() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:57 |
25 | FalangManager->__construct() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 |
24 | FalangManager::getInstance() | JROOT/components/com_falang/helpers/falang.class.php:35 |
23 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
22 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
21 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | **Chiamata uguale alla linea sottostante.** |
20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
18 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
17 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
16 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:423 |
14 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
13 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
12 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
11 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:539 |
10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:145 |
8 | PlgSystemLanguageFilter->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:674 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.64 ms** **Dopo l'ultima query: 0.12 ms** **Memoria query: 0.029 MB memoria prima della query: 3.140 MB** **Righe restituite: 2**
SELECT *
FROM mejrs_languages
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | mejrs_languages | ALL | NULL | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | 2 | **Using filesort** |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
30 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
29 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
28 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
27 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:319 |
26 | FalangManager->getLanguages() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63 |
25 | FalangManager->__construct() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 |
24 | FalangManager::getInstance() | JROOT/components/com_falang/helpers/falang.class.php:35 |
23 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
22 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
21 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | **Chiamata uguale alla linea sottostante.** |
20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
18 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
17 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
16 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:423 |
14 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
13 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
12 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
11 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:539 |
10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:145 |
8 | PlgSystemLanguageFilter->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:674 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 1.96 ms** **Dopo l'ultima query: 2.84 ms** **Memoria query: 0.033 MB memoria prima della query: 3.228 MB** **Righe restituite: 14**
SHOW FULL COLUMNS
FROM `mejrs_languages`
**EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `mejrs_languages`**
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
34 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
33 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
32 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
31 | JFalangDatabase->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
30 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
29 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
28 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_falang/tables/JFLanguage.php:54 |
27 | TableJFLanguage->__construct() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:325 |
26 | FalangManager->getLanguages() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63 |
25 | FalangManager->__construct() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 |
24 | FalangManager::getInstance() | JROOT/components/com_falang/helpers/falang.class.php:35 |
23 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
22 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
21 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | **Chiamata uguale alla linea sottostante.** |
20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
18 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
17 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
16 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:423 |
14 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
13 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
12 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
11 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:539 |
10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:145 |
8 | PlgSystemLanguageFilter->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:674 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.51 ms** **Dopo l'ultima query: 2.32 ms** **Memoria query: 0.027 MB memoria prima della query: 3.279 MB** **Righe restituite: 0**
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM mejrs_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(707,708,709,711,710,216,532,106,716,671,109,766,110,688,689,690,691,692,112,693,694,715,695,342,351,181,115,569,595,582,217,570,571,572,573,574,575,576,577,578,579,752,594,580,696,697,698,699,700,701,581,722,747,544,753,761,754,755,756,757,758,759,760,545,182,183,184,185,186,188,189,190,191,192,193,194,195,196,197,199,200,201,202,203,204,205,206,208,210,211,212,213,214,248,249,250,252,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,253,254,255,256,234,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,104,105,350,712,713,714,925,926,927,928,932,929,930,931)
AND falang_content.reference_table='menu'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | falang_content | ref | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table | language_id | 4 | const | 1 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
28 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
27 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
26 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
25 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
24 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
23 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
22 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
21 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | **Chiamata uguale alla linea sottostante.** |
20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
18 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
17 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
16 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:423 |
14 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
13 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
12 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
11 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:539 |
10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:145 |
8 | PlgSystemLanguageFilter->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:674 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.78 ms** **Dopo l'ultima query: 9.17 ms** **Memoria query: 0.025 MB memoria prima della query: 3.609 MB** **Righe restituite: 1**
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `mejrs_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | mejrs_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
21 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
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/libraries/src/Helper/LibraryHelper.php:167 |
17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | **Chiamata uguale alla linea sottostante.** |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/k2/k2.php:47 |
8 | plgSystemK2->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:674 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 1.55 ms** **Dopo l'ultima query: 0.21 ms** **Memoria query: 0.006 MB memoria prima della query: 3.603 MB**
UPDATE `mejrs_extensions`
SET `params` = '{\"mediaversion\":\"f77627ae6138a4c140d89ca0a562ba58\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
**EXPLAIN non possibile sulla query: UPDATE `mejrs_extensions`
SET `params` = '{\"mediaversion\":\"f77627ae6138a4c140d89ca0a562ba58\"}'
WHERE `type` = 'library' AND `element` = 'joomla'**
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
14 | JFalangDatabase->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/k2/k2.php:47 |
8 | plgSystemK2->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:674 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 4.91 ms** **Dopo l'ultima query: 29.65 ms** **Memoria query: 0.180 MB memoria prima della query: 4.052 MB** **Righe restituite: 148**
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 mejrs_menu AS m
LEFT JOIN mejrs_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 | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 150 | Using where; **Using filesort** |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | Sql825895_1.m.component_id | 1 | |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
20 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
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}() | **Chiamata uguale alla linea sottostante.** |
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:78 |
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:368 |
11 | plgSystemFalangdriver->parseRule() | **Chiamata uguale alla linea sottostante.** |
10 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:596 |
9 | Joomla\CMS\Router\Router->processParseRules() | JROOT/libraries/src/Router/SiteRouter.php:597 |
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:139 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1148 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 1.65 ms** **Dopo l'ultima query: 1.59 ms** **Memoria query: 0.206 MB memoria prima della query: 4.324 MB** **Righe restituite: 661**
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM mejrs_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(707,708,709,711,710,216,532,106,716,671,109,766,110,688,689,690,691,692,112,693,694,715,695,342,351,181,115,569,595,582,217,570,571,572,573,574,575,576,577,578,579,752,594,580,696,697,698,699,700,701,581,722,747,544,753,761,754,755,756,757,758,759,760,545,182,183,184,185,186,188,189,190,191,192,193,194,195,196,197,199,200,201,202,203,204,205,206,208,210,211,212,213,214,248,249,250,252,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,253,254,255,256,234,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,104,105,350,712,713,714,925,926,927,928,932,929,930,931)
AND falang_content.reference_table='menu'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | falang_content | ref | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table | reference_table | 302 | const | 890 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
23 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
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}() | **Chiamata uguale alla linea sottostante.** |
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:78 |
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:368 |
11 | plgSystemFalangdriver->parseRule() | **Chiamata uguale alla linea sottostante.** |
10 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:596 |
9 | Joomla\CMS\Router\Router->processParseRules() | JROOT/libraries/src/Router/SiteRouter.php:597 |
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:139 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1148 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.97 ms** **Dopo l'ultima query: 18.28 ms** **Memoria query: 0.022 MB memoria prima della query: 4.098 MB** **Righe restituite: 3**
SELECT id, home, template, s.params
FROM mejrs_template_styles as s
LEFT JOIN mejrs_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 | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | 4 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 303 | Sql825895_1.s.template,const | 1 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
13 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
11 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/t3/includes/core/t3.php:320 |
9 | T3::detect() | JROOT/plugins/system/t3/t3.php:81 |
8 | plgSystemT3->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1196 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.54 ms** **Dopo l'ultima query: 22.20 ms** **Memoria query: 0.029 MB memoria prima della query: 4.293 MB** **Righe restituite: 44**
SELECT `id`,`name`,`rules`,`parent_id`
FROM `mejrs_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','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_jaextmanager','com_jce','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_phocacommander','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper','com_zhosmmap')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | mejrs_assets | ALL | idx_asset_name | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | 124 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
19 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
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:58 |
11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 |
10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.42 ms** **Dopo l'ultima query: 0.30 ms** **Memoria query: 0.027 MB memoria prima della query: 4.353 MB** **Righe restituite: 23**
SELECT `id`,`name`,`rules`,`parent_id`
FROM `mejrs_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | mejrs_assets | ALL | idx_asset_name,idx_parent_id | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | 124 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
19 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
17 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
16 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 |
10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 2.04 ms** **Dopo l'ultima query: 1.71 ms** **Memoria query: 0.033 MB memoria prima della query: 4.394 MB** **Righe restituite: 31**
SHOW FULL COLUMNS
FROM `mejrs_content`
**EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `mejrs_content`**
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
17 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
15 | JFalangDatabase->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
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:253 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 1.62 ms** **Dopo l'ultima query: 3.41 ms** **Memoria query: 0.006 MB memoria prima della query: 4.506 MB**
UPDATE mejrs_content
SET `hits` = (`hits` + 1)
WHERE `id` = '11'
**EXPLAIN non possibile sulla query: UPDATE mejrs_content
SET `hits` = (`hits` + 1)
WHERE `id` = '11'**
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
11 | JFalangDatabase->execute() | JROOT/libraries/src/Table/Table.php:1245 |
10 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_content/models/article.php:254 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 1.57 ms** **Dopo l'ultima query: 1.68 ms** **Memoria query: 0.025 MB memoria prima della query: 4.532 MB** **Righe restituite: 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 mejrs_content AS a
INNER JOIN mejrs_categories AS c
on c.id = a.catid
LEFT JOIN mejrs_users AS u
on u.id = a.created_by
LEFT JOIN mejrs_categories as parent
ON parent.id = c.parent_id
LEFT JOIN mejrs_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 11
AND c.published > 0
AND a.language in ('it-IT','*')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-04 02:30:50')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-04 02:30:50')
AND (a.state = 1 OR a.state =2)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | const | PRIMARY,idx_state,idx_catid,idx_language | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | v | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
16 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
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/components/com_content/models/article.php:151 |
12 | ContentModelArticle->getItem() | JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/article/view.html.php:42 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 1.57 ms** **Dopo l'ultima query: 0.38 ms** **Memoria query: 0.026 MB memoria prima della query: 4.564 MB** **Righe restituite: 7**
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM mejrs_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(11)
AND falang_content.reference_table='content'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | falang_content | ref | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table | falangContent | 310 | const,const,const | 6 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
19 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
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/components/com_content/models/article.php:151 |
12 | ContentModelArticle->getItem() | JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/article/view.html.php:42 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 1.58 ms** **Dopo l'ultima query: 2.55 ms** **Memoria query: 0.028 MB memoria prima della query: 4.589 MB** **Righe restituite: 1**
SELECT fc.value
FROM mejrs_falang_content fc
WHERE fc.reference_id = 11
AND fc.language_id = 2
AND fc.reference_field = 'alias'
AND fc.published = 1
AND fc.reference_table = 'content'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | fc | ref | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field | idxFalang1 | 608 | const,const,const | 1 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
26 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
25 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
24 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
23 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
22 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
21 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
20 | JFalangDatabase->loadResult() | JROOT/plugins/system/falangdriver/falangdriver.php:108 |
19 | plgSystemFalangdriver->buildRule() | **Chiamata uguale alla linea sottostante.** |
18 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:638 |
17 | Joomla\CMS\Router\Router->processBuildRules() | JROOT/libraries/src/Router/SiteRouter.php:661 |
16 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:614 |
15 | Joomla\CMS\Router\Router->_processBuildRules() | JROOT/libraries/src/Router/Router.php:270 |
14 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
13 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
12 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
11 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/article/view.html.php:71 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.71 ms** **Dopo l'ultima query: 0.48 ms** **Memoria query: 0.023 MB memoria prima della query: 4.598 MB** **Righe restituite: 0**
SELECT `m`.`tag_id`,`t`.*
FROM `mejrs_contentitem_tag_map` AS m
INNER JOIN `mejrs_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 11
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | ALL | idx_tag_type | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | 1 | Using where |
1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | Sql825895_1.m.tag_id | 1 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
14 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
12 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
11 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/views/article/view.html.php:184 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.46 ms** **Dopo l'ultima query: 12.04 ms** **Memoria query: 0.027 MB memoria prima della query: 4.714 MB** **Righe restituite: 2**
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 `mejrs_categories` AS `s`
INNER JOIN `mejrs_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('it-IT','*')) 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,5)
AND c.published = 1
AND s.id = 2
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | **Using filesort** |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right,idx_language | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | 8 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
22 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
20 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
19 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
18 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:203 |
17 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
16 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.40 ms** **Dopo l'ultima query: 0.71 ms** **Memoria query: 0.026 MB memoria prima della query: 4.736 MB** **Righe restituite: 0**
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM mejrs_fields AS a
LEFT JOIN `mejrs_languages` AS l
ON l.lang_code = a.language
LEFT JOIN mejrs_users AS uc
ON uc.id=a.checked_out
LEFT JOIN mejrs_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN mejrs_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN mejrs_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `mejrs_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 (2,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; **Using filesort** |
1 | SIMPLE | l | ALL | NULL | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | 2 | |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | Sql825895_1.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | Sql825895_1.a.access | 1 | |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | Sql825895_1.a.created_user_id | 1 | |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | Sql825895_1.a.group_id | 1 | Using where |
1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | Sql825895_1.a.id | 1 | Using where; Using index; Distinct |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
20 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
18 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.92 ms** **Dopo l'ultima query: 3.42 ms** **Memoria query: 0.075 MB memoria prima della query: 4.789 MB** **Righe restituite: 1**
SELECT h.*, c.title as category
FROM mejrs_zhosmmaps_maps as h
LEFT JOIN mejrs_categories as c
ON h.catid=c.id
WHERE h.id=1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h | system | PRIMARY | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | 1 | |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
19 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
17 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
16 | JFalangDatabase->loadObject() | JROOT/components/com_zhosmmap/helpers/map_data.php:32 |
15 | comZhOSMMapData::getMap() | JROOT/plugins/content/plg_zhosmmap/plg_zhosmmap.php:1029 |
14 | plgContentPlg_ZhOSMMap->getMap() | JROOT/plugins/content/plg_zhosmmap/plg_zhosmmap.php:214 |
13 | plgContentPlg_ZhOSMMap->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 1.08 ms** **Dopo l'ultima query: 0.50 ms** **Memoria query: 0.074 MB memoria prima della query: 4.814 MB** **Righe restituite: 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.minwidth, bub.maxwidth, bub.minheight, bub.maxheight, bub.disableautopan, bub.published infobubblepublished, bub.offsetx, bub.offsety
FROM mejrs_zhosmmaps_markers as h
LEFT JOIN mejrs_categories as c
ON h.catid=c.id
LEFT JOIN mejrs_zhosmmaps_markergroups as g
ON h.markergroup=g.id
LEFT JOIN mejrs_zhosmmaps_infobubbles as bub
ON h.tabid=bub.id
WHERE 1=1
and h.mapid=1
and h.published=1
AND (h.publish_up = '0000-00-00 00:00:00' OR h.publish_up <= '2024-10-04 02:30:50')
AND (h.publish_down = '0000-00-00 00:00:00' OR h.publish_down >= '2024-10-04 02:30:50')
ORDER BY h.title
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h | system | idx_mapid | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | 1 | |
1 | SIMPLE | g | system | PRIMARY | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | 0 | const row not found |
1 | SIMPLE | bub | system | PRIMARY | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | 0 | const row not found |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
18 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
16 | JFalangDatabase->loadObjectList() | JROOT/components/com_zhosmmap/helpers/map_data.php:355 |
15 | comZhOSMMapData::getMarkers() | JROOT/plugins/content/plg_zhosmmap/plg_zhosmmap.php:1049 |
14 | plgContentPlg_ZhOSMMap->getMap() | JROOT/plugins/content/plg_zhosmmap/plg_zhosmmap.php:214 |
13 | plgContentPlg_ZhOSMMap->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 1.38 ms** **Dopo l'ultima query: 0.51 ms** **Memoria query: 0.042 MB memoria prima della query: 4.835 MB** **Righe restituite: 0**
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
FROM mejrs_zhosmmaps_paths as h
LEFT JOIN mejrs_categories as c
ON h.catid=c.id
LEFT JOIN mejrs_zhosmmaps_markergroups as g
ON h.markergroup=g.id
WHERE h.published=1
and h.mapid=1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
18 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
16 | JFalangDatabase->loadObjectList() | JROOT/components/com_zhosmmap/helpers/map_data.php:1534 |
15 | comZhOSMMapData::getPaths() | JROOT/plugins/content/plg_zhosmmap/plg_zhosmmap.php:1050 |
14 | plgContentPlg_ZhOSMMap->getMap() | JROOT/plugins/content/plg_zhosmmap/plg_zhosmmap.php:214 |
13 | plgContentPlg_ZhOSMMap->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.66 ms** **Dopo l'ultima query: 0.31 ms** **Memoria query: 0.025 MB memoria prima della query: 4.844 MB** **Righe restituite: 0**
SELECT h.*, c.title as category
FROM mejrs_zhosmmaps_routers as h
LEFT JOIN mejrs_categories as c
ON h.catid=c.id
WHERE h.published=1
and h.mapid=1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
18 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
16 | JFalangDatabase->loadObjectList() | JROOT/components/com_zhosmmap/helpers/map_data.php:504 |
15 | comZhOSMMapData::getRouters() | JROOT/plugins/content/plg_zhosmmap/plg_zhosmmap.php:1058 |
14 | plgContentPlg_ZhOSMMap->getMap() | JROOT/plugins/content/plg_zhosmmap/plg_zhosmmap.php:214 |
13 | plgContentPlg_ZhOSMMap->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.48 ms** **Dopo l'ultima query: 0.23 ms** **Memoria query: 0.025 MB memoria prima della query: 4.852 MB** **Righe restituite: 0**
SELECT h.*, c.title as category
FROM mejrs_zhosmmaps_maptypes as h
LEFT JOIN mejrs_categories as c
ON h.catid=c.id
WHERE h.published=1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
18 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
16 | JFalangDatabase->loadObjectList() | JROOT/components/com_zhosmmap/helpers/map_data.php:1552 |
15 | comZhOSMMapData::getMapTypes() | JROOT/plugins/content/plg_zhosmmap/plg_zhosmmap.php:1059 |
14 | plgContentPlg_ZhOSMMap->getMap() | JROOT/plugins/content/plg_zhosmmap/plg_zhosmmap.php:214 |
13 | plgContentPlg_ZhOSMMap->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.54 ms** **Dopo l'ultima query: 0.23 ms** **Memoria query: 0.025 MB memoria prima della query: 4.863 MB** **Righe restituite: 0**
SELECT h.*, c.title as category
FROM mejrs_zhosmmaps_markergroups as h
LEFT JOIN mejrs_categories as c
ON h.catid=c.id
WHERE EXISTS (SELECT 1
FROM mejrs_zhosmmaps_markers as m
WHERE m.markergroup=h.id
and m.mapid=1
and (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-04 02:30:50')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-04 02:30:50'))
ORDER BY h.title
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | NULL | NULL | NULL | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
2 | DEPENDENT SUBQUERY | NULL | NULL | NULL | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
18 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
16 | JFalangDatabase->loadObjectList() | JROOT/components/com_zhosmmap/helpers/map_data.php:711 |
15 | comZhOSMMapData::getMarkerGroups() | JROOT/plugins/content/plg_zhosmmap/plg_zhosmmap.php:1062 |
14 | plgContentPlg_ZhOSMMap->getMap() | JROOT/plugins/content/plg_zhosmmap/plg_zhosmmap.php:214 |
13 | plgContentPlg_ZhOSMMap->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.45 ms** **Dopo l'ultima query: 0.21 ms** **Memoria query: 0.025 MB memoria prima della query: 4.871 MB** **Righe restituite: 0**
SELECT h.*, c.title as category, c.parent_id as catcatid
FROM mejrs_zhosmmaps_markergroups as h
LEFT JOIN mejrs_categories as c
ON h.catid=c.id
WHERE 1=2
ORDER BY h.title
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | NULL | Impossible WHERE |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
18 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
16 | JFalangDatabase->loadObjectList() | JROOT/components/com_zhosmmap/helpers/map_data.php:1354 |
15 | comZhOSMMapData::getMarkerGroupsManage() | JROOT/plugins/content/plg_zhosmmap/plg_zhosmmap.php:1063 |
14 | plgContentPlg_ZhOSMMap->getMap() | JROOT/plugins/content/plg_zhosmmap/plg_zhosmmap.php:214 |
13 | plgContentPlg_ZhOSMMap->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.59 ms** **Dopo l'ultima query: 20.33 ms** **Memoria query: 0.030 MB memoria prima della query: 5.037 MB** **Righe restituite: 1**
SELECT fc.value
FROM mejrs_falang_content fc
WHERE fc.reference_id = 11
AND fc.language_id = 2
AND fc.reference_field = 'alias'
AND fc.published = 1
AND fc.reference_table = 'content'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | fc | ref | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field | idxFalang1 | 608 | const,const,const | 1 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
32 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
31 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
30 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
29 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
28 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
27 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
26 | JFalangDatabase->loadResult() | JROOT/plugins/system/falangdriver/falangdriver.php:108 |
25 | plgSystemFalangdriver->buildRule() | **Chiamata uguale alla linea sottostante.** |
24 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:638 |
23 | Joomla\CMS\Router\Router->processBuildRules() | JROOT/libraries/src/Router/SiteRouter.php:661 |
22 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:614 |
21 | Joomla\CMS\Router\Router->_processBuildRules() | JROOT/libraries/src/Router/Router.php:270 |
20 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
19 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
18 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
17 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/t3/base-bs3/html/layouts/joomla/content/item_title.php:20 |
16 | include JROOT/plugins/system/t3/base-bs3/html/layouts/joomla/content/item_title.php | JROOT/plugins/system/t3/includes/joomla4/FileLayout.php:125 |
15 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
14 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/templates/ja_mason/html/com_content/article/default.php:68 |
13 | include JROOT/templates/ja_mason/html/com_content/article/default.php | JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 |
12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230 |
11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_content/views/article/view.html.php:210 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.28 ms** **Dopo l'ultima query: 0.17 ms** **Memoria query: 0.030 MB memoria prima della query: 5.052 MB** **Righe restituite: 0**
SELECT fc.value
FROM mejrs_falang_content fc
WHERE fc.reference_id = 2
AND fc.language_id = 2
AND fc.reference_field = 'alias'
AND fc.published = 1
AND fc.reference_table = 'categories'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | fc | ref | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field | idxFalang1 | 608 | const,const,const | 1 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
32 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
31 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
30 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
29 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
28 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
27 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
26 | JFalangDatabase->loadResult() | JROOT/plugins/system/falangdriver/falangdriver.php:129 |
25 | plgSystemFalangdriver->buildRule() | **Chiamata uguale alla linea sottostante.** |
24 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:638 |
23 | Joomla\CMS\Router\Router->processBuildRules() | JROOT/libraries/src/Router/SiteRouter.php:661 |
22 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:614 |
21 | Joomla\CMS\Router\Router->_processBuildRules() | JROOT/libraries/src/Router/Router.php:270 |
20 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
19 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
18 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
17 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/t3/base-bs3/html/layouts/joomla/content/item_title.php:20 |
16 | include JROOT/plugins/system/t3/base-bs3/html/layouts/joomla/content/item_title.php | JROOT/plugins/system/t3/includes/joomla4/FileLayout.php:125 |
15 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
14 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/templates/ja_mason/html/com_content/article/default.php:68 |
13 | include JROOT/templates/ja_mason/html/com_content/article/default.php | JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 |
12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230 |
11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_content/views/article/view.html.php:210 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.27 ms** **Dopo l'ultima query: 0.76 ms** **Memoria query: 0.021 MB memoria prima della query: 5.015 MB** **Righe restituite: 1**
SELECT language,id
FROM `mejrs_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | mejrs_menu | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 151 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
11 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
9 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Language/Multilanguage.php:107 |
8 | Joomla\CMS\Language\Multilanguage::getSiteHomePages() | JROOT/plugins/system/languagefilter/languagefilter.php:751 |
7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.33 ms** **Dopo l'ultima query: 0.15 ms** **Memoria query: 0.023 MB memoria prima della query: 5.025 MB** **Righe restituite: 5**
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM mejrs_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(216)
AND falang_content.reference_table='menu'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | falang_content | ref | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table | idxFalang1 | 4 | const | 3 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
14 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
12 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
11 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
10 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
9 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Language/Multilanguage.php:107 |
8 | Joomla\CMS\Language\Multilanguage::getSiteHomePages() | JROOT/plugins/system/languagefilter/languagefilter.php:751 |
7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.54 ms** **Dopo l'ultima query: 0.39 ms** **Memoria query: 0.021 MB memoria prima della query: 5.037 MB** **Righe restituite: 0**
SELECT `c2`.`language`,`c2`.`id`
FROM `mejrs_menu` AS `c`
INNER JOIN `mejrs_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `mejrs_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `mejrs_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 115
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
12 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
10 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Language/Associations.php:115 |
9 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/administrator/components/com_menus/helpers/menus.php:321 |
8 | MenusHelper::getAssociations() | JROOT/plugins/system/languagefilter/languagefilter.php:768 |
7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.76 ms** **Dopo l'ultima query: 1.66 ms** **Memoria query: 0.023 MB memoria prima della query: 5.061 MB** **Righe restituite: 0**
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `mejrs_content` AS `c`
INNER JOIN `mejrs_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `mejrs_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `mejrs_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `mejrs_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 11
AND c2.access IN (1,1,5)
AND c2.language != 'it-IT'
AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2024-10-04 02:30:50')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2024-10-04 02:30:50')
AND c2.state = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | **NON È POSSIBILE UTILIZZARE ALCUN INDICE** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
12 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
10 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Language/Associations.php:115 |
9 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/components/com_content/helpers/association.php:76 |
8 | ContentHelperAssociation::getAssociations() | JROOT/plugins/system/languagefilter/languagefilter.php:783 |
7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 2.53 ms** **Dopo l'ultima query: 22.62 ms** **Memoria query: 0.043 MB memoria prima della query: 5.269 MB** **Righe restituite: 6**
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM mejrs_modules AS m
LEFT JOIN mejrs_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN mejrs_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 <= '2024-10-04 02:30:50')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-04 02:30:50')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 115 OR mm.menuid <= 0)
AND m.language IN ('it-IT','*')
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds,idx_language | published | 1 | const | 33 | Using where; **Using filesort** |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | Sql825895_1.m.id | 1 | Using where; Using index |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 303 | Sql825895_1.m.module,const | 1 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
21 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
19 | JFalangDatabase->loadObjectList() | **Chiamata uguale alla linea sottostante.** |
18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452 |
16 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382 |
15 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87 |
14 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:591 |
13 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/t3/includes/core/template.php:645 |
12 | T3Template->countModules() | JROOT/templates/ja_mason/tpls/blocks/header.php:84 |
11 | include JROOT/templates/ja_mason/tpls/blocks/header.php | JROOT/plugins/system/t3/includes/core/template.php:195 |
10 | T3Template->loadBlock() | JROOT/templates/ja_mason/tpls/default.php:42 |
9 | include JROOT/templates/ja_mason/tpls/default.php | JROOT/plugins/system/t3/includes/core/template.php:221 |
8 | T3Template->loadLayout() | JROOT/templates/ja_mason/index.php:34 |
7 | require JROOT/templates/ja_mason/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1104 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:209 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.41 ms** **Dopo l'ultima query: 0.23 ms** **Memoria query: 0.028 MB memoria prima della query: 5.302 MB** **Righe restituite: 8**
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM mejrs_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(88,129,126,118,155,156)
AND falang_content.reference_table='modules'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | falang_content | range | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table | falangContent | 310 | NULL | 10 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
24 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
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() | **Chiamata uguale alla linea sottostante.** |
18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452 |
16 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382 |
15 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87 |
14 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:591 |
13 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/t3/includes/core/template.php:645 |
12 | T3Template->countModules() | JROOT/templates/ja_mason/tpls/blocks/header.php:84 |
11 | include JROOT/templates/ja_mason/tpls/blocks/header.php | JROOT/plugins/system/t3/includes/core/template.php:195 |
10 | T3Template->loadBlock() | JROOT/templates/ja_mason/tpls/default.php:42 |
9 | include JROOT/templates/ja_mason/tpls/default.php | JROOT/plugins/system/t3/includes/core/template.php:221 |
8 | T3Template->loadLayout() | JROOT/templates/ja_mason/index.php:34 |
7 | require JROOT/templates/ja_mason/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1104 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:209 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 1.13 ms** **Dopo l'ultima query: 16.65 ms** **Memoria query: 0.024 MB memoria prima della query: 5.337 MB** **Righe restituite: 0**
SELECT fc.value
FROM mejrs_falang_content fc
WHERE fc.reference_id = 115
AND fc.language_id = 1
AND fc.reference_field = 'path'
AND fc.published = 1
AND fc.reference_table = 'menu'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | fc | ref | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field | idxFalang1 | 608 | const,const,const | 1 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
17 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
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/plugins/system/falangdriver/falang_database.php:351 |
13 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
12 | JFalangDatabase->loadResult() | JROOT/modules/mod_falang/helper.php:349 |
11 | modFaLangHelper::getList() | JROOT/modules/mod_falang/mod_falang.php:25 |
10 | include JROOT/modules/mod_falang/mod_falang.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:209 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.36 ms** **Dopo l'ultima query: 0.18 ms** **Memoria query: 0.024 MB memoria prima della query: 5.340 MB** **Righe restituite: 1**
SELECT m.path
FROM mejrs_menu m
WHERE m.id = 115
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | const | PRIMARY | PRIMARY | 4 | const | 1 | |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
17 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
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/plugins/system/falangdriver/falang_database.php:351 |
13 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
12 | JFalangDatabase->loadResult() | JROOT/modules/mod_falang/helper.php:358 |
11 | modFaLangHelper::getList() | JROOT/modules/mod_falang/mod_falang.php:25 |
10 | include JROOT/modules/mod_falang/mod_falang.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:209 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Tempo della query: 0.88 ms** **Dopo l'ultima query: 0.21 ms** **Memoria query: 0.024 MB memoria prima della query: 5.351 MB** **Righe restituite: 1**
SELECT fc.value
FROM mejrs_falang_content fc
WHERE fc.reference_id = 115
AND fc.language_id = 2
AND fc.reference_field = 'path'
AND fc.published = 1
AND fc.reference_table = 'menu'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | fc | ref | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field | idxFalang1 | 608 | const,const,const | 1 | Using where |
**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**
# | **Caller** | **File e numero di linea** |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
17 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
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/plugins/system/falangdriver/falang_database.php:351 |
13 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
12 | JFalangDatabase->loadResult() | JROOT/modules/mod_falang/helper.php:374 |
11 | modFaLangHelper::getList() | JROOT/modules/mod_falang/mod_falang.php:25 |
10 | include JROOT/modules/mod_falang/mod_falang.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:209 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**5 × SELECT fc.value
FROM mejrs_falang_content fc**
**5 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM mejrs_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 mejrs_menu AS m
LEFT JOIN mejrs_extensions AS e
ON m.component_id = e.extension_id**
**2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `mejrs_assets`**
**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
FROM mejrs_zhosmmaps_paths as h
LEFT JOIN mejrs_categories as c
ON h.catid=c.id
LEFT JOIN mejrs_zhosmmaps_markergroups as g
ON h.markergroup=g.id**
**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM mejrs_modules AS m
LEFT JOIN mejrs_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN mejrs_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id**
**1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `mejrs_content` AS `c`
INNER JOIN `mejrs_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `mejrs_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `mejrs_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `mejrs_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'**
**1 × SELECT `c2`.`language`,`c2`.`id`
FROM `mejrs_menu` AS `c`
INNER JOIN `mejrs_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `mejrs_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `mejrs_menu` AS `c2`
ON a2.id = c2.`id`**
**1 × SELECT language,id
FROM `mejrs_menu`**
**1 × SELECT h.*, c.title as category, c.parent_id as catcatid
FROM mejrs_zhosmmaps_markergroups as h
LEFT JOIN mejrs_categories as c
ON h.catid=c.id**
**1 × SELECT h.*, c.title as category
FROM mejrs_zhosmmaps_markergroups as h
LEFT JOIN mejrs_categories as c
ON h.catid=c.id**
**1 × SELECT h.*, c.title as category
FROM mejrs_zhosmmaps_maptypes as h
LEFT JOIN mejrs_categories as c
ON h.catid=c.id**
**1 × SELECT h.*, c.title as category
FROM mejrs_zhosmmaps_routers as h
LEFT JOIN mejrs_categories as c
ON h.catid=c.id**
**1 × SELECT h.*, c.title as category
FROM mejrs_zhosmmaps_maps as h
LEFT JOIN mejrs_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.minwidth, bub.maxwidth, bub.minheight, bub.maxheight, bub.disableautopan, bub.published infobubblepublished, bub.offsetx, bub.offsety
FROM mejrs_zhosmmaps_markers as h
LEFT JOIN mejrs_categories as c
ON h.catid=c.id
LEFT JOIN mejrs_zhosmmaps_markergroups as g
ON h.markergroup=g.id
LEFT JOIN mejrs_zhosmmaps_infobubbles as bub
ON h.tabid=bub.id**
**1 × SELECT joomlatablename,tablepkID
FROM `mejrs_falang_tableinfo**
**1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM mejrs_fields AS a
LEFT JOIN `mejrs_languages` AS l
ON l.lang_code = a.language
LEFT JOIN mejrs_users AS uc
ON uc.id=a.checked_out
LEFT JOIN mejrs_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN mejrs_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN mejrs_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `mejrs_fields_categories` AS fc
ON fc.field_id = a.id**
**1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `mejrs_categories` AS `s`
INNER JOIN `mejrs_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('it-IT','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)**
**1 × SELECT `m`.`tag_id`,`t`.*
FROM `mejrs_contentitem_tag_map` AS m
INNER JOIN `mejrs_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 mejrs_content AS a
INNER JOIN mejrs_categories AS c
on c.id = a.catid
LEFT JOIN mejrs_users AS u
on u.id = a.created_by
LEFT JOIN mejrs_categories as parent
ON parent.id = c.parent_id
LEFT JOIN mejrs_content_rating AS v
ON a.id = v.content_id**
**1 × SELECT id, home, template, s.params
FROM mejrs_template_styles as s
LEFT JOIN mejrs_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id**
**1 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `mejrs_extensions`**
**1 × SELECT *
FROM mejrs_languages**
**1 × SELECT m.path
FROM mejrs_menu m**