Query Time: 0.59 ms Query memory: 0.023 MB Memory before query: 3.597 MB Rows returned: 1
SELECT params
FROM enjfl39_extensions
WHERE type = "plugin"
AND folder = "system"
AND element = 'jsnextfw'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_extensions | ref | element_clientid,element_folder_clientid,extension | element_folder_clientid | 804 | const,const | 1 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
15 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
13 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
12 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
11 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
10 | JFalangDatabase->loadResult() | JROOT/plugins/system/jsnextfw/includes/helper.php:164 |
9 | JsnExtFwHelper::getSettings() | JROOT/plugins/system/jsnextfw/jsnextfw.php:137 |
8 | PlgSystemJsnExtFw->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:646 |
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 |
Query Time: 0.34 ms After last query: 2.07 ms Query memory: 0.024 MB Memory before query: 3.612 MB Rows returned: 1
SELECT params
FROM enjfl39_extensions
WHERE type = "component"
AND element = 'com_poweradmin2'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/plugins/system/falangdriver/falang_database.php:351 |
12 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
11 | JFalangDatabase->loadResult() | JROOT/plugins/system/jsnextfw/includes/helper.php:174 |
10 | JsnExtFwHelper::getSettings() | JROOT/administrator/components/com_poweradmin2/helpers/poweradmin2.php:150 |
9 | JSNPowerAdmin2Helper::getConfig() | JROOT/plugins/system/poweradmin2/poweradmin2.php:290 |
8 | plgSystemPowerAdmin2->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:646 |
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 |
Query Time: 11.46 ms After last query: 22.13 ms Query memory: 0.061 MB Memory before query: 3.791 MB Rows returned: 558
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLES
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/plugins/system/falangdriver/falang_database.php:178 |
11 | JFalangDatabase->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:505 |
10 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68 |
9 | JSNConfigHelper::get() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:114 |
8 | PlgSystemJSNMobilize->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:646 |
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 |
Query Time: 2.78 ms After last query: 0.53 ms Query memory: 0.022 MB Memory before query: 3.864 MB Rows returned: 6
SELECT name,value
FROM enjfl39_jsn_mobilize_config
WHERE 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_jsn_mobilize_config | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 6 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81 |
9 | JSNConfigHelper::get() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:114 |
8 | PlgSystemJSNMobilize->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:646 |
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 |
Query Time: 2.50 ms After last query: 3.86 ms Query memory: 0.022 MB Memory before query: 3.812 MB Rows returned: 1
SELECT *
FROM enjfl39_jsn_mobilize_os
WHERE os_type = 'other'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_jsn_mobilize_os | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 12 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/templates/jsn_mobilize/helpers/mobilize.php:445 |
10 | JSNMobilizeTemplateHelper::getOSSupport() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 |
9 | JSNMobilizeTemplateHelper::getConfig() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144 |
8 | PlgSystemJSNMobilize->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:646 |
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 |
Query Time: 3.33 ms After last query: 0.36 ms Query memory: 0.022 MB Memory before query: 3.821 MB Rows returned: 0
SELECT *
FROM enjfl39_jsn_mobilize_profiles AS p
INNER JOIN enjfl39_jsn_mobilize_os_support AS s
ON s.profile_id = p.profile_id
WHERE s.os_id = '11'
AND p.profile_state = 1
AND p.profile_device = "jsn_mobile"
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | p | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
1 | SIMPLE | s | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/plugins/system/falangdriver/falang_database.php:416 |
11 | JFalangDatabase->loadObject() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:512 |
10 | JSNMobilizeTemplateHelper::getOSSupport() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 |
9 | JSNMobilizeTemplateHelper::getConfig() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144 |
8 | PlgSystemJSNMobilize->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:646 |
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 |
Query Time: 1.49 ms After last query: 0.25 ms Query memory: 0.022 MB Memory before query: 3.826 MB Rows returned: 0
SELECT *
FROM enjfl39_jsn_mobilize_design
WHERE profile_id = ''
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_jsn_mobilize_design | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 22 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/templates/jsn_mobilize/helpers/mobilize.php:519 |
10 | JSNMobilizeTemplateHelper::getOSSupport() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 |
9 | JSNMobilizeTemplateHelper::getConfig() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144 |
8 | PlgSystemJSNMobilize->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:646 |
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 |
Query Time: 8.05 ms After last query: 7.64 ms Query memory: 0.150 MB Memory before query: 3.864 MB Rows returned: 146
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 enjfl39_menu AS m
LEFT JOIN enjfl39_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 | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 378 | Using where; Using filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | h650109_newone.m.component_id | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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}() | Same as call in the line below. |
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:76 |
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:131 |
15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:395 |
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:511 |
10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:170 |
8 | PlgSystemJSNMobilize->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:646 |
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 |
Query Time: 2.50 ms After last query: 5.14 ms Query memory: 0.030 MB Memory before query: 4.146 MB Rows returned: 28
SELECT joomlatablename,tablepkID
FROM `enjfl39_falang_tableinfo`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_falang_tableinfo | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 28 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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}() | Same as call in the line below. |
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:76 |
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:131 |
15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:395 |
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:511 |
10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:170 |
8 | PlgSystemJSNMobilize->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:646 |
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 |
Query Time: 2.01 ms After last query: 0.27 ms Query memory: 0.029 MB Memory before query: 4.163 MB Rows returned: 2
SELECT *
FROM enjfl39_languages
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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}() | Same as call in the line below. |
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:76 |
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:131 |
15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:395 |
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:511 |
10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:170 |
8 | PlgSystemJSNMobilize->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:646 |
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 |
Query Time: 0.67 ms After last query: 0.99 ms Query memory: 0.033 MB Memory before query: 4.183 MB Rows returned: 14
SHOW FULL COLUMNS
FROM `enjfl39_languages`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `enjfl39_languages`
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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}() | Same as call in the line below. |
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:76 |
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:131 |
15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:395 |
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:511 |
10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:170 |
8 | PlgSystemJSNMobilize->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:646 |
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 |
Query Time: 15.67 ms After last query: 2.49 ms Query memory: 0.027 MB Memory before query: 4.237 MB Rows returned: 0
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM enjfl39_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(435,498,497,499,500,501,502,503,504,505,506,2765,2766,2767,2768,2769,2770,2771,2772,2773,2801,2802,2803,2804,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,3328,3329,3330,3331,3332,3333,3334,3335,3336,3337,3338,3339,3340,3341,3342,3343,3344,3345,3346,3347,3349,3348,3350,3351,3352,3353,3354,3355,3356,3357,3358,3359,3360,3361,3362,3363,3364,3365,3366,3367,3368,3369,3370,3371,3372,3373,3374,3375,3376,3377,3378,3379,3380,3381,3382,3383,3384,3385,3386,3387,3388,3389,3390,3391,3392,3393,3394,3395,3396,3397,3398,3399,3400,3401,3402,3403,3404,3405,3406,3407,3408,3409,3410,3411,3412,3413,3414,3415,3416,3417,3418,3419,3420,3421,3422,3423,3424,3425,3426,3427,3428,3429,3430,3431,3432,3433,3434,3435,3436,3654,3715)
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 |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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}() | Same as call in the line below. |
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:76 |
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:131 |
15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:395 |
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:511 |
10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:170 |
8 | PlgSystemJSNMobilize->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:646 |
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 |
Query Time: 0.82 ms After last query: 2.37 ms Query memory: 0.025 MB Memory before query: 4.529 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `enjfl39_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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}() | Same as call in the line below. |
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:646 |
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 |
Query Time: 3.21 ms After last query: 0.30 ms Query memory: 0.006 MB Memory before query: 4.522 MB
UPDATE `enjfl39_extensions`
SET `params` = '{\"mediaversion\":\"59bd8f0cf65a7ef9016fcce35e96a592\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `enjfl39_extensions`
SET `params` = '{\"mediaversion\":\"59bd8f0cf65a7ef9016fcce35e96a592\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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:646 |
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 |
Query Time: 1.85 ms After last query: 37.63 ms Query memory: 0.148 MB Memory before query: 4.987 MB Rows returned: 146
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 enjfl39_menu AS m
LEFT JOIN enjfl39_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 | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 378 | Using where; Using filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | h650109_newone.m.component_id | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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}() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/plugins/system/falangdriver/falangdriver.php:370 |
11 | plgSystemFalangdriver->parseRule() | Same as call in the line below. |
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:1120 |
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 |
Query Time: 0.29 ms After last query: 1.16 ms Query memory: 0.026 MB Memory before query: 5.212 MB Rows returned: 0
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM enjfl39_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(435,498,497,499,500,501,502,503,504,505,506,2765,2766,2767,2768,2769,2770,2771,2772,2773,2801,2802,2803,2804,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,3328,3329,3330,3331,3332,3333,3334,3335,3336,3337,3338,3339,3340,3341,3342,3343,3344,3345,3346,3347,3349,3348,3350,3351,3352,3353,3354,3355,3356,3357,3358,3359,3360,3361,3362,3363,3364,3365,3366,3367,3368,3369,3370,3371,3372,3373,3374,3375,3376,3377,3378,3379,3380,3381,3382,3383,3384,3385,3386,3387,3388,3389,3390,3391,3392,3393,3394,3395,3396,3397,3398,3399,3400,3401,3402,3403,3404,3405,3406,3407,3408,3409,3410,3411,3412,3413,3414,3415,3416,3417,3418,3419,3420,3421,3422,3423,3424,3425,3426,3427,3428,3429,3430,3431,3432,3433,3434,3435,3436,3654,3715)
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 |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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}() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/plugins/system/falangdriver/falangdriver.php:370 |
11 | plgSystemFalangdriver->parseRule() | Same as call in the line below. |
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:1120 |
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 |
Query Time: 0.25 ms After last query: 3.71 ms Query memory: 0.023 MB Memory before query: 5.009 MB Rows returned: 1
Duplicate queries:
#5 #72SELECT *
FROM enjfl39_jsn_mobilize_os
WHERE os_type = 'other'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_jsn_mobilize_os | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 12 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/templates/jsn_mobilize/helpers/mobilize.php:445 |
10 | JSNMobilizeTemplateHelper::getOSSupport() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 |
9 | JSNMobilizeTemplateHelper::getConfig() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282 |
8 | PlgSystemJSNMobilize->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:1168 |
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 |
Query Time: 0.37 ms After last query: 0.75 ms Query memory: 0.022 MB Memory before query: 5.007 MB Rows returned: 0
Duplicate queries:
#6 #73SELECT *
FROM enjfl39_jsn_mobilize_profiles AS p
INNER JOIN enjfl39_jsn_mobilize_os_support AS s
ON s.profile_id = p.profile_id
WHERE s.os_id = '11'
AND p.profile_state = 1
AND p.profile_device = "jsn_mobile"
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | p | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
1 | SIMPLE | s | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/plugins/system/falangdriver/falang_database.php:416 |
11 | JFalangDatabase->loadObject() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:512 |
10 | JSNMobilizeTemplateHelper::getOSSupport() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 |
9 | JSNMobilizeTemplateHelper::getConfig() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282 |
8 | PlgSystemJSNMobilize->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:1168 |
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 |
Query Time: 0.91 ms After last query: 0.37 ms Query memory: 0.022 MB Memory before query: 5.012 MB Rows returned: 0
Duplicate queries:
#7 #74SELECT *
FROM enjfl39_jsn_mobilize_design
WHERE profile_id = ''
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_jsn_mobilize_design | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 22 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/templates/jsn_mobilize/helpers/mobilize.php:519 |
10 | JSNMobilizeTemplateHelper::getOSSupport() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 |
9 | JSNMobilizeTemplateHelper::getConfig() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282 |
8 | PlgSystemJSNMobilize->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:1168 |
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 |
Query Time: 3.27 ms After last query: 11.69 ms Query memory: 0.026 MB Memory before query: 5.068 MB Rows returned: 7
SELECT id, home, template, s.params
FROM enjfl39_template_styles as s
LEFT JOIN enjfl39_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 | NO INDEX KEY COULD BE USED | NULL | NULL | 10 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | h650109_newone.s.template,const | 1 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/Application/SiteApplication.php:486 |
19 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/HTML/HTMLHelper.php:365 |
18 | Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() | JROOT/libraries/src/HTML/HTMLHelper.php:712 |
17 | Joomla\CMS\HTML\HTMLHelper::script() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
15 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
14 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/libraries/cms/html/jquery.php:52 |
13 | JHtmlJquery::framework() | Same as call in the line below. |
12 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
11 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
10 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/administrator/components/com_k2/helpers/html.php:259 |
9 | K2HelperHTML::loadHeadIncludes() | JROOT/plugins/system/k2/k2.php:438 |
8 | plgSystemK2->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:1168 |
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 |
Query Time: 5.01 ms After last query: 17.36 ms Query memory: 0.029 MB Memory before query: 5.206 MB Rows returned: 46
SELECT `id`,`name`,`rules`,`parent_id`
FROM `enjfl39_assets`
WHERE `name` IN ('root.1','com_admin','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_easyfrontendseo','com_easyslider','com_falang','com_fields','com_finder','com_imageshow','com_installer','com_jlsitemap','com_joomlaupdate','com_k2','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mobilize','com_modules','com_newsfeeds','com_pagebuilder3','com_plugins','com_postinstall','com_poweradmin2','com_redirect','com_rereplacer','com_search','com_solidres','com_tags','com_templates','com_uniform','com_users','com_wrapper')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 47 | Using index condition |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/Access/Access.php:429 |
17 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
16 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
15 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
14 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
13 | Joomla\CMS\User\User->authorise() | JROOT/plugins/solidres/acl/acl.php:35 |
12 | PlgSolidresACL->authorise() | JROOT/plugins/solidres/acl/acl.php:27 |
11 | PlgSolidresACL->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
10 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
9 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/plugins/system/solidres/solidres.php:81 |
8 | plgSystemSolidres->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:1168 |
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 |
Query Time: 0.83 ms After last query: 62.36 ms Query memory: 0.024 MB Memory before query: 6.382 MB Rows returned: 1
SELECT manifest_cache
FROM enjfl39_extensions
WHERE element LIKE 'jsn_voyage'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_extensions | range | element_clientid,element_folder_clientid | element_clientid | 402 | NULL | 14 | Using index condition |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/plugins/system/falangdriver/falang_database.php:416 |
15 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
14 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
13 | JFalangDatabase->loadResult() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122 |
12 | JSNTplHelper::getManifestCache() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:217 |
11 | JSNTplHelper::getTemplateVersion() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35 |
10 | jsn_template_framework_class_loader() | Same as call in the line below. |
9 | spl_autoload_call() | JROOT/plugins/system/jsntplframework/jsntplframework.php:187 |
8 | PlgSystemJSNTPLFramework->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:1168 |
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 |
Query Time: 0.51 ms After last query: 8.73 ms Query memory: 0.024 MB Memory before query: 6.411 MB Rows returned: 1
SELECT COUNT(*)
FROM enjfl39_extensions
WHERE type = 'component'
AND element = 'com_sh404sef'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using where; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/plugins/system/falangdriver/falang_database.php:351 |
12 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
11 | JFalangDatabase->loadResult() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:1183 |
10 | JSNTplUtils->checkSH404SEF() | JROOT/plugins/system/jsntplframework/includes/core/jsntplframework.php:36 |
9 | JSNTPLFramework::initial() | JROOT/plugins/system/jsntplframework/jsntplframework.php:191 |
8 | PlgSystemJSNTPLFramework->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:1168 |
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 |
Query Time: 0.17 ms After last query: 17.77 ms Query memory: 0.024 MB Memory before query: 6.560 MB Rows returned: 1
SELECT COUNT(*)
FROM enjfl39_extensions
WHERE type = 'component'
AND element = 'com_sh404sef'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using where; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/plugins/system/sunfw/includes/utils.php:81 |
11 | SunFwUtils::checkSH404SEF() | JROOT/plugins/system/sunfw/includes/overwrite/overwrite.php:84 |
10 | SunFwOverwrite::initialize() | JROOT/plugins/system/sunfw/includes/site.php:121 |
9 | SunFwSite->__construct() | JROOT/plugins/system/sunfw/includes/site.php:241 |
8 | SunFwSite::getInstance() | JROOT/plugins/system/sunfw/sunfw.php:383 |
7 | PlgSystemSunFw->onAfterRoute() | JROOT/libraries/joomla/event/dispatcher.php:165 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1168 |
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 |
Query Time: 3.79 ms After last query: 2.14 ms Query memory: 0.093 MB Memory before query: 6.572 MB Rows returned: 1
SELECT ss.*
FROM enjfl39_sunfw_styles AS ss
INNER JOIN enjfl39_template_styles AS ts
ON ts.id = ss.style_id
WHERE ts.id = 21
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ts | const | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
1 | SIMPLE | ss | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/plugins/system/falangdriver/falang_database.php:416 |
11 | JFalangDatabase->loadObject() | JROOT/plugins/system/sunfw/includes/helper.php:253 |
10 | SunFwHelper::getSunFwStyle() | JROOT/plugins/system/sunfw/includes/site.php:140 |
9 | SunFwSite->__construct() | JROOT/plugins/system/sunfw/includes/site.php:241 |
8 | SunFwSite::getInstance() | JROOT/plugins/system/sunfw/sunfw.php:383 |
7 | PlgSystemSunFw->onAfterRoute() | JROOT/libraries/joomla/event/dispatcher.php:165 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1168 |
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 |
Query Time: 3.08 ms After last query: 13.82 ms Query memory: 0.036 MB Memory before query: 7.051 MB Rows returned: 45
SHOW FULL COLUMNS
FROM `enjfl39_sr_experiences`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `enjfl39_sr_experiences`
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
27 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
26 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
24 | JFalangDatabase->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
23 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
22 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
21 | Joomla\CMS\Table\Table->__construct() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/tables/experience.php:18 |
20 | SolidresTableExperience->__construct() | JROOT/libraries/src/Table/Table.php:312 |
19 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:382 |
18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:468 |
17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable() | JROOT/libraries/solidres/model/modeladmin.php:48 |
16 | SRModelAdmin->getTable() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/models/experience.php:265 |
15 | SolidresModelExperience->getTable() | JROOT/libraries/src/MVC/Model/AdminModel.php:969 |
14 | Joomla\CMS\MVC\Model\AdminModel->getItem() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/models/experience.php:292 |
13 | SolidresModelExperience->getItem() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:63 |
12 | SRExperienceHelper::getItem() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:86 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 0.74 ms After last query: 0.31 ms Query memory: 0.027 MB Memory before query: 7.113 MB Rows returned: 1
SELECT *
FROM enjfl39_sr_experiences
WHERE `id` = '12'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_sr_experiences | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/plugins/system/falangdriver/falang_database.php:351 |
17 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:434 |
16 | JFalangDatabase->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
15 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/MVC/Model/AdminModel.php:974 |
14 | Joomla\CMS\MVC\Model\AdminModel->getItem() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/models/experience.php:292 |
13 | SolidresModelExperience->getItem() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:63 |
12 | SRExperienceHelper::getItem() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:86 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 0.44 ms After last query: 0.22 ms Query memory: 0.027 MB Memory before query: 7.156 MB Rows returned: 0
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM enjfl39_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(12)
AND falang_content.reference_table='sr_experiences'
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 | 1 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
18 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
17 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:434 |
16 | JFalangDatabase->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
15 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/MVC/Model/AdminModel.php:974 |
14 | Joomla\CMS\MVC\Model\AdminModel->getItem() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/models/experience.php:292 |
13 | SolidresModelExperience->getItem() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:63 |
12 | SRExperienceHelper::getItem() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:86 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 4.73 ms After last query: 2.07 ms Query memory: 0.024 MB Memory before query: 7.169 MB Rows returned: 0
SELECT `c2`.`language`,`c2`.`id`
FROM `enjfl39_sr_experiences` AS `c`
INNER JOIN `enjfl39_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_solidres.experience'
INNER JOIN `enjfl39_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `enjfl39_sr_experiences` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 12
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/src/Language/Associations.php:115 |
14 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/models/experience.php:302 |
13 | SolidresModelExperience->getItem() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:63 |
12 | SRExperienceHelper::getItem() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:86 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 0.56 ms After last query: 0.32 ms Query memory: 0.024 MB Memory before query: 7.151 MB Rows returned: 1
SELECT `category_id`
FROM `enjfl39_sr_experience_category_xref`
WHERE `experience_id` = 12
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_sr_experience_category_xref | ref | fk_sr_experience_category_xref_sr_experiences1_idx | fk_sr_experience_category_xref_sr_experiences1_idx | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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:178 |
14 | JFalangDatabase->loadColumn() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/models/experience.php:321 |
13 | SolidresModelExperience->getItem() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:63 |
12 | SRExperienceHelper::getItem() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:86 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 1.29 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 7.157 MB Rows returned: 1
SELECT `transportation_id`
FROM `enjfl39_sr_experience_transportation_xref`
WHERE `experience_id` = 12
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_sr_experience_transportation_xref | ref | fk_sr_experience_transportation_xref_sr_experiences_idx | fk_sr_experience_transportation_xref_sr_experiences_idx | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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:178 |
14 | JFalangDatabase->loadColumn() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/models/experience.php:352 |
13 | SolidresModelExperience->getItem() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:63 |
12 | SRExperienceHelper::getItem() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:86 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 2.04 ms After last query: 5.76 ms Query memory: 0.025 MB Memory before query: 7.250 MB Rows returned: 0
SELECT a.*,a2.name AS experience
FROM `enjfl39_sr_extras` AS `a`
LEFT JOIN `enjfl39_sr_experiences` AS `a2`
ON a.experience_id = a2.id
WHERE a.scope = 1
AND a.state = 1
AND a.experience_id = 12
ORDER BY a.ordering asc
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 12 | Using where; Using filesort |
1 | SIMPLE | a2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
15 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
14 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/models/experience.php:374 |
13 | SolidresModelExperience->getItem() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:63 |
12 | SRExperienceHelper::getItem() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:86 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 2.20 ms After last query: 0.36 ms Query memory: 0.025 MB Memory before query: 7.268 MB Rows returned: 0
SELECT a.id, a.guide_id, a.
from, a.to, a2.name AS guide_name, a2.state AS guide_state
FROM `enjfl39_sr_experience_timeslots` AS `a`
INNER JOIN `enjfl39_sr_experience_guides` AS `a2`
ON a2.id = a.guide_id
WHERE a.experience_id = 12
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | fk_exp_timeslots_exp1_idx | fk_exp_timeslots_exp1_idx | 4 | const | 1 | |
1 | SIMPLE | a2 | eq_ref | PRIMARY | PRIMARY | 4 | h650109_newone.a.guide_id | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/solidres/experience/administrator/components/com_solidres/models/experience.php:400 |
13 | SolidresModelExperience->getItem() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:63 |
12 | SRExperienceHelper::getItem() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:86 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 3.01 ms After last query: 0.22 ms Query memory: 0.024 MB Memory before query: 7.275 MB Rows returned: 0
SELECT a.date, a.tariffs
FROM `enjfl39_sr_experience_date_xref` AS `a`
WHERE a.tariffs IS NOT NULL
AND a.experience_id = 12
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | PRIMARY | PRIMARY | 4 | const | 26 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/solidres/experience/administrator/components/com_solidres/models/experience.php:417 |
13 | SolidresModelExperience->getItem() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:63 |
12 | SRExperienceHelper::getItem() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:86 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 2.27 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 7.280 MB Rows returned: 7
SELECT a.id, a.name
FROM `enjfl39_sr_experience_categories` AS `a`
WHERE a.state = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/solidres/experience/experience.php:103 |
16 | PlgSolidresExperience->onSolidresExperiencePrepare() | JROOT/libraries/joomla/event/event.php:70 |
15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
14 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
13 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:67 |
12 | SRExperienceHelper::getItem() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:86 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 0.55 ms After last query: 2.11 ms Query memory: 0.025 MB Memory before query: 7.297 MB Rows returned: 3
SELECT a.id, a.name
FROM `enjfl39_sr_experience_transportations` AS `a`
WHERE a.state = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/solidres/experience/experience.php:137 |
16 | PlgSolidresExperience->onSolidresExperiencePrepare() | JROOT/libraries/joomla/event/event.php:70 |
15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
14 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
13 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:67 |
12 | SRExperienceHelper::getItem() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:86 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 2.00 ms After last query: 0.38 ms Query memory: 0.026 MB Memory before query: 7.311 MB Rows returned: 1
SELECT a.id, a.name, a.code_2, a.code_3
FROM `enjfl39_sr_countries` AS `a`
WHERE a.state = 1
AND a.id = 106
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/plugins/solidres/experience/experience.php:72 |
17 | PlgSolidresExperience->getCountry() | JROOT/plugins/solidres/experience/experience.php:163 |
16 | PlgSolidresExperience->onSolidresExperiencePrepare() | JROOT/libraries/joomla/event/event.php:70 |
15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
14 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
13 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:67 |
12 | SRExperienceHelper::getItem() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:86 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 1.77 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 7.323 MB Rows returned: 0
SELECT a.id, a.summary, a.participants, a.book_date, a.time_slot_id, a.guide_id
FROM `enjfl39_sr_experience_reservations` AS `a`
WHERE a.state <> -2
AND a.state = 1
AND a.experience_id = 12
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | fk_exp_res_exps1_idx | fk_exp_res_exps1_idx | 5 | const | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/solidres/experience/administrator/components/com_solidres/helpers/experience.php:293 |
18 | SRExperienceHelper::getConfirmedReservations() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:309 |
17 | SRExperienceHelper::getAvailableSizes() | JROOT/plugins/solidres/experience/experience.php:193 |
16 | PlgSolidresExperience->onSolidresExperiencePrepare() | JROOT/libraries/joomla/event/event.php:70 |
15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
14 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
13 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:67 |
12 | SRExperienceHelper::getItem() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:86 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 1.21 ms After last query: 0.44 ms Query memory: 0.029 MB Memory before query: 7.337 MB Rows returned: 1
SELECT a.id, a.alias
FROM `enjfl39_sr_experiences` AS `a`
WHERE a.id = 12
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/plugins/system/falangdriver/falang_database.php:416 |
26 | JFalangDatabase->loadObject() | JROOT/components/com_solidres/router.php:130 |
25 | SRRouter->build() | JROOT/components/com_solidres/router.php:299 |
24 | solidresBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
23 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
22 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
21 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
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/solidres/experience/experience.php:201 |
16 | PlgSolidresExperience->onSolidresExperiencePrepare() | JROOT/libraries/joomla/event/event.php:70 |
15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
14 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
13 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:67 |
12 | SRExperienceHelper::getItem() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:86 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 0.10 ms After last query: 0.26 ms Query memory: 0.031 MB Memory before query: 7.355 MB Rows returned: 0
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM enjfl39_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(12)
AND falang_content.reference_table='sr_experiences'
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 | 1 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
33 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
32 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
31 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
30 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
29 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
28 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
27 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
26 | JFalangDatabase->loadObject() | JROOT/components/com_solidres/router.php:130 |
25 | SRRouter->build() | JROOT/components/com_solidres/router.php:299 |
24 | solidresBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
23 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
22 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
21 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
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/solidres/experience/experience.php:201 |
16 | PlgSolidresExperience->onSolidresExperiencePrepare() | JROOT/libraries/joomla/event/event.php:70 |
15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
14 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
13 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:67 |
12 | SRExperienceHelper::getItem() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:86 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 0.95 ms After last query: 13.43 ms Query memory: 0.026 MB Memory before query: 7.399 MB Rows returned: 0
SELECT a.id, a3.name AS target_name
FROM `enjfl39_sr_feedbacks` AS `a`
LEFT JOIN `enjfl39_sr_experience_reservations` AS `a2`
ON a2.id = a.reservation_id
LEFT JOIN `enjfl39_sr_experiences` AS `a3`
ON a3.id = a2.experience_id
WHERE (a.reservation_id > 0 OR a.item_id > 0)
AND a.scope = 1
AND (a3.id = 12 OR a.item_id = 12)
AND a.state = 1
ORDER BY a.id DESC
LIMIT 3
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | index | NULL | PRIMARY | 4 | NULL | 1 | Using where |
1 | SIMPLE | a2 | eq_ref | PRIMARY | PRIMARY | 4 | h650109_newone.a.reservation_id | 1 | |
1 | SIMPLE | a3 | eq_ref | PRIMARY | PRIMARY | 4 | h650109_newone.a2.experience_id | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/MVC/Model/BaseDatabaseModel.php:308 |
19 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
18 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/plugins/solidres/feedback/administrator/components/com_solidres/models/feedbackmodellist.php:233 |
17 | SolidresFeedbackModelList->getItems() | JROOT/plugins/solidres/feedback/components/com_solidres/models/feedbacklist.php:93 |
16 | SolidresModelFeedbackList->getItems() | JROOT/plugins/solidres/feedback/feedback.php:251 |
15 | plgSolidresFeedback->onSolidresFeedbackPrepare() | JROOT/libraries/joomla/event/event.php:70 |
14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
13 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
12 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:161 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 0.43 ms After last query: 0.33 ms Query memory: 0.025 MB Memory before query: 7.411 MB Rows returned: 0
SELECT a.*
FROM `enjfl39_sr_experience_reservations` AS `a`
WHERE a.state = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/solidres/feedback/components/com_solidres/models/feedbacklist.php:142 |
16 | SolidresModelFeedbackList->getItems() | JROOT/plugins/solidres/feedback/feedback.php:251 |
15 | plgSolidresFeedback->onSolidresFeedbackPrepare() | JROOT/libraries/joomla/event/event.php:70 |
14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
13 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
12 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:161 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 2.56 ms After last query: 0.16 ms Query memory: 0.025 MB Memory before query: 7.419 MB Rows returned: 0
SELECT a.id, a.field
FROM `enjfl39_sr_feedback_conditions` AS `a`
WHERE a.scope = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/solidres/feedback/components/com_solidres/models/feedbacklist.php:190 |
16 | SolidresModelFeedbackList->getScores() | JROOT/plugins/solidres/feedback/feedback.php:252 |
15 | plgSolidresFeedback->onSolidresFeedbackPrepare() | JROOT/libraries/joomla/event/event.php:70 |
14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
13 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
12 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:161 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 2.76 ms After last query: 0.25 ms Query memory: 0.026 MB Memory before query: 7.431 MB Rows returned: 0
SELECT count(a.field_id)
FROM `enjfl39_sr_feedback_scores` AS `a`
INNER JOIN `enjfl39_sr_feedbacks` AS `a2`
ON a2.id = a.feedback_id
LEFT JOIN `enjfl39_sr_experience_reservations` AS `a3`
ON a3.id = a2.reservation_id
WHERE a2.scope = 1
AND a2.state = 1
AND (a3.experience_id = 12 OR a2.item_id = 12)
GROUP BY a.field_id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ALL | fk_sr_feedback_scores_sr_feedbacks1_idx | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where; Using temporary; Using filesort |
1 | SIMPLE | a2 | eq_ref | PRIMARY | PRIMARY | 4 | h650109_newone.a.feedback_id | 1 | Using where |
1 | SIMPLE | a3 | eq_ref | PRIMARY | PRIMARY | 4 | h650109_newone.a2.reservation_id | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/plugins/system/falangdriver/falang_database.php:416 |
19 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
18 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
17 | JFalangDatabase->loadResult() | JROOT/plugins/solidres/feedback/components/com_solidres/models/feedbacklist.php:268 |
16 | SolidresModelFeedbackList->getCountCondition() | JROOT/plugins/solidres/feedback/feedback.php:253 |
15 | plgSolidresFeedback->onSolidresFeedbackPrepare() | JROOT/libraries/joomla/event/event.php:70 |
14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
13 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
12 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:161 |
11 | SolidresViewExperience->loadExperience() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:77 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 3.22 ms After last query: 30.25 ms Query memory: 0.027 MB Memory before query: 7.579 MB Rows returned: 0
SELECT r.*
FROM enjfl39_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'articles')
ORDER BY r.ordering, r.id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | r | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/rereplacer/src/Items.php:45 |
22 | RegularLabs\Plugin\System\ReReplacer\Items::getItemList() | JROOT/plugins/system/rereplacer/rereplacer.php:99 |
21 | PlgSystemReReplacer->handleOnContentPrepare() | JROOT/libraries/regularlabs/src/Plugin.php:157 |
20 | RegularLabs\Library\Plugin->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
19 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
18 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
17 | JHtmlContent::prepare() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
15 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
14 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/tmpl/default.php:131 |
13 | include JROOT/plugins/solidres/experience/components/com_solidres/views/experience/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:81 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 6.03 ms After last query: 4.45 ms Query memory: 0.028 MB Memory before query: 7.606 MB Rows returned: 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 enjfl39_fields AS a
LEFT JOIN `enjfl39_languages` AS l
ON l.lang_code = a.language
LEFT JOIN enjfl39_users AS uc
ON uc.id=a.checked_out
LEFT JOIN enjfl39_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN enjfl39_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN enjfl39_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_solidres.experience'
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 | eq_ref | idx_langcode | idx_langcode | 28 | h650109_newone.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | h650109_newone.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | h650109_newone.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | h650109_newone.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | h650109_newone.a.group_id | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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:282 |
25 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
24 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
23 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
22 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
21 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
20 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
19 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
18 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
17 | JHtmlContent::prepare() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
15 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
14 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/tmpl/default.php:131 |
13 | include JROOT/plugins/solidres/experience/components/com_solidres/views/experience/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:81 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 1.17 ms After last query: 2.26 ms Query memory: 0.029 MB Memory before query: 7.625 MB Rows returned: 3
SELECT `name`, `value`
FROM `enjfl39_jsn_imageshow_config`
WHERE `name` IN ('show_quick_icons', 'enable_update_checking', 'number_of_images_on_loading')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_jsn_imageshow_config | range | name | name | 767 | NULL | 3 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
27 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
26 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
24 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_imageshow/classes/jsn_is_parameter.php:81 |
23 | JSNISParameter->getParameters() | JROOT/administrator/components/com_imageshow/imageshow.defines.php:25 |
22 | require_once JROOT/administrator/components/com_imageshow/imageshow.defines.php | JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:16 |
21 | include_once JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php | JROOT/plugins/content/imageshow/imageshow.php:28 |
20 | plgContentImageShow->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
19 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
18 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
17 | JHtmlContent::prepare() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
15 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
14 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/tmpl/default.php:131 |
13 | include JROOT/plugins/solidres/experience/components/com_solidres/views/experience/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:81 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 0.86 ms After last query: 8.84 ms Query memory: 0.028 MB Memory before query: 7.717 MB Rows returned: 1
SELECT *
FROM enjfl39_extensions
WHERE element='com_imageshow'
AND type='component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/administrator/components/com_imageshow/classes/jsn_is_utils.php:310 |
21 | JSNISUtils->getComponentInfo() | JROOT/plugins/content/imageshow/imageshow.php:45 |
20 | plgContentImageShow->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
19 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
18 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
17 | JHtmlContent::prepare() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
15 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
14 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/tmpl/default.php:131 |
13 | include JROOT/plugins/solidres/experience/components/com_solidres/views/experience/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:81 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 2.49 ms After last query: 3.31 ms Query memory: 0.027 MB Memory before query: 7.810 MB Rows returned: 1
SELECT *
FROM `enjfl39_sr_currencies`
WHERE `id` = 2
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_sr_currencies | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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:282 |
21 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
20 | JFalangDatabase->loadObject() | JROOT/libraries/solidres/currency/currency.php:276 |
19 | SRCurrency->getCurrencyDetails() | JROOT/libraries/solidres/currency/currency.php:80 |
18 | SRCurrency->__construct() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:110 |
17 | SRExperienceHelper::getCurrency() | JROOT/plugins/solidres/experience/administrator/components/com_solidres/helpers/experience.php:92 |
16 | SRExperienceHelper::priceFormat() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/tmpl/default_form.php:79 |
15 | include JROOT/plugins/solidres/experience/components/com_solidres/views/experience/tmpl/default_form.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
14 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/tmpl/default.php:204 |
13 | include JROOT/plugins/solidres/experience/components/com_solidres/views/experience/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/plugins/solidres/experience/components/com_solidres/views/experience/view.html.php:81 |
10 | SolidresViewExperience->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_solidres/controller.php:107 |
8 | SolidresController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_solidres/solidres.php:18 |
6 | require_once JROOT/components/com_solidres/solidres.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 |
Query Time: 0.53 ms After last query: 4.38 ms Query memory: 0.021 MB Memory before query: 7.820 MB Rows returned: 1
SELECT language,id
FROM `enjfl39_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 | enjfl39_menu | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 378 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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 |
Query Time: 0.39 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 7.830 MB Rows returned: 0
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM enjfl39_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(435)
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 | 1 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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 |
Query Time: 0.10 ms After last query: 0.50 ms Query memory: 0.021 MB Memory before query: 7.839 MB Rows returned: 0
SELECT `c2`.`language`,`c2`.`id`
FROM `enjfl39_sr_experiences` AS `c`
INNER JOIN `enjfl39_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_solidres.experience'
INNER JOIN `enjfl39_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `enjfl39_sr_experiences` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 12
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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_solidres/helpers/association.php:29 |
8 | SolidresHelperAssociation::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 |
Query Time: 1.62 ms After last query: 7.71 ms Query memory: 0.025 MB Memory before query: 7.879 MB Rows returned: 1
SELECT params
FROM enjfl39_extensions
WHERE type = 'template'
AND element = 'jsn_voyage'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/plugins/system/falangdriver/falang_database.php:351 |
15 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
14 | JFalangDatabase->loadResult() | JROOT/plugins/system/sunfw/includes/helper.php:1436 |
13 | SunFwHelper::getTemplateParams() | JROOT/plugins/system/sunfw/includes/site/helper.php:525 |
12 | SunFwSiteHelper->_autoLoadCustomCssFile() | JROOT/plugins/system/sunfw/includes/site/helper.php:455 |
11 | SunFwSiteHelper->_prepareHead() | JROOT/plugins/system/sunfw/includes/site/helper.php:240 |
10 | SunFwSiteHelper->_prepare() | JROOT/plugins/system/sunfw/includes/site/helper.php:105 |
9 | SunFwSiteHelper::prepare() | JROOT/plugins/system/sunfw/includes/site.php:270 |
8 | SunFwSite->render() | JROOT/templates/jsn_voyage/index.php:20 |
7 | require JROOT/templates/jsn_voyage/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:1076 |
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 |
Query Time: 0.97 ms After last query: 1.28 ms Query memory: 0.025 MB Memory before query: 7.887 MB Rows returned: 1
SELECT manifest_cache
FROM enjfl39_extensions
WHERE type = 'template'
AND element = 'jsn_voyage'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | enjfl39_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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/plugins/system/sunfw/includes/helper.php:77 |
11 | SunFwHelper::getManifestCache() | JROOT/plugins/system/sunfw/includes/site/pages/index.php:28 |
10 | include JROOT/plugins/system/sunfw/includes/site/pages/index.php | JROOT/plugins/system/sunfw/includes/site.php:485 |
9 | SunFwSite->renderLayout() | JROOT/plugins/system/sunfw/includes/site.php:281 |
8 | SunFwSite->render() | JROOT/templates/jsn_voyage/index.php:20 |
7 | require JROOT/templates/jsn_voyage/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:1076 |
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 |
Query Time: 7.97 ms After last query: 2.07 ms Query memory: 0.034 MB Memory before query: 7.968 MB Rows returned: 27
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM enjfl39_modules AS m
LEFT JOIN enjfl39_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN enjfl39_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-04-16 21:14:56')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-16 21:14:56')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 0 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
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 | 189 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | h650109_newone.m.module,const | 1 | Using index condition; Using where |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | h650109_newone.m.id | 1 | Using where; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
29 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
28 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
27 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
26 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/cms/module/helper.php:495 |
25 | JModuleHelper::getModuleList() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/cms/module/helper.php:434 |
24 | JModuleHelper::load() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/cms/module/helper.php:88 |
23 | JModuleHelper::getModules() | JROOT/plugins/system/sunfw/includes/site/components/items/module-position.php:26 |
22 | include JROOT/plugins/system/sunfw/includes/site/components/items/module-position.php | JROOT/plugins/system/sunfw/includes/site.php:528 |
21 | SunFwSite->renderComponent() | JROOT/plugins/system/sunfw/includes/site.php:580 |
20 | SunFwSite::renderItem() | JROOT/plugins/system/sunfw/includes/site/components/column.php:25 |
19 | include JROOT/plugins/system/sunfw/includes/site/components/column.php | JROOT/plugins/system/sunfw/includes/site.php:528 |
18 | SunFwSite->renderComponent() | JROOT/plugins/system/sunfw/includes/site.php:565 |
17 | SunFwSite::renderColumn() | JROOT/plugins/system/sunfw/includes/site/components/row.php:45 |
16 | include JROOT/plugins/system/sunfw/includes/site/components/row.php | JROOT/plugins/system/sunfw/includes/site.php:528 |
15 | SunFwSite->renderComponent() | JROOT/plugins/system/sunfw/includes/site.php:553 |
14 | SunFwSite::renderRow() | JROOT/plugins/system/sunfw/includes/site/components/section.php:26 |
13 | include JROOT/plugins/system/sunfw/includes/site/components/section.php | JROOT/plugins/system/sunfw/includes/site.php:528 |
12 | SunFwSite->renderComponent() | JROOT/plugins/system/sunfw/includes/site.php:541 |
11 | SunFwSite::renderSection() | JROOT/plugins/system/sunfw/includes/site/pages/index.php:194 |
10 | include JROOT/plugins/system/sunfw/includes/site/pages/index.php | JROOT/plugins/system/sunfw/includes/site.php:485 |
9 | SunFwSite->renderLayout() | JROOT/plugins/system/sunfw/includes/site.php:281 |
8 | SunFwSite->render() | JROOT/templates/jsn_voyage/index.php:20 |
7 | require JROOT/templates/jsn_voyage/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:1076 |
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\ |