Abfragezeit: 0.42 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.035 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `ginz_session`
WHERE `session_id` = X'72676a32646c7373656a397332756e746d61696175636f396e37'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Derselbe Aufruf in der Zeile darunter. |
| 13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
| 12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
| 11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:661 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.28 ms Nach letzter Abfrage: 1.07 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.050 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `ginz_session`
WHERE `session_id` = X'72676a32646c7373656a397332756e746d61696175636f396e37'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.31 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 1.055 MB
INSERT INTO `ginz_session`
(`session_id`,`guest`,`time`,`userid`,`username`)
VALUES
(X'72676a32646c7373656a397332756e746d61696175636f396e37', 1, 1701781546, 0, '')
„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `ginz_session`
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
(X'72676a32646c7373656a397332756e746d61696175636f396e37', 1, 1701781546, 0, '')
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.38 ms Nach letzter Abfrage: 4.49 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.197 MB Zeilen zurückgegeben: 3
SELECT id, rules
FROM `ginz_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_viewlevels | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 3 | |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.40 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.209 MB Zeilen zurückgegeben: 1
SELECT b.id
FROM ginz_usergroups AS a
LEFT JOIN ginz_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | Using where; Using index |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.83 ms Nach letzter Abfrage: 35.45 ms Abfragespeichernutzung: 0.065 MB Speichernutzung vor Abfrage: 3.532 MB Zeilen zurückgegeben: 176
SELECT setting,value
FROM ginz_jfbconnect_config
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_jfbconnect_config | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 176 | |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 15 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_jfbconnect/models/config.php:316 |
| 14 | JFBConnectModelConfig->getSettings() | JROOT/administrator/components/com_jfbconnect/models/config.php:354 |
| 13 | JFBConnectModelConfig->get() | JROOT/administrator/components/com_jfbconnect/models/config.php:401 |
| 12 | JFBConnectModelConfig->getSetting() | JROOT/components/com_jfbconnect/libraries/provider.php:36 |
| 11 | JFBConnectProvider->__construct() | JROOT/components/com_jfbconnect/libraries/provider/amazon.php:21 |
| 10 | JFBConnectProviderAmazon->__construct() | JROOT/components/com_jfbconnect/libraries/factory.php:58 |
| 9 | JFBCFactory::provider() | JROOT/components/com_jfbconnect/libraries/factory.php:92 |
| 8 | JFBCFactory::getAllProviders() | JROOT/plugins/system/jfbcsystem/jfbcsystem.php:40 |
| 7 | plgSystemJFBCSystem->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.38 ms Nach letzter Abfrage: 1.81 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 3.705 MB Zeilen zurückgegeben: 1
SELECT value
FROM ginz_jfbconnect_config
WHERE setting="profile_joomla"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_jfbconnect_config | const | setting | setting | 152 | const | 1 | |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 17 | JDatabaseDriver->loadResult() | JROOT/libraries/sourcecoast/plugins/socialprofile.php:609 |
| 16 | SocialProfilePlugin->loadSettings() | JROOT/libraries/sourcecoast/plugins/socialprofile.php:170 |
| 15 | SocialProfilePlugin->socialProfilesGetRequiredScope() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 12 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/components/com_jfbconnect/libraries/profile/amazon.php:55 |
| 11 | JFBConnectProfileAmazon->getRequiredScope() | JROOT/components/com_jfbconnect/libraries/provider/amazon.php:35 |
| 10 | JFBConnectProviderAmazon->setupAuthentication() | JROOT/components/com_jfbconnect/libraries/factory.php:59 |
| 9 | JFBCFactory::provider() | JROOT/components/com_jfbconnect/libraries/factory.php:92 |
| 8 | JFBCFactory::getAllProviders() | JROOT/plugins/system/jfbcsystem/jfbcsystem.php:40 |
| 7 | plgSystemJFBCSystem->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.19 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 3.717 MB Zeilen zurückgegeben: 1
SELECT value
FROM ginz_jfbconnect_config
WHERE setting="profile_customdb"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_jfbconnect_config | const | setting | setting | 152 | const | 1 | |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 17 | JDatabaseDriver->loadResult() | JROOT/libraries/sourcecoast/plugins/socialprofile.php:609 |
| 16 | SocialProfilePlugin->loadSettings() | JROOT/libraries/sourcecoast/plugins/socialprofile.php:170 |
| 15 | SocialProfilePlugin->socialProfilesGetRequiredScope() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 12 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/components/com_jfbconnect/libraries/profile/amazon.php:55 |
| 11 | JFBConnectProfileAmazon->getRequiredScope() | JROOT/components/com_jfbconnect/libraries/provider/amazon.php:35 |
| 10 | JFBConnectProviderAmazon->setupAuthentication() | JROOT/components/com_jfbconnect/libraries/factory.php:59 |
| 9 | JFBCFactory::provider() | JROOT/components/com_jfbconnect/libraries/factory.php:92 |
| 8 | JFBCFactory::getAllProviders() | JROOT/plugins/system/jfbcsystem/jfbcsystem.php:40 |
| 7 | plgSystemJFBCSystem->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.64 ms Nach letzter Abfrage: 46.94 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 5.147 MB Zeilen zurückgegeben: 1
SELECT template
FROM ginz_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_client_id,idx_client_id_home | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 11 | Using where |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 13 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
| 12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 |
| 11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
| 10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
| 9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 |
| 8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.43 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 5.155 MB Zeilen zurückgegeben: 1
SELECT template
FROM ginz_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_client_id,idx_client_id_home | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 11 | Using where |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 14 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
| 13 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 |
| 12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 |
| 11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
| 10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
| 9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 |
| 8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.40 ms Nach letzter Abfrage: 3.53 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 5.277 MB Zeilen zurückgegeben: 4
SELECT extension, file, type
FROM ginz_rokcommon_configs
ORDER BY priority
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_rokcommon_configs | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 4 | filesort wurde genutzt |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rokcommon/rokcommon.php:131 |
| 8 | plgSystemRokCommon->processRegisteredConfigs() | JROOT/plugins/system/rokcommon/rokcommon.php:75 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.66 ms Nach letzter Abfrage: 15.04 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 5.396 MB Zeilen zurückgegeben: 1
SELECT `enabled`
FROM ginz_extensions
WHERE `element` = 'com_configbox'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_extensions | ref | element_clientid,element_folder_clientid | element_clientid | 402 | const | 1 | Using index condition |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 9 | JDatabaseDriver->loadResult() | JROOT/plugins/system/configbox/configbox.php:27 |
| 8 | PlgSystemConfigbox->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:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.00 ms Nach letzter Abfrage: 7.81 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.636 MB Zeilen zurückgegeben: 18
SHOW FULL COLUMNS
FROM `ginz_extensions`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `ginz_extensions`
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 13 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
| 12 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 11 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Extension.php:32 |
| 10 | Joomla\CMS\Table\Extension->__construct() | JROOT/libraries/src/Table/Table.php:328 |
| 9 | Joomla\CMS\Table\Table::getInstance() | JROOT/plugins/system/roksprocket/roksprocket.php:45 |
| 8 | plgSystemRokSprocket->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:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.49 ms Nach letzter Abfrage: 0.94 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 5.665 MB Zeilen zurückgegeben: 1
SELECT `extension_id`
FROM `ginz_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 10 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Table/Extension.php:124 |
| 9 | Joomla\CMS\Table\Extension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:47 |
| 8 | plgSystemRokSprocket->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:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.26 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 5.672 MB Zeilen zurückgegeben: 1
SELECT *
FROM ginz_extensions
WHERE `extension_id` = '10057'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
| 9 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/roksprocket/roksprocket.php:54 |
| 8 | plgSystemRokSprocket->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:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.36 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 5.676 MB Zeilen zurückgegeben: 1
SELECT `extension_id`
FROM `ginz_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_extensions | ref | element_clientid,element_folder_clientid,extension | element_folder_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.14 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 10 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Table/Extension.php:124 |
| 9 | Joomla\CMS\Table\Extension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:70 |
| 8 | plgSystemRokSprocket->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:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 5.684 MB Zeilen zurückgegeben: 1
SELECT *
FROM ginz_extensions
WHERE `extension_id` = '10057'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
| 9 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/roksprocket/roksprocket.php:76 |
| 8 | plgSystemRokSprocket->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:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.95 ms Nach letzter Abfrage: 109.09 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 6.060 MB
UPDATE `ginz_extensions`
SET `params` = '{\"mediaversion\":\"7c98046e0a29cee04f0c4904098dfcbc\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
„EXPLAIN“ unmöglich für Abfrage: UPDATE `ginz_extensions`
SET `params` = '{\"mediaversion\":\"7c98046e0a29cee04f0c4904098dfcbc\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.13 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init for update | 0.30 ms |
| Updating | 0.12 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 14 | JDatabaseDriverMysqli->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:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.68 ms Nach letzter Abfrage: 4.22 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 6.080 MB Zeilen zurückgegeben: 1
SELECT `template`,`id`,`title`,`params`,`home`
FROM `ginz_template_styles`
WHERE `id`='41'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_template_styles | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.08 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 12 | JDatabaseDriver->loadObject() | JROOT/libraries/astroid/framework/library/astroid/Template.php:218 |
| 11 | Astroid\Template->_getById() | JROOT/libraries/astroid/framework/library/astroid/Template.php:33 |
| 10 | Astroid\Template->__construct() | JROOT/libraries/astroid/framework/library/astroid/Framework.php:32 |
| 9 | Astroid\Framework::init() | JROOT/plugins/system/astroid/astroid.php:35 |
| 8 | plgSystemAstroid->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:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.25 ms Nach letzter Abfrage: 11.30 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 6.259 MB Zeilen zurückgegeben: 8
SHOW FULL COLUMNS
FROM `ginz_template_styles`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `ginz_template_styles`
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.01 ms |
| closing tables | 0.01 ms |
| Opening tables | 0.40 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| checking permissions | 0.09 ms |
| closing tables | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.12 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
| 13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 12 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_templates/tables/style.php:30 |
| 11 | TemplatesTableStyle->__construct() | JROOT/libraries/src/Table/Table.php:328 |
| 10 | Joomla\CMS\Table\Table::getInstance() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:1028 |
| 9 | plgSystemEF4_JMFramework->getTemplateName() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:209 |
| 8 | plgSystemEF4_JMFramework->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:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.36 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 6.277 MB Zeilen zurückgegeben: 1
SELECT *
FROM ginz_template_styles
WHERE `id` = '41'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_template_styles | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
| 10 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:1029 |
| 9 | plgSystemEF4_JMFramework->getTemplateName() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:209 |
| 8 | plgSystemEF4_JMFramework->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:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.86 ms Nach letzter Abfrage: 6.27 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 6.389 MB Zeilen zurückgegeben: 8
SELECT id, home, template, s.params
FROM ginz_template_styles as s
LEFT JOIN ginz_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 11 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | admin_ginz.s.template,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.15 ms |
| Preparing | 0.04 ms |
| Executing | 0.00 ms |
| Sending data | 0.20 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:2182 |
| 10 | JMFTemplate::getTemplateStyleId() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:136 |
| 9 | JMFTemplate->__construct() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:296 |
| 8 | plgSystemEF4_JMFramework->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:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.75 ms Nach letzter Abfrage: 13.86 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 6.702 MB Zeilen zurückgegeben: 0
SELECT item_id
FROM ginz_djcf_items_promotions
WHERE date_exp <= '2023-12-05 13:05:47'
AND updated=0
GROUP BY item_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_djcf_items_promotions | index | date_exp | item_id | 4 | NULL | 164 | Using where |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.22 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 8 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djpayment.php:779 |
| 7 | DJClassifiedsPayment::updatePromotions() | JROOT/components/com_djclassifieds/djclassifieds.php:115 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.72 ms Nach letzter Abfrage: 12.40 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 6.848 MB Zeilen zurückgegeben: 12
SELECT f.*
FROM ginz_djcf_fields f
WHERE f.published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | published | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 12 | Using where |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.05 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.12 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djclassifieds/models/items.php:1278 |
| 10 | DjclassifiedsModelItems->resetSearchFilters() | JROOT/components/com_djclassifieds/views/items/view.html.php:85 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.69 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 6.855 MB Zeilen zurückgegeben: 56
SELECT *
FROM ginz_djcf_categories
WHERE published=1
AND access_view IN (1,1)
ORDER BY parent_id, name ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_djcf_categories | ALL | published | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 48 | Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.04 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.28 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:549 |
| 12 | DJClassifiedsCategory::getAllCategories() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:588 |
| 11 | DJClassifiedsCategory::getCategoriesSortParent() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:231 |
| 10 | DJClassifiedsCategory::getSubCatIemsCount() | JROOT/components/com_djclassifieds/views/items/view.html.php:90 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.45 ms Nach letzter Abfrage: 0.94 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 6.989 MB Zeilen zurückgegeben: 1
SELECT *
FROM ginz_djcf_images
WHERE type='category'
AND item_id IN (2,17,53,14,11,74,26,4,64,10,8,20,75,19,9,76,48,6,5,7,46,72,23,3,70)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_djcf_images | ref | item_id,type | type | 167 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.01 ms |
| table lock | 0.00 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.13 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djimage.php:480 |
| 10 | DJClassifiedsImage::getCatImages() | JROOT/components/com_djclassifieds/views/items/view.html.php:109 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.64 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 6.997 MB Zeilen zurückgegeben: 56
SELECT *
FROM ginz_djcf_categories
WHERE published=1
AND access_view IN (1,1)
ORDER BY parent_id, ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_djcf_categories | ALL | published | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 48 | Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.33 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:549 |
| 12 | DJClassifiedsCategory::getAllCategories() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:563 |
| 11 | DJClassifiedsCategory::getCategories() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:276 |
| 10 | DJClassifiedsCategory::getParentPath() | JROOT/components/com_djclassifieds/views/items/view.html.php:135 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.33 ms Nach letzter Abfrage: 0.38 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.089 MB Zeilen zurückgegeben: 1
SELECT *
FROM ginz_djcf_categories
WHERE id=1
AND published=1
AND access_view IN (1,1)
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_djcf_categories | const | PRIMARY,published | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 11 | JDatabaseDriver->loadObject() | JROOT/components/com_djclassifieds/models/items.php:879 |
| 10 | DjclassifiedsModelItems->getMainCat() | JROOT/components/com_djclassifieds/views/items/view.html.php:161 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.28 ms Nach letzter Abfrage: 1.90 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.097 MB Zeilen zurückgegeben: 1
SELECT *
FROM ginz_djcf_regions
WHERE id=1
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_djcf_regions | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 11 | JDatabaseDriver->loadObject() | JROOT/components/com_djclassifieds/models/items.php:899 |
| 10 | DjclassifiedsModelItems->getMainRegions() | JROOT/components/com_djclassifieds/views/items/view.html.php:285 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.25 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 7.104 MB Zeilen zurückgegeben: 8
SELECT r.*
FROM ginz_djcf_regions r
ORDER BY r.parent_id, name ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | r | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 8 | filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.07 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:484 |
| 12 | DJClassifiedsRegion::getAllRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:523 |
| 11 | DJClassifiedsRegion::getRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:321 |
| 10 | DJClassifiedsRegion::getParentPath() | JROOT/components/com_djclassifieds/views/items/view.html.php:288 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.30 ms Nach letzter Abfrage: 1.54 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.129 MB Zeilen zurückgegeben: 2
SELECT *
FROM ginz_djcf_types
WHERE published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_djcf_types | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 4 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.01 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djclassifieds/models/items.php:1297 |
| 10 | DjclassifiedsModelItems->getTypes() | JROOT/components/com_djclassifieds/views/items/view.html.php:348 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.29 ms Nach letzter Abfrage: 0.46 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 7.140 MB Zeilen zurückgegeben: 1
SELECT r.*
FROM ginz_djcf_regions r
WHERE r.parent_id=0
ORDER BY r.parent_id, ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | r | ref | parent_id | parent_id | 4 | const | 1 | Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.04 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:509 |
| 13 | DJClassifiedsRegion::getMainRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:548 |
| 12 | DJClassifiedsRegion::getRegionsMain() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:127 |
| 11 | DJClassifiedsRegion::getSubReg() | JROOT/components/com_djclassifieds/models/items.php:281 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:383 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.28 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 7.155 MB Zeilen zurückgegeben: 8
SELECT r.*
FROM ginz_djcf_regions r
ORDER BY r.parent_id, name ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | r | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 8 | filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.07 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:484 |
| 13 | DJClassifiedsRegion::getAllRegions() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:573 |
| 12 | DJClassifiedsRegion::getRegionsSortParent() | JROOT/administrator/components/com_djclassifieds/lib/djregion.php:128 |
| 11 | DJClassifiedsRegion::getSubReg() | JROOT/components/com_djclassifieds/models/items.php:281 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:383 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 16.85 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.155 MB Speichernutzung vor Abfrage: 7.186 MB Zeilen zurückgegeben: 20
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, r.alias as r_alias , u.name as username
FROM ginz_djcf_items i
LEFT JOIN ginz_djcf_categories c
ON i.cat_id = c.id
LEFT JOIN ginz_djcf_regions r
ON i.region_id = r.id
LEFT JOIN ginz_users u
ON i.user_id = u.id
LEFT JOIN ( SELECT item_id, count(id) as mcat_c
FROM ginz_djcf_items_categories
WHERE cat_id IN (1,1,2,17,53,14,11,74,26,4,64,10,8,20,75,19,9,76,48,6,5,7,46,72,23,3,70)
GROUP BY item_id ) mc
ON i.id=mc.item_id
WHERE i.blocked=0
AND c.published!=0
AND (i.cat_id IN (1,1,2,17,53,14,11,74,26,4,64,10,8,20,75,19,9,76,48,6,5,7,46,72,23,3,70) OR mc.mcat_c>0)
AND i.region_id IN (1,196148,384528,136055,196363,196366,736055,196370)
AND c.access_view IN (0,1,1)
AND i.published=1
AND i.date_exp > '2023-12-05 13:05:47'
ORDER BY i.special DESC, c.name ASC
LIMIT 100, 20
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | ALL | PRIMARY,published | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 48 | Using where; Using temporary; filesort wurde genutzt |
| 1 | PRIMARY | i | ref | cat_id,region_id,published,blocked,date_exp | cat_id | 4 | admin_ginz.c.id | 12 | Using where |
| 1 | PRIMARY | r | eq_ref | PRIMARY | PRIMARY | 4 | admin_ginz.i.region_id | 1 | |
| 1 | PRIMARY | u | eq_ref | PRIMARY | PRIMARY | 4 | admin_ginz.i.user_id | 1 | |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | admin_ginz.i.id | 10 | Using where |
| 2 | DERIVED | ginz_djcf_items_categories | ALL | item_id,cat_id | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 328 | Using where; Using temporary; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.23 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.22 ms |
| Optimizing | 0.05 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.15 ms |
| Statistics | 0.30 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| Preparing | 0.04 ms |
| Creating tmp table | 0.09 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.13 ms |
| Executing | 0.01 ms |
| Sending data | 0.28 ms |
| Creating sort index | 0.15 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 9.20 ms |
| Creating sort index | 2.60 ms |
| Removing tmp table | 2.67 ms |
| Creating sort index | 0.07 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.03 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.05 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 11 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/components/com_djclassifieds/models/items.php:417 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:383 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 4.84 ms Nach letzter Abfrage: 0.44 ms Abfragespeichernutzung: 0.105 MB Speichernutzung vor Abfrage: 7.466 MB Zeilen zurückgegeben: 94
SELECT f.*, fv.item_id, fv.field_id, fv.value, fv.value_date, fv.value_date_to, fg.name group_name
FROM ginz_djcf_fields_values fv
INNER JOIN ginz_djcf_fields f
ON f.id=fv.field_id
LEFT JOIN ginz_djcf_fields_groups fg
ON f.group_id=fg.id
AND fg.published=1
WHERE fv.item_id IN (448763,448778,448786,448795,448797,448801,448867,448939,448814,295331,427971,427972,448685,448691,448740,53928,71769,71771,72830,445879)
AND f.access IN (1,1)
AND f.published=1
AND (f.in_table>0 OR f.in_blog=1)
AND (fg.access IS NULL OR fg.access IN (1,1))
ORDER BY fv.item_id, f.ordering, f.label
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | PRIMARY,published | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 12 | Using where; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | fg | eq_ref | PRIMARY | PRIMARY | 4 | admin_ginz.f.group_id | 1 | Using where |
| 1 | SIMPLE | fv | ref|filter | field_id,type_id | field_id|type_id | 4|4 | admin_ginz.f.id | 151 (4%) | Using where; Using rowid filter |
| Status | Duration |
|---|
| Starting | 0.15 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.11 ms |
| Optimizing | 0.10 ms |
| Statistics | 0.46 ms |
| Preparing | 0.06 ms |
| Creating tmp table | 0.10 ms |
| Sorting result | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 2.71 ms |
| Creating sort index | 0.58 ms |
| Removing tmp table | 0.20 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djclassifieds/models/items.php:450 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:383 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.44 ms Nach letzter Abfrage: 1.13 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 7.724 MB Zeilen zurückgegeben: 90
SELECT img.*
FROM ginz_djcf_images img
WHERE img.item_id IN (448763,448778,448786,448795,448797,448801,448867,448939,448814,295331,427971,427972,448685,448691,448740,53928,71769,71771,72830,445879)
AND img.type='item'
ORDER BY img.item_id, img.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | img | range | item_id,type | item_id | 4 | NULL | 90 | Using index condition; Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.05 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.19 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.73 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djimage.php:285 |
| 12 | DJClassifiedsImage::_getAdsImagesRaw() | JROOT/administrator/components/com_djclassifieds/lib/djimage.php:292 |
| 11 | DJClassifiedsImage::getAdsImages() | JROOT/components/com_djclassifieds/models/items.php:455 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:383 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.76 ms Nach letzter Abfrage: 1.18 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 8.139 MB Zeilen zurückgegeben: 5
SELECT ic.item_id, ic.cat_id, c.name, c.alias
FROM ginz_djcf_items_categories ic, ginz_djcf_categories c
WHERE c.id=ic.cat_id
AND ic.item_id IN (448763,448778,448786,448795,448797,448801,448867,448939,448814,295331,427971,427972,448685,448691,448740,53928,71769,71771,72830,445879)
ORDER BY ic.item_id,ic.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ic | range | item_id,cat_id | item_id | 4 | NULL | 21 | Using index condition; filesort wurde genutzt |
| 1 | SIMPLE | c | eq_ref | PRIMARY | PRIMARY | 4 | admin_ginz.ic.cat_id | 1 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.16 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.14 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djclassifieds/models/items.php:463 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:383 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.64 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 8.147 MB Zeilen zurückgegeben: 5
SELECT *
FROM ginz_djcf_images
WHERE item_id IN (196148,196148,196148,196366,196370,136055,196148,136055,196370,736056,355,355,196366,196366,196366,736056,736056,736056,736056,196366)
AND type='profile'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_djcf_images | range|filter | item_id,type | item_id|type | 4|167 | NULL | 6 (0%) | Using index condition; Using where; Using rowid filter |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.17 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djclassifieds/models/items.php:470 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:383 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.41 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 8.158 MB Zeilen zurückgegeben: 5
SELECT *
FROM ginz_djcf_profiles
WHERE user_id IN (196148,196148,196148,196366,196370,136055,196148,136055,196370,736056,355,355,196366,196366,196366,736056,736056,736056,736056,196366)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_djcf_profiles | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 11 | Using where |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djclassifieds/models/items.php:474 |
| 10 | DjclassifiedsModelItems->getItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:383 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 5.03 ms Nach letzter Abfrage: 0.80 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 8.196 MB Zeilen zurückgegeben: 1
SELECT count(i.id)
FROM (SELECT i.id
FROM ginz_djcf_items i
LEFT JOIN ginz_djcf_categories c
ON i.cat_id = c.id
LEFT JOIN ginz_djcf_regions r
ON i.region_id = r.id
LEFT JOIN ginz_users u
ON i.user_id = u.id
LEFT JOIN ( SELECT item_id, count(id) as mcat_c
FROM ginz_djcf_items_categories
WHERE cat_id IN (1,1,2,17,53,14,11,74,26,4,64,10,8,20,75,19,9,76,48,6,5,7,46,72,23,3,70)
GROUP BY item_id ) mc
ON i.id=mc.item_id
WHERE i.blocked=0
AND c.published!=0
AND (i.cat_id IN (1,1,2,17,53,14,11,74,26,4,64,10,8,20,75,19,9,76,48,6,5,7,46,72,23,3,70) OR mc.mcat_c>0)
AND i.region_id IN (1,196148,384528,136055,196363,196366,736055,196370)
AND i.published=1
AND i.date_exp > '2023-12-05 13:05:47'
AND c.access_view IN (0,1,1) ) as i
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | ALL | PRIMARY,published | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 48 | Using where |
| 1 | PRIMARY | i | ref | cat_id,region_id,published,blocked,date_exp | cat_id | 4 | admin_ginz.c.id | 12 | Using where |
| 1 | PRIMARY | <derived3> | ref | key0 | key0 | 5 | admin_ginz.i.id | 10 | Using where |
| 3 | DERIVED | ginz_djcf_items_categories | ALL | item_id,cat_id | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 328 | Using where; Using temporary; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.18 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.14 ms |
| Optimizing | 0.08 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.16 ms |
| Statistics | 0.31 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.07 ms |
| Sorting result | 0.01 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.06 ms |
| Executing | 0.01 ms |
| Sending data | 0.16 ms |
| Executing | 0.01 ms |
| Sending data | 0.34 ms |
| Creating sort index | 0.21 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 2.81 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.02 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.03 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 11 | JDatabaseDriver->loadResult() | JROOT/components/com_djclassifieds/models/items.php:846 |
| 10 | DjclassifiedsModelItems->getCountItems() | JROOT/components/com_djclassifieds/views/items/view.html.php:384 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.96 ms Nach letzter Abfrage: 1.57 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 8.191 MB Zeilen zurückgegeben: 56
SELECT *
FROM ginz_djcf_categories
ORDER BY parent_id, ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ginz_djcf_categories | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 48 | filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.44 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:549 |
| 11 | DJClassifiedsCategory::getAllCategories() | JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:563 |
| 10 | DJClassifiedsCategory::getCategories() | JROOT/components/com_djclassifieds/views/items/view.html.php:410 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
| 6 | require_once JROOT/components/com_djclassifieds/djclassifieds.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.86 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 8.282 MB Zeilen zurückgegeben: 6
SELECT f.*, fg.name group_name
FROM ginz_djcf_fields f
LEFT JOIN ginz_djcf_fields_groups fg
ON f.group_id=fg.id
AND fg.published=1
WHERE f.published=1
AND (f.in_table>0 OR f.in_blog=1)
AND (fg.access IS NULL OR fg.access IN (1,1))
ORDER BY f.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | published | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 12 | Using where; filesort wurde genutzt |
| 1 | SIMPLE | fg | eq_ref | PRIMARY | PRIMARY | 4 | admin_ginz.f.group_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.07 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.08 ms |
| Preparing | 0.04 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.16 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djclassifieds/models/items.php:1318 |
| 10 | DjclassifiedsModelItems->getCustomFields() | JROOT/components/com_djclassifieds/views/items/view.html.php:421 |
| 9 | DJClassifiedsViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djclassifieds/djclassifieds.php:144 |
