Query Time: 0.43 ms Query memory: 0.028 MB Memory before query: 8.646 MB Rows returned: 1
SHOW VARIABLES LIKE "collation_database"
EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"
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:1691 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 13 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
| 12 | JFalangDatabase->loadObject() | JROOT/libraries/joomla/database/driver/mysqli.php:327 |
| 11 | JDatabaseDriverMysqli->getCollation() | JROOT/plugins/system/admintools/feature/utf8mb4.php:28 |
| 10 | AtsystemFeatureUtf8mb4->onAfterInitialise() | JROOT/plugins/system/admintools/admintools/main.php:714 |
| 9 | plgSystemAdmintools->runFeature() | JROOT/plugins/system/admintools/admintools/main.php:127 |
| 8 | plgSystemAdmintools->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:686 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.41 ms After last query: 1.94 ms Query memory: 0.029 MB Memory before query: 8.720 MB Rows returned: 0
SELECT `source`,`keepurlparams`
FROM `h8vtf_admintools_redirects`
WHERE ((`dest` = 'en/noclegi-slaskie/zawiercie.html') OR (`dest` = 'en/noclegi-slaskie/zawiercie.html') OR ('en/noclegi-slaskie/zawiercie.html' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | h8vtf_admintools_redirects | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
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:1691 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 14 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
| 13 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
| 12 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:215 |
| 11 | JFalangDatabase->loadRow() | JROOT/plugins/system/admintools/feature/urlredir.php:89 |
| 10 | AtsystemFeatureUrlredir->onAfterInitialise() | JROOT/plugins/system/admintools/admintools/main.php:714 |
| 9 | plgSystemAdmintools->runFeature() | JROOT/plugins/system/admintools/admintools/main.php:127 |
| 8 | plgSystemAdmintools->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:686 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.95 ms After last query: 3.09 ms Query memory: 0.743 MB Memory before query: 9.019 MB Rows returned: 357
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 h8vtf_menu AS m
LEFT JOIN h8vtf_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 | filtered | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 4 | 100.00 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | imlogic3_visiton.m.component_id | 1 | 100.00 | 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:1691 |
| 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:446 |
| 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:64 |
| 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:551 |
| 10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:405 |
| 9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:130 |
| 8 | PlgSystemLanguageFilter->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:686 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.22 ms After last query: 2.04 ms Query memory: 0.037 MB Memory before query: 10.147 MB Rows returned: 19
SELECT joomlatablename,tablepkID
FROM `h8vtf_falang_tableinfo`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | h8vtf_falang_tableinfo | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 19 | 100.00 | NULL |
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:1691 |
| 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:446 |
| 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:64 |
| 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:551 |
| 10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:405 |
| 9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:130 |
| 8 | PlgSystemLanguageFilter->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:686 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.12 ms After last query: 0.14 ms Query memory: 0.040 MB Memory before query: 10.169 MB Rows returned: 2
SELECT *
FROM h8vtf_languages
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | h8vtf_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 100.00 | 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:1691 |
| 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:446 |
| 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:64 |
| 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:551 |
| 10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:405 |
| 9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:130 |
| 8 | PlgSystemLanguageFilter->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:686 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.32 ms After last query: 0.34 ms Query memory: 0.044 MB Memory before query: 10.212 MB Rows returned: 14
SHOW FULL COLUMNS
FROM `h8vtf_languages`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `h8vtf_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:1691 |
| 32 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 31 | JFalangDatabase->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
| 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:446 |
| 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:64 |
| 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:551 |
| 10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:405 |
| 9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:130 |
| 8 | PlgSystemLanguageFilter->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:686 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 33.94 ms After last query: 2.82 ms Query memory: 0.035 MB Memory before query: 10.320 MB Rows returned: 0
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM h8vtf_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(1282,1283,470,860,944,530,816,985,1276,876,814,791,792,772,879,1280,948,984,1260,1261,1259,840,858,789,761,838,839,947,946,943,941,940,938,937,936,932,942,929,997,1035,925,918,922,914,915,923,916,917,919,920,921,924,926,927,928,837,861,873,874,875,933,934,935,939,945,972,931,989,988,987,990,991,992,993,994,995,1262,1266,1277,999,998,1015,1016,1017,1019,1018,1020,1021,958,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1000,1040,1042,1043,1041,1044,1045,1046,1047,1048,1049,1050,1052,1053,1054,1055,1056,1057,1058,1051,1059,1060,1061,1062,1063,1064,1065,1066,1067,1001,1081,1082,1083,1084,1246,1002,1085,1086,1087,1088,1089,1090,1091,1092,1093,1003,1094,1095,1096,1097,1248,1004,1098,1099,1100,1101,1102,1103,1104,1105,1005,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1250,1265,1275,1006,1068,1069,1070,1072,1073,1074,1075,1071,1245,1007,1137,1138,1139,1140,1249,1008,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1308,1009,1038,1036,1037,1039,1010,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1297,1011,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1223,1251,1299,1012,1076,1077,1078,1079,1080,1013,1199,1200,1201,1202,1247,1284,1287,1014,1204,1205,1203,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1224,1225,1226,1227,1228,1229,1230,1285,1286,1254,1263,1264,1278,1279,1281,1300,1302,1303,1304,1301,1295,1296,1305,1306,1307)
AND falang_content.reference_table='menu'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | falang_content | ref | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table | language_id | 4 | const | 1 | 100.00 | 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:1691 |
| 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:446 |
| 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:64 |
| 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:551 |
| 10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:405 |
| 9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:130 |
| 8 | PlgSystemLanguageFilter->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:686 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.31 ms After last query: 1.84 ms Query memory: 0.007 MB Memory before query: 11.073 MB
DELETE
FROM `h8vtf_jhackguard_logs`
WHERE `time` < DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | h8vtf_jhackguard_logs | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 10 | JFalangDatabase->execute() | JROOT/plugins/system/falangdriver/falang_database.php:124 |
| 9 | JFalangDatabase->query() | JROOT/plugins/system/jhackguard/jhackguard.php:145 |
| 8 | PlgSystemJhackguard->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:686 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.23 ms After last query: 0.09 ms Query memory: 0.007 MB Memory before query: 11.081 MB
DELETE
FROM `h8vtf_jhackguard_ip_filters`
WHERE `expires` BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 36500 DAY)
AND DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | h8vtf_jhackguard_ip_filters | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 10 | JFalangDatabase->execute() | JROOT/plugins/system/falangdriver/falang_database.php:124 |
| 9 | JFalangDatabase->query() | JROOT/plugins/system/jhackguard/jhackguard.php:156 |
| 8 | PlgSystemJhackguard->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:686 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.15 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 11.092 MB Rows returned: 0
SELECT `state`,`rule_type`
FROM `h8vtf_jhackguard_ip_filters`
WHERE `ip` = '3.233.224.8'
AND `state` = 1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | 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 |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 13 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 11 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
| 10 | JFalangDatabase->loadObject() | JROOT/plugins/system/jhackguard/jhackguard.php:358 |
| 9 | PlgSystemJhackguard->ip_is() | JROOT/plugins/system/jhackguard/jhackguard.php:174 |
| 8 | PlgSystemJhackguard->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:686 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.64 ms After last query: 14.53 ms Query memory: 0.729 MB Memory before query: 12.674 MB Rows returned: 357
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 h8vtf_menu AS m
LEFT JOIN h8vtf_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 | filtered | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 4 | 100.00 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | imlogic3_visiton.m.component_id | 1 | 100.00 | 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:1691 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 18 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | 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:366 |
| 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:593 |
| 8 | Joomla\CMS\Router\SiteRouter->processParseRules() | JROOT/libraries/src/Router/Router.php:570 |
| 7 | Joomla\CMS\Router\Router->_processParseRules() | JROOT/libraries/src/Router/Router.php:216 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1147 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 46.21 ms After last query: 3.47 ms Query memory: 0.868 MB Memory before query: 13.702 MB Rows returned: 1786
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM h8vtf_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(1282,1283,470,860,944,530,816,985,1276,876,814,791,792,772,879,1280,948,984,1260,1261,1259,840,858,789,761,838,839,947,946,943,941,940,938,937,936,932,942,929,997,1035,925,918,922,914,915,923,916,917,919,920,921,924,926,927,928,837,861,873,874,875,933,934,935,939,945,972,931,989,988,987,990,991,992,993,994,995,1262,1266,1277,999,998,1015,1016,1017,1019,1018,1020,1021,958,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1000,1040,1042,1043,1041,1044,1045,1046,1047,1048,1049,1050,1052,1053,1054,1055,1056,1057,1058,1051,1059,1060,1061,1062,1063,1064,1065,1066,1067,1001,1081,1082,1083,1084,1246,1002,1085,1086,1087,1088,1089,1090,1091,1092,1093,1003,1094,1095,1096,1097,1248,1004,1098,1099,1100,1101,1102,1103,1104,1105,1005,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1250,1265,1275,1006,1068,1069,1070,1072,1073,1074,1075,1071,1245,1007,1137,1138,1139,1140,1249,1008,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1308,1009,1038,1036,1037,1039,1010,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1297,1011,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1223,1251,1299,1012,1076,1077,1078,1079,1080,1013,1199,1200,1201,1202,1247,1284,1287,1014,1204,1205,1203,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1224,1225,1226,1227,1228,1229,1230,1285,1286,1254,1263,1264,1278,1279,1281,1300,1302,1303,1304,1301,1295,1296,1305,1306,1307)
AND falang_content.reference_table='menu'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | falang_content | range | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table | falangContent | 310 | NULL | 880 | 100.00 | Using index condition; 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:1691 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
| 21 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
| 20 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
| 19 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
| 18 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | 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:366 |
| 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:593 |
| 8 | Joomla\CMS\Router\SiteRouter->processParseRules() | JROOT/libraries/src/Router/Router.php:570 |
| 7 | Joomla\CMS\Router\Router->_processParseRules() | JROOT/libraries/src/Router/Router.php:216 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1147 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.58 ms After last query: 75.82 ms Query memory: 0.027 MB Memory before query: 13.184 MB Rows returned: 3
SELECT id, home, template, s.params
FROM h8vtf_template_styles as s
LEFT JOIN h8vtf_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 | filtered | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 100.00 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | imlogic3_visiton.s.template,const | 1 | 100.00 | Using index condition; 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:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 11 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:488 |
| 10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/t3/includes/core/t3.php:320 |
| 9 | T3::detect() | JROOT/plugins/system/t3/t3.php:81 |
| 8 | plgSystemT3->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1156 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.30 ms After last query: 1.10 ms Query memory: 0.032 MB Memory before query: 13.231 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `h8vtf_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | h8vtf_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | 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:1691 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 19 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
| 18 | JFalangDatabase->loadObject() | JROOT/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/djjquerymonster/djjquerymonster.php:58 |
| 8 | plgSystemDJjQueryMonster->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:1156 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.24 ms After last query: 0.21 ms Query memory: 0.009 MB Memory before query: 13.229 MB
UPDATE `h8vtf_extensions`
SET `params` = '{\"mediaversion\":\"b358d2f6775a4f689df852bc18dcb510\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | h8vtf_extensions | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | 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/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/djjquerymonster/djjquerymonster.php:58 |
| 8 | plgSystemDJjQueryMonster->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:1156 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.10 ms After last query: 3.32 ms Query memory: 0.036 MB Memory before query: 13.583 MB Rows returned: 49
SELECT `id`,`name`,`rules`,`parent_id`
FROM `h8vtf_assets`
WHERE `name` IN ('root.1','com_acymailing','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djcatalog2','com_djclassifieds','com_djmediatools','com_djtabs','com_dpcalendar','com_falang','com_fields','com_finder','com_gsd','com_installer','com_jce','com_jcomments','com_jhackguard','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_redirect','com_rsform','com_rstbox','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | h8vtf_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 50 | 100.00 | Using index condition |
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:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 15 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 14 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 13 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 12 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 11 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 10 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_rstbox/helpers/rstbox.php:277 |
| 9 | RstboxHelper::getBoxes() | JROOT/plugins/system/rstbox/rstbox.php:79 |
| 8 | PlgSystemRstBox->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:1156 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.35 ms After last query: 0.63 ms Query memory: 0.029 MB Memory before query: 13.669 MB Rows returned: 1
select b.*
from h8vtf_rstbox b
where b.published = 1
AND b.testmode=0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | b | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
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:1691 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 10 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_rstbox/helpers/rstbox.php:289 |
| 9 | RstboxHelper::getBoxes() | JROOT/plugins/system/rstbox/rstbox.php:79 |
| 8 | PlgSystemRstBox->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:1156 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.36 ms After last query: 0.49 ms Query memory: 0.029 MB Memory before query: 13.722 MB Rows returned: 1
SELECT COUNT(id)
FROM `h8vtf_rstbox_logs`
WHERE `event` = 1
AND `box` = 1
AND `sessionid` = '6fb11ug45tdbdtsr6qhshs6uo0'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | h8vtf_rstbox_logs | ref | box,sessionid | sessionid | 194 | const | 1 | 100.00 | Using index condition; Using where |
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:1691 |
| 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/administrator/components/com_rstbox/helpers/rstbox.php:269 |
| 12 | RstboxHelper::passImpressions() | JROOT/administrator/components/com_rstbox/helpers/rstbox.php:203 |
| 11 | RstboxHelper::passLocalAssignments() | JROOT/administrator/components/com_rstbox/helpers/rstbox.php:137 |
| 10 | RstboxHelper::checkPublishingAssignments() | JROOT/administrator/components/com_rstbox/helpers/rstbox.php:291 |
| 9 | RstboxHelper::getBoxes() | JROOT/plugins/system/rstbox/rstbox.php:79 |
| 8 | PlgSystemRstBox->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:1156 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.84 ms After last query: 18.67 ms Query memory: 0.025 MB Memory before query: 15.778 MB Rows returned: 0
SELECT item_id
FROM h8vtf_djcf_items_promotions
WHERE date_exp <= '2019-12-12 07:34:44'
AND updated=0
GROUP BY item_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | h8vtf_djcf_items_promotions | index | item_id,date_exp | item_id | 4 | NULL | 2019 | 53.59 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 10 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 8 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djpayment.php:891 |
| 7 | DJClassifiedsPayment::updatePromotions() | JROOT/components/com_djclassifieds/djclassifieds.php:103 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.78 ms After last query: 3.75 ms Query memory: 0.070 MB Memory before query: 16.133 MB Rows returned: 39
SELECT c.*
FROM h8vtf_djcf_categories c
WHERE c.published=1
AND c.access_view IN (1,1,5)
ORDER BY c.parent_id, c.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | ref | published | published | 4 | const | 38 | 100.00 | Using where; Using filesort |
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:1691 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 12 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:610 |
| 11 | DJClassifiedsCategory::getCategoriesSortParent() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:139 |
| 10 | DJClassifiedsCategory::getCatAllItemsCount() | JROOT/components/com_djclassifieds/views/items/view.html.php:93 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 3.14 ms After last query: 0.33 ms Query memory: 0.072 MB Memory before query: 16.327 MB Rows returned: 117
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM h8vtf_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(66,68,77,67,69,70,71,72,73,74,75,76,79,80,27,48,49,50,51,52,54,55,56,57,58,59,60,61,62,63,78,81,82,83,85,86,87,88,84)
AND falang_content.reference_table='djcf_categories'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | falang_content | ref | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table | reference_table | 302 | const | 84 | 100.00 | 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:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
| 15 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
| 14 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
| 13 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
| 12 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:610 |
| 11 | DJClassifiedsCategory::getCategoriesSortParent() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:139 |
| 10 | DJClassifiedsCategory::getCatAllItemsCount() | JROOT/components/com_djclassifieds/views/items/view.html.php:93 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 16.91 ms After last query: 0.87 ms Query memory: 0.030 MB Memory before query: 16.339 MB Rows returned: 30
SELECT i.cat_id, count(i.id) as items_count
FROM h8vtf_djcf_items i
WHERE i.published=1
AND i.blocked=0
AND i.date_exp > '2019-12-12 07:00:00'
GROUP BY i.cat_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i | ref | cat_id,published,blocked | published | 4 | const | 7147 | 100.00 | Using where; Using temporary; Using filesort |
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:1691 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 13 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:522 |
| 12 | DJClassifiedsCategory::getItemsCount() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:622 |
| 11 | DJClassifiedsCategory::getCategoriesSortParent() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:139 |
| 10 | DJClassifiedsCategory::getCatAllItemsCount() | JROOT/components/com_djclassifieds/views/items/view.html.php:93 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.41 ms After last query: 0.25 ms Query memory: 0.027 MB Memory before query: 16.353 MB Rows returned: 0
SELECT ic.cat_id, count(ic.item_id) as items_count
FROM h8vtf_djcf_items_categories ic, h8vtf_djcf_items i
WHERE ic.item_id=i.id
AND i.published=1
AND i.blocked=0
AND i.date_exp > '2019-12-12 07:00:00'
GROUP BY ic.cat_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | 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 |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 14 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 12 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:631 |
| 11 | DJClassifiedsCategory::getCategoriesSortParent() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:139 |
| 10 | DJClassifiedsCategory::getCatAllItemsCount() | JROOT/components/com_djclassifieds/views/items/view.html.php:93 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.38 ms After last query: 0.44 ms Query memory: 0.029 MB Memory before query: 16.374 MB Rows returned: 0
SELECT *
FROM h8vtf_djcf_images
WHERE type='category'
AND item_id IN (66,68,77)
GROUP BY item_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | h8vtf_djcf_images | ref | item_id,type | type | 167 | const | 1 | 100.00 | Using index condition; Using where; Using temporary; Using filesort |
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:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 11 | JFalangDatabase->loadObjectList() | JROOT/components/com_djclassifieds/models/items.php:1145 |
| 10 | DjclassifiedsModelItems->getCatImages() | JROOT/components/com_djclassifieds/views/items/view.html.php:105 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.42 ms After last query: 0.23 ms Query memory: 0.034 MB Memory before query: 16.384 MB Rows returned: 16
SELECT r.*
FROM h8vtf_djcf_regions r
WHERE r.parent_id=0
ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | r | ref | parent_id | parent_id | 4 | const | 13 | 100.00 | Using where; Using filesort |
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:1691 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 13 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:501 |
| 12 | DJClassifiedsRegion::getRegionsMain() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:120 |
| 11 | DJClassifiedsRegion::getSubReg() | JROOT/components/com_djclassifieds/models/items.php:257 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.67 ms After last query: 0.25 ms Query memory: 0.033 MB Memory before query: 16.432 MB Rows returned: 16
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM h8vtf_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(34,35,36,230,37,27,38,39,30,40,41,42,43,44,45,46)
AND falang_content.reference_table='djcf_regions'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | falang_content | range | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table | falangContent | 310 | NULL | 16 | 75.00 | Using index condition; Using where |
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:1691 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
| 16 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
| 15 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
| 14 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
| 13 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:501 |
| 12 | DJClassifiedsRegion::getRegionsMain() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:120 |
| 11 | DJClassifiedsRegion::getSubReg() | JROOT/components/com_djclassifieds/models/items.php:257 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 17.22 ms After last query: 0.16 ms Query memory: 0.168 MB Memory before query: 16.442 MB Rows returned: 1619
SELECT i.region_id, count(i.id) as items_count
FROM h8vtf_djcf_items i
WHERE i.published=1
AND i.date_exp > '2019-12-12 07:34:44'
GROUP BY i.region_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i | ref | region_id,published | published | 4 | const | 7147 | 100.00 | Using where; Using temporary; Using filesort |
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:1691 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 13 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:506 |
| 12 | DJClassifiedsRegion::getRegionsMain() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:120 |
| 11 | DJClassifiedsRegion::getSubReg() | JROOT/components/com_djclassifieds/models/items.php:257 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 11.23 ms After last query: 1.49 ms Query memory: 0.748 MB Memory before query: 16.448 MB Rows returned: 2104
SELECT r.*
FROM h8vtf_djcf_regions r
ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | r | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2104 | 100.00 | Using filesort |
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:1691 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 13 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:561 |
| 12 | DJClassifiedsRegion::getRegionsSortParent() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:121 |
| 11 | DJClassifiedsRegion::getSubReg() | JROOT/components/com_djclassifieds/models/items.php:257 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 180.19 ms After last query: 131.31 ms Query memory: 0.373 MB Memory before query: 20.666 MB Rows returned: 2086
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM h8vtf_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(34,35,36,230,37,27,38,39,30,40,41,42,43,44,45,46,1144,1082,1617,28,82,468,324,1121,1315,325,53,555,368,961,621,844,87,1460,1161,1080,1005,668,1040,1145,1476,559,1626,345,474,1630,1011,2056,1631,438,1633,706,335,1634,1474,409,89,1708,1023,1715,586,2058,1178,652,833,330,564,477,895,92,375,693,767,1721,1009,1081,1024,1251,633,2088,342,611,525,1456,412,1415,1014,1074,1013,939,1417,2036,1168,403,373,1025,486,1455,659,779,634,2132,1462,620,94,80,1452,2062,86,1090,1006,463,692,858,1076,717,786,408,357,1755,752,614,1155,1478,1008,1096,1019,1010,867,1761,1093,816,562,1468,1026,1767,88,1007,1411,778,825,83,93,780,1016,1001,849,2194,1459,346,334,1004,1414,451,480,736,1465,1458,608,766,1017,1015,1146,350,835,1308,615,1020,478,1022,518,360,623,1783,1166,940,85,2178,2059,2121,456,707,1333,616,853,1139,497,415,1042,1003,1472,442,639,1354,1793,2023,1461,1798,1811,1813,598,999,514,1021,1475,840,526,507,700,1138,515,1814,1018,320,1470,91,1471,1816,570,1416,1412,1043,1083,862,1819,354,2047,610,1467,29,1094,1466,531,604,1131,723,1000,1002,734,618,712,730,1136,84,1115,1469,81,1012,675,2042,595,1822,1147,1381,1389,2181,1483,106,333,1484,1485,1379,1346,903,1486,1488,1436,2003,1427,2050,1449,1287,214,213,32,1445,1382,1490,1492,2012,852,1454,2013,108,2069,1373,1044,1439,947,215,2179,2136,1062,556,1378,1376,1494,2110,1496,770,1428,1450,2182,1374,1498,1500,1480,107,672,1059,2103,338,1503,1518,2016,1352,1524,1437,1526,1438,2070,2014,31,212,1548,1448,1562,321,1055,1567,1061,819,883,1355,1372,1574,1453,1479,1052,1370,104,1116,1375,1442,2180,105,2015,1481,1371,1489,1493,1501,49,646,1406,1276,1070,976,698,731,1265,1487,1202,995,755,973,1274,573,1285,2064,990,998,449,1410,710,62,1250,493,385,630,1491,572,563,1256,851,1409,980,925,568,1088,812,1214,655,522,814,628,636,383,656,1341,997,1084,59,795,694,678,979,558,992,517,1150,818,2048,505,761,2193,66,782,394,67,681,402,781,2032,741,1158,785,657,435,1357,989,499,1401,986,1264,492,994,495,347,390,1495,352,763,823,921,751,391,491,472,1223,382,1497,2033,977,643,872,695,987,1499,996,455,729,648,1133,1407,645,993,942,830,2044,609,856,870,1041,577,427,983,407,612,61,574,473,711,1504,1506,584,1508,1095,602,2184,1141,1194,622,1402,981,411,1154,601,1153,839,490,460,1211,1325,498,401,869,488,428,627,509,1404,721,2030,591,880,644,353,1405,1403,339,974,1513,1515,2061,984,776,722,64,1533,426,413,575,384,670,975,400,978,65,985,381,508,703,1536,462,475,60,801,576,557,1537,1257,1541,430,2185,2031,452,1543,1408,982,1098,379,991,1544,63,2071,2084,1549,1089,726,1262,1552,1553,528,988,1555,1558,2085,1568,1572,619,1637,594,860,715,660,1570,1035,583,69,1032,1034,804,1575,1577,406,72,70,1030,1036,1586,2109,1589,440,367,759,387,560,2108,450,737,720,326,1592,1593,1596,1599,599,1600,580,1604,483,1605,605,1029,1608,749,838,713,380,632,1614,848,1031,1618,1619,1622,1621,398,327,1033,1623,484,1624,1625,1628,1629,1091,682,864,1636,1126,1027,1340,571,1028,1639,2086,68,719,582,1640,71,1642,444,198,1644,565,431,1645,746,1060,467,1319,196,1647,1038,1650,1037,1137,791,685,197,1143,561,1169,1662,1664,223,1666,2006,1668,918,1670,2195,1444,1673,2017,2197,1675,2072,225,232,802,1464,1677,2128,75,1419,1679,1213,1277,897,1424,1682,1278,1711,74,2019,1418,2018,1421,1435,1423,496,231,234,233,1691,1693,1225,1420,2186,227,224,1696,2068,1698,1700,2020,1422,1702,1463,1426,1705,229,1707,1709,1425,226,1226,1207,1227,73,1502,52,1507,1510,1512,1294,1514,1516,1517,1520,705,2131,1522,1527,1530,242,2087,249,1534,1539,77,2034,680,709,850,1546,78,1551,2129,1556,1560,2150,1566,1569,1039,855,1571,1576,241,250,252,1579,1581,1582,1260,1584,1320,815,173,243,1587,1591,1595,79,2196,2051,1598,1601,753,1606,677,1609,316,432,54,1825,810,2134,1827,1828,1392,1310,2066,1832,2011,1834,1175,1244,1839,1360,1842,1846,1849,2133,1852,1853,1124,1856,1861,312,1864,2039,2055,2192,183,822,901,1869,1871,420,902,941,1887,1889,1356,2090,1892,2099,1894,2010,1904,1907,1912,1915,796,1917,1919,725,1925,1927,1928,683,1933,1053,100,1237,1938,180,99,1343,1259,762,581,2141,732,534,184,579,1943,1946,175,959,1950,1953,1955,566,1199,502,1956,771,1958,2098,834,1960,1961,1962,1054,1964,1200,185,1966,419,96,181,98,1967,740,1969,1970,177,1971,1216,2089,832,1338,1451,1973,1974,418,2057,529,2122,97,95,1976,1064,2137,178,744,789,313,1384,2073,1977,1978,1980,1982,1129,1119,1349,1983,1985,716,1986,1988,1198,1829,1830,2168,1105,1118,2154,960,1833,103,2166,194,2164,2169,191,1835,190,1836,1838,1840,2053,1841,733,2157,363,2161,1843,1845,1847,1848,1850,1100,1108,2162,1855,1857,2167,2170,2158,2153,2067,1858,1860,187,189,2155,188,2165,195,1862,1863,1866,102,1152,1156,1867,192,1868,2163,2159,1872,2156,101,1873,1874,1876,1877,2160,47,56,109,239,1607,1363,1611,1615,1627,1322,1632,481,1635,2117,1299,1184,1638,836,2022,1648,414,2009,1653,2135,1224,238,1657,1661,1671,1399,2065,1680,1684,1688,1364,1694,424,803,461,111,1713,421,236,1726,1735,240,1744,1101,1753,2152,651,1776,237,1788,2143,110,1795,1377,1805,306,454,308,1810,1812,1447,875,743,471,142,1896,1114,686,631,2028,600,1815,629,699,917,944,2063,513,300,127,800,578,663,790,569,946,1820,1821,1302,1905,1823,1071,913,2124,144,907,933,504,1067,896,1826,650,2118,1151,393,910,115,121,1210,885,950,640,1206,861,2027,916,567,783,1367,112,116,305,470,625,369,2024,813,2126,955,826,626,934,396,436,607,806,788,909,702,1948,125,170,805,429,372,124,1954,1321,445,747,487,1086,873,932,2054,613,114,1212,768,772,503,588,479,943,863,1243,597,1111,2025,745,936,2145,1859,953,512,433,958,596,949,587,392,510,603,1047,2183,929,552,1203,1433,126,482,957,120,1875,376,1050,457,1393,362,956,890,119,1174,1353,546,118,2026,329,911,1879,945,448,642,1881,1109,728,837,948,506,1397,319,606,952,1057,2146,539,459,697,2094,951,876,113,593,1885,303,769,962,1173,2144,122,638,1117,123,937,635,821,441,2093,617,908,653,871,524,397,117,521,1045,1429,868,954,1380,1350,370,927,1886,1097,1888,131,1891,148,443,1898,149,1255,1160,547,1075,2120,1910,151,1248,145,2041,828,2114,1921,150,1926,1110,1931,689,1441,1936,129,153,1941,1159,923,541,1132,688,793,889,1073,1957,186,1959,894,679,1107,1965,1106,735,1252,757,553,1968,1148,146,1972,374,2125,1329,2095,1975,884,673,676,1254,279,829,1979,1981,1984,1987,684,1989,1990,1077,674,658,2119,1991,288,1992,1157,754,1993,1994,2045,1995,1249,1996,179,1997,708,1998,687,666,2140,130,669,1999,275,2000,2001,2002,774,289,1253,1565,147,773,641,388,691,132,724,2091,2101,1482,219,1505,1509,364,1511,1519,221,1521,2102,1369,1523,222,216,1525,1528,551,1529,422,535,1531,2139,220,2188,2130,1532,1535,1538,1540,2100,2007,1542,1545,135,133,1547,1550,1554,218,217,1557,1559,1563,1339,2107,2092,1564,661,317,1317,1130,2076,365,48,51,930,1573,1112,1177,854,1218,1580,304,1239,1186,501,1208,2106,1368,290,1323,1113,920,544,756,2004,283,293,439,935,1171,2081,1583,1125,161,1385,162,322,1162,1279,1234,2074,1123,172,245,799,1351,1242,1585,1196,1165,1219,1197,361,1395,1348,1398,58,1266,1289,1334,1309,1104,1072,1192,1079,1288,284,277,423,963,292,1179,425,485,1217,285,371,1588,1280,1122,1304,1312,1590,1189,881,1232,301,311,136,1241,358,1195,886,2075,1230,1275,2080,282,1362,1594,169,1342,295,1305,1303,1324,299,1190,1127,156,1286,511,1394,286,1388,1292,1281,1228,57,171,176,1597,453,297,155,1221,585,1235,1099,1602,1391,287,1245,1603,1300,1240,1347,1201,1193,164,159,797,1120,291,154,1267,163,1610,647,1268,1220,1345,887,158,1314,550,841,1336,931,2112,1185,536,2079,1269,336,1387,549,281,2148,1246,1215,1261,592,160,168,1247,1295,1612,1087,1361,924,1337,157,2077,2111,174,1183,1298,2105,1335,1170,2082,294,1176,416,1613,1301,1222,1209,2113,2078,1318,1616,1307,542,516,1780,654,1434,922,824,314,1258,926,1326,276,1238,1191,417,1297,1233,1205,278,1128,1284,1390,331,1332,298,1181,915,296,1620,1344,906,1641,1643,2149,1078,1646,2052,879,1649,1651,1652,165,847,1654,1655,1656,2191,2138,912,866,255,1658,1659,827,1660,2005,891,1182,523,1272,843,1663,1665,1263,259,256,760,1667,1669,1672,1674,261,1676,742,718,1678,2035,739,1681,904,1327,1683,1685,1686,1687,1065,2040,1689,1271,1690,137,323,2190,665,667,1330,359,2096,1692,2151,1695,1697,1699,1701,1703,1704,1706,888,1710,1712,1714,1058,1716,2187,1717,1718,1719,1720,714,1722,1724,792,892,254,1728,1732,257,1739,2060,1741,777,138,1167,1742,1270,877,1745,1746,1747,1749,1751,1754,2142,1757,798,1759,1762,548,1764,758,1766,466,1282,1769,1771,664,784,1773,1774,1777,1778,1779,1048,2038,900,2046,253,1781,1049,1785,1316,1063,1787,1790,318,1792,738,258,898,882,1797,1800,2037,1359,260,332,1801,1803,899,1806,50,1890,458,395,1366,55,519,1893,1895,1313,309,389,1283,1430,1204,206,540,1897,1296,809,1358,500,494,469,447,207,1899,140,166,878,1900,340,404,968,1901,1902,2104,1236,1102,1903,554,2097,1328,307,590,831,1085,1906,1908,624,1909,1911,919,538,1331,1913,302,1914,209,1916,967,1188,928,351,748,1142,970,969,200,1290,446,139,377,727,2127,2029,1135,1918,845,1443,355,1400,366,972,971,328,1920,589,141,1922,696,208,1923,1924,1051,857,1440,476,671,808,434,405,966,1092,794,1172,637,1446,2123,1929,399,520,1930,337,2189,1273,1932,1934,811,893,965,464,1311,1937,530,1939,1306,1940,205,1396,1140,543,537,1069,210,356,914,905,1291,764,787,1149,437,817,349,344,1944,202,1945,378,204,341,410,1164,465,203,1231,1432,1293,1947,865,1229,1949,1068,1951,750,211,1046,532,1180,1431,964,846,1163,348,1365,1952,489,527,1187,545,1134,343,533,310,1723,266,1725,859,1727,1729,2177,268,1731,1733,2021,265,1734,2173,2115,1737,1738,1740,1772,274,2147,1748,271,1750,267,1752,1756,807,842,1758,269,270,2008,1760,1763,1765,1770,1802,2176,2175,273,1804,2116,264,2172,765,1807,1066,1808,1809,262,1784,1786,2043,2049,1789,1791,1794,2174,263,2171,1796,1799)
AND falang_content.reference_table='djcf_regions'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | falang_content | ref | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table | falangContent | 4 | const | 318 | 100.00 | Using index condition; Using where |
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:1691 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
| 16 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
| 15 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
| 14 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
| 13 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:561 |
| 12 | DJClassifiedsRegion::getRegionsSortParent() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:121 |
| 11 | DJClassifiedsRegion::getSubReg() | JROOT/components/com_djclassifieds/models/items.php:257 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 19.80 ms After last query: 530.33 ms Query memory: 0.168 MB Memory before query: 20.364 MB Rows returned: 1619
SELECT i.region_id, count(i.id) as items_count
FROM h8vtf_djcf_items i
WHERE i.published=1
AND i.date_exp > '2019-12-12 07:34:44'
GROUP BY i.region_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i | ref | region_id,published | published | 4 | const | 7147 | 100.00 | Using where; Using temporary; Using filesort |
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:1691 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 13 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:566 |
| 12 | DJClassifiedsRegion::getRegionsSortParent() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:121 |
| 11 | DJClassifiedsRegion::getSubReg() | JROOT/components/com_djclassifieds/models/items.php:257 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 12.27 ms After last query: 7.65 ms Query memory: 0.749 MB Memory before query: 20.418 MB Rows returned: 2104
SELECT r.*
FROM h8vtf_djcf_regions r
ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | r | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2104 | 100.00 | Using filesort |
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:1691 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 14 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:434 |
| 13 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:312 |
| 12 | DJClassifiedsRegion::getParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:133 |
| 11 | DJClassifiedsRegion::getSubReg() | JROOT/components/com_djclassifieds/models/items.php:257 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 178.68 ms After last query: 96.63 ms Query memory: 0.374 MB Memory before query: 24.638 MB Rows returned: 2086
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM h8vtf_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(34,35,36,230,37,27,38,39,30,40,41,42,43,44,45,46,1144,1082,1617,28,82,468,324,1121,1315,325,53,555,368,961,621,844,87,1460,1161,1080,1005,668,1040,1145,1476,559,1626,345,474,1630,1011,2056,1631,438,1633,706,335,1634,1474,409,89,1708,1023,1715,586,2058,1178,652,833,330,564,477,895,92,375,693,767,1721,1009,1081,1024,1251,633,2088,342,611,525,1456,412,1415,1014,1074,1013,939,1417,2036,1168,403,373,1025,486,1455,659,779,634,2132,1462,620,94,80,1452,2062,86,1090,1006,463,692,858,1076,717,786,408,357,1755,752,614,1155,1478,1008,1096,1019,1010,867,1761,1093,816,562,1468,1026,1767,88,1007,1411,778,825,83,93,780,1016,1001,849,2194,1459,346,334,1004,1414,451,480,736,1465,1458,608,766,1017,1015,1146,350,835,1308,615,1020,478,1022,518,360,623,1783,1166,940,85,2178,2059,2121,456,707,1333,616,853,1139,497,415,1042,1003,1472,442,639,1354,1793,2023,1461,1798,1811,1813,598,999,514,1021,1475,840,526,507,700,1138,515,1814,1018,320,1470,91,1471,1816,570,1416,1412,1043,1083,862,1819,354,2047,610,1467,29,1094,1466,531,604,1131,723,1000,1002,734,618,712,730,1136,84,1115,1469,81,1012,675,2042,595,1822,1147,1381,1389,2181,1483,106,333,1484,1485,1379,1346,903,1486,1488,1436,2003,1427,2050,1449,1287,214,213,32,1445,1382,1490,1492,2012,852,1454,2013,108,2069,1373,1044,1439,947,215,2179,2136,1062,556,1378,1376,1494,2110,1496,770,1428,1450,2182,1374,1498,1500,1480,107,672,1059,2103,338,1503,1518,2016,1352,1524,1437,1526,1438,2070,2014,31,212,1548,1448,1562,321,1055,1567,1061,819,883,1355,1372,1574,1453,1479,1052,1370,104,1116,1375,1442,2180,105,2015,1481,1371,1489,1493,1501,49,646,1406,1276,1070,976,698,731,1265,1487,1202,995,755,973,1274,573,1285,2064,990,998,449,1410,710,62,1250,493,385,630,1491,572,563,1256,851,1409,980,925,568,1088,812,1214,655,522,814,628,636,383,656,1341,997,1084,59,795,694,678,979,558,992,517,1150,818,2048,505,761,2193,66,782,394,67,681,402,781,2032,741,1158,785,657,435,1357,989,499,1401,986,1264,492,994,495,347,390,1495,352,763,823,921,751,391,491,472,1223,382,1497,2033,977,643,872,695,987,1499,996,455,729,648,1133,1407,645,993,942,830,2044,609,856,870,1041,577,427,983,407,612,61,574,473,711,1504,1506,584,1508,1095,602,2184,1141,1194,622,1402,981,411,1154,601,1153,839,490,460,1211,1325,498,401,869,488,428,627,509,1404,721,2030,591,880,644,353,1405,1403,339,974,1513,1515,2061,984,776,722,64,1533,426,413,575,384,670,975,400,978,65,985,381,508,703,1536,462,475,60,801,576,557,1537,1257,1541,430,2185,2031,452,1543,1408,982,1098,379,991,1544,63,2071,2084,1549,1089,726,1262,1552,1553,528,988,1555,1558,2085,1568,1572,619,1637,594,860,715,660,1570,1035,583,69,1032,1034,804,1575,1577,406,72,70,1030,1036,1586,2109,1589,440,367,759,387,560,2108,450,737,720,326,1592,1593,1596,1599,599,1600,580,1604,483,1605,605,1029,1608,749,838,713,380,632,1614,848,1031,1618,1619,1622,1621,398,327,1033,1623,484,1624,1625,1628,1629,1091,682,864,1636,1126,1027,1340,571,1028,1639,2086,68,719,582,1640,71,1642,444,198,1644,565,431,1645,746,1060,467,1319,196,1647,1038,1650,1037,1137,791,685,197,1143,561,1169,1662,1664,223,1666,2006,1668,918,1670,2195,1444,1673,2017,2197,1675,2072,225,232,802,1464,1677,2128,75,1419,1679,1213,1277,897,1424,1682,1278,1711,74,2019,1418,2018,1421,1435,1423,496,231,234,233,1691,1693,1225,1420,2186,227,224,1696,2068,1698,1700,2020,1422,1702,1463,1426,1705,229,1707,1709,1425,226,1226,1207,1227,73,1502,52,1507,1510,1512,1294,1514,1516,1517,1520,705,2131,1522,1527,1530,242,2087,249,1534,1539,77,2034,680,709,850,1546,78,1551,2129,1556,1560,2150,1566,1569,1039,855,1571,1576,241,250,252,1579,1581,1582,1260,1584,1320,815,173,243,1587,1591,1595,79,2196,2051,1598,1601,753,1606,677,1609,316,432,54,1825,810,2134,1827,1828,1392,1310,2066,1832,2011,1834,1175,1244,1839,1360,1842,1846,1849,2133,1852,1853,1124,1856,1861,312,1864,2039,2055,2192,183,822,901,1869,1871,420,902,941,1887,1889,1356,2090,1892,2099,1894,2010,1904,1907,1912,1915,796,1917,1919,725,1925,1927,1928,683,1933,1053,100,1237,1938,180,99,1343,1259,762,581,2141,732,534,184,579,1943,1946,175,959,1950,1953,1955,566,1199,502,1956,771,1958,2098,834,1960,1961,1962,1054,1964,1200,185,1966,419,96,181,98,1967,740,1969,1970,177,1971,1216,2089,832,1338,1451,1973,1974,418,2057,529,2122,97,95,1976,1064,2137,178,744,789,313,1384,2073,1977,1978,1980,1982,1129,1119,1349,1983,1985,716,1986,1988,1198,1829,1830,2168,1105,1118,2154,960,1833,103,2166,194,2164,2169,191,1835,190,1836,1838,1840,2053,1841,733,2157,363,2161,1843,1845,1847,1848,1850,1100,1108,2162,1855,1857,2167,2170,2158,2153,2067,1858,1860,187,189,2155,188,2165,195,1862,1863,1866,102,1152,1156,1867,192,1868,2163,2159,1872,2156,101,1873,1874,1876,1877,2160,47,56,109,239,1607,1363,1611,1615,1627,1322,1632,481,1635,2117,1299,1184,1638,836,2022,1648,414,2009,1653,2135,1224,238,1657,1661,1671,1399,2065,1680,1684,1688,1364,1694,424,803,461,111,1713,421,236,1726,1735,240,1744,1101,1753,2152,651,1776,237,1788,2143,110,1795,1377,1805,306,454,308,1810,1812,1447,875,743,471,142,1896,1114,686,631,2028,600,1815,629,699,917,944,2063,513,300,127,800,578,663,790,569,946,1820,1821,1302,1905,1823,1071,913,2124,144,907,933,504,1067,896,1826,650,2118,1151,393,910,115,121,1210,885,950,640,1206,861,2027,916,567,783,1367,112,116,305,470,625,369,2024,813,2126,955,826,626,934,396,436,607,806,788,909,702,1948,125,170,805,429,372,124,1954,1321,445,747,487,1086,873,932,2054,613,114,1212,768,772,503,588,479,943,863,1243,597,1111,2025,745,936,2145,1859,953,512,433,958,596,949,587,392,510,603,1047,2183,929,552,1203,1433,126,482,957,120,1875,376,1050,457,1393,362,956,890,119,1174,1353,546,118,2026,329,911,1879,945,448,642,1881,1109,728,837,948,506,1397,319,606,952,1057,2146,539,459,697,2094,951,876,113,593,1885,303,769,962,1173,2144,122,638,1117,123,937,635,821,441,2093,617,908,653,871,524,397,117,521,1045,1429,868,954,1380,1350,370,927,1886,1097,1888,131,1891,148,443,1898,149,1255,1160,547,1075,2120,1910,151,1248,145,2041,828,2114,1921,150,1926,1110,1931,689,1441,1936,129,153,1941,1159,923,541,1132,688,793,889,1073,1957,186,1959,894,679,1107,1965,1106,735,1252,757,553,1968,1148,146,1972,374,2125,1329,2095,1975,884,673,676,1254,279,829,1979,1981,1984,1987,684,1989,1990,1077,674,658,2119,1991,288,1992,1157,754,1993,1994,2045,1995,1249,1996,179,1997,708,1998,687,666,2140,130,669,1999,275,2000,2001,2002,774,289,1253,1565,147,773,641,388,691,132,724,2091,2101,1482,219,1505,1509,364,1511,1519,221,1521,2102,1369,1523,222,216,1525,1528,551,1529,422,535,1531,2139,220,2188,2130,1532,1535,1538,1540,2100,2007,1542,1545,135,133,1547,1550,1554,218,217,1557,1559,1563,1339,2107,2092,1564,661,317,1317,1130,2076,365,48,51,930,1573,1112,1177,854,1218,1580,304,1239,1186,501,1208,2106,1368,290,1323,1113,920,544,756,2004,283,293,439,935,1171,2081,1583,1125,161,1385,162,322,1162,1279,1234,2074,1123,172,245,799,1351,1242,1585,1196,1165,1219,1197,361,1395,1348,1398,58,1266,1289,1334,1309,1104,1072,1192,1079,1288,284,277,423,963,292,1179,425,485,1217,285,371,1588,1280,1122,1304,1312,1590,1189,881,1232,301,311,136,1241,358,1195,886,2075,1230,1275,2080,282,1362,1594,169,1342,295,1305,1303,1324,299,1190,1127,156,1286,511,1394,286,1388,1292,1281,1228,57,171,176,1597,453,297,155,1221,585,1235,1099,1602,1391,287,1245,1603,1300,1240,1347,1201,1193,164,159,797,1120,291,154,1267,163,1610,647,1268,1220,1345,887,158,1314,550,841,1336,931,2112,1185,536,2079,1269,336,1387,549,281,2148,1246,1215,1261,592,160,168,1247,1295,1612,1087,1361,924,1337,157,2077,2111,174,1183,1298,2105,1335,1170,2082,294,1176,416,1613,1301,1222,1209,2113,2078,1318,1616,1307,542,516,1780,654,1434,922,824,314,1258,926,1326,276,1238,1191,417,1297,1233,1205,278,1128,1284,1390,331,1332,298,1181,915,296,1620,1344,906,1641,1643,2149,1078,1646,2052,879,1649,1651,1652,165,847,1654,1655,1656,2191,2138,912,866,255,1658,1659,827,1660,2005,891,1182,523,1272,843,1663,1665,1263,259,256,760,1667,1669,1672,1674,261,1676,742,718,1678,2035,739,1681,904,1327,1683,1685,1686,1687,1065,2040,1689,1271,1690,137,323,2190,665,667,1330,359,2096,1692,2151,1695,1697,1699,1701,1703,1704,1706,888,1710,1712,1714,1058,1716,2187,1717,1718,1719,1720,714,1722,1724,792,892,254,1728,1732,257,1739,2060,1741,777,138,1167,1742,1270,877,1745,1746,1747,1749,1751,1754,2142,1757,798,1759,1762,548,1764,758,1766,466,1282,1769,1771,664,784,1773,1774,1777,1778,1779,1048,2038,900,2046,253,1781,1049,1785,1316,1063,1787,1790,318,1792,738,258,898,882,1797,1800,2037,1359,260,332,1801,1803,899,1806,50,1890,458,395,1366,55,519,1893,1895,1313,309,389,1283,1430,1204,206,540,1897,1296,809,1358,500,494,469,447,207,1899,140,166,878,1900,340,404,968,1901,1902,2104,1236,1102,1903,554,2097,1328,307,590,831,1085,1906,1908,624,1909,1911,919,538,1331,1913,302,1914,209,1916,967,1188,928,351,748,1142,970,969,200,1290,446,139,377,727,2127,2029,1135,1918,845,1443,355,1400,366,972,971,328,1920,589,141,1922,696,208,1923,1924,1051,857,1440,476,671,808,434,405,966,1092,794,1172,637,1446,2123,1929,399,520,1930,337,2189,1273,1932,1934,811,893,965,464,1311,1937,530,1939,1306,1940,205,1396,1140,543,537,1069,210,356,914,905,1291,764,787,1149,437,817,349,344,1944,202,1945,378,204,341,410,1164,465,203,1231,1432,1293,1947,865,1229,1949,1068,1951,750,211,1046,532,1180,1431,964,846,1163,348,1365,1952,489,527,1187,545,1134,343,533,310,1723,266,1725,859,1727,1729,2177,268,1731,1733,2021,265,1734,2173,2115,1737,1738,1740,1772,274,2147,1748,271,1750,267,1752,1756,807,842,1758,269,270,2008,1760,1763,1765,1770,1802,2176,2175,273,1804,2116,264,2172,765,1807,1066,1808,1809,262,1784,1786,2043,2049,1789,1791,1794,2174,263,2171,1796,1799)
AND falang_content.reference_table='djcf_regions'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | falang_content | ref | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table | falangContent | 4 | const | 318 | 100.00 | 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:1691 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
| 17 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
| 16 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
| 15 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
| 14 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:434 |
| 13 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:312 |
| 12 | DJClassifiedsRegion::getParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:133 |
| 11 | DJClassifiedsRegion::getSubReg() | JROOT/components/com_djclassifieds/models/items.php:257 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 19.95 ms After last query: 440.01 ms Query memory: 0.171 MB Memory before query: 24.312 MB Rows returned: 1619
SELECT i.region_id, count(i.id) as items_count
FROM h8vtf_djcf_items i
WHERE i.published=1
AND i.date_exp > '2019-12-12 07:34:45'
GROUP BY i.region_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i | ref | region_id,published | published | 4 | const | 7147 | 100.00 | Using where; Using temporary; Using filesort |
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:1691 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 14 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:439 |
| 13 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:312 |
| 12 | DJClassifiedsRegion::getParentPath() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:133 |
| 11 | DJClassifiedsRegion::getSubReg() | JROOT/components/com_djclassifieds/models/items.php:257 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.01 ms After last query: 4.16 ms Query memory: 0.049 MB Memory before query: 24.389 MB Rows returned: 3
SELECT i.*, c.name AS c_name,c.alias AS c_alias, c.id as c_id, c.rev_group_id, r.name as r_name, r.id as r_id , u.name as username
FROM h8vtf_djcf_items i
LEFT JOIN h8vtf_djcf_categories c
ON i.cat_id = c.id
LEFT JOIN h8vtf_djcf_regions r
ON i.region_id = r.id
LEFT JOIN h8vtf_users u
ON i.user_id = u.id
WHERE i.date_exp > '2019-12-12 07:34:46'
AND i.published=1
AND i.blocked=0
AND c.published=1
AND c.restriction_18=0
AND i.region_id IN (147)
AND c.access_view IN (0,1,1,5)
ORDER BY i.special DESC, i.date_start ASC
LIMIT 0, 20
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i | ref | cat_id,region_id,published,blocked | region_id | 4 | const | 2 | 100.00 | Using where; Using filesort |
| 1 | SIMPLE | r | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | eq_ref | PRIMARY,published | PRIMARY | 4 | imlogic3_visiton.i.cat_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | imlogic3_visiton.i.user_id | 1 | 100.00 | NULL |
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:1691 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 12 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 11 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/components/com_djclassifieds/models/items.php:359 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.93 ms After last query: 0.37 ms Query memory: 0.031 MB Memory before query: 24.467 MB Rows returned: 7
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM h8vtf_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(5401,267,5919)
AND falang_content.reference_table='djcf_items'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | falang_content | range | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table | idxFalang1 | 4 | NULL | 6 | 83.33 | 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:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
| 15 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
| 14 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
| 13 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
| 12 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 11 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/components/com_djclassifieds/models/items.php:359 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.55 ms After last query: 0.19 ms Query memory: 0.031 MB Memory before query: 24.479 MB Rows returned: 8
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM h8vtf_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(49,27)
AND falang_content.reference_table='djcf_categories'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | falang_content | range | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table | idxFalang1 | 4 | NULL | 5 | 80.00 | 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:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
| 15 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
| 14 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
| 13 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
| 12 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 11 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/components/com_djclassifieds/models/items.php:359 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.54 ms After last query: 0.27 ms Query memory: 0.030 MB Memory before query: 24.491 MB Rows returned: 1
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM h8vtf_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(147)
AND falang_content.reference_table='djcf_regions'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | falang_content | ref | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table | falangContent | 310 | const,const,const | 1 | 100.00 | 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:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
| 15 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
| 14 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
| 13 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
| 12 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 11 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/components/com_djclassifieds/models/items.php:359 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.13 ms After last query: 0.17 ms Query memory: 0.028 MB Memory before query: 24.502 MB Rows returned: 0
SELECT fv.item_id, fv.field_id, fv.value, fv.value_date, fv.value_date_to, f.label, f.type
FROM h8vtf_djcf_fields_values fv,h8vtf_djcf_fields f
WHERE fv.item_id IN (5401,267,5919)
AND f.id=fv.field_id
AND (f.in_table>0 OR f.in_blog=1)
AND f.access=0
AND f.published=1
ORDER BY fv.item_id,f.ordering, f.label
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | fv | range | field_id,item_id | item_id | 4 | NULL | 245 | 100.00 | Using index condition; Using temporary; Using filesort |
| 1 | SIMPLE | f | eq_ref | PRIMARY,published | PRIMARY | 4 | imlogic3_visiton.fv.field_id | 1 | 100.00 | 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:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 11 | JFalangDatabase->loadObjectList() | JROOT/components/com_djclassifieds/models/items.php:383 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.27 ms After last query: 0.16 ms Query memory: 0.030 MB Memory before query: 24.484 MB Rows returned: 3
SELECT img.*
FROM h8vtf_djcf_images img
WHERE img.item_id IN (5401,267,5919)
AND img.type='item'
ORDER BY img.item_id, img.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | img | range | item_id,type | item_id | 4 | NULL | 3 | 100.00 | Using index condition; Using where; Using filesort |
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:1691 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 12 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djimage.php:427 |
| 11 | DJClassifiedsImage::getAdsImages() | JROOT/components/com_djclassifieds/models/items.php:386 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.22 ms After last query: 0.14 ms Query memory: 0.029 MB Memory before query: 24.495 MB Rows returned: 0
SELECT *
FROM h8vtf_djcf_images
WHERE item_id IN (1335,1014,1073)
AND type='profile'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | h8vtf_djcf_images | ref | item_id,type | type | 167 | const | 2 | 100.00 | Using index condition; 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:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 11 | JFalangDatabase->loadObjectList() | JROOT/components/com_djclassifieds/models/items.php:401 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:132 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
| 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:267 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.29 ms After last query: 0.14 ms Query memory: 0.029 MB Memory before query: 24.504 MB Rows returned: 0
