 Übersicht |
 Suchen |
 Ebene |
| Kategorie: Sonstiges |
|
|
Dateien:
 Risikoberechnung 1.0 |
|
|
Exelvorlage um das Risiko einfach zu berechnen. |
Erstelldatum Dateigröße Downloads |
2017-01-19 10.01 KB 2.697 |
| Übersicht |
Suchen |
Ebene |
| Kategorie: Sonstiges |
|
|
| Risikoberechnung 1.0 Beliebt |
|
|
Exelvorlage um das Risiko einfach zu berechnen. |
Erstelldatum Dateigröße Downloads |
2017-01-19 10.01 KB 2.697 |
Das Trading Tool besticht mit seinen vielen sehr nützlichen und zum Trading fast unverzichtbaren Funktionen. Überzeugen Sie sich selber und testen Sie es auf Herz und Nieren.
Dieser Bereich ist noch in Vorbereitung.
Es gibt speziell auf das Trading Tool abgestimmte Handelsstrategien und Ansätze, die von verschiedenen Tradern bereits eingesetzt werden.
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1695538026,
"last": 1695538026,
"now": 1695538026
},
"token": "u7rUpOonJM0dqPgOsGhgwcwbAZwBT4NX"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"jd_allowed_create_categories": []
}
}
SELECT `data`
FROM `TGp2o_session`
WHERE `session_id` = '3d041d10d0be6b10e6c04ea3e86f18c6'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_session | const | PRIMARY | PRIMARY | 194 | 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.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.06 ms |
| Preparing | 0.00 ms |
| Executing | 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 |
|---|---|---|
| 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:660 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:758 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 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:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `session_id`
FROM `TGp2o_session`
WHERE `session_id` = '3d041d10d0be6b10e6c04ea3e86f18c6'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
| 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.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.00 ms |
| Executing | 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.01 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | 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:153 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 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:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
INSERT INTO `TGp2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('3d041d10d0be6b10e6c04ea3e86f18c6', 1, 1695538026, 0, '', 0)
| Status | Duration |
|---|---|
| Starting | 0.04 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 for update | 0.01 ms |
| Update | 0.07 ms |
| Waiting for query cache lock | 0.00 ms |
| Update | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.04 ms |
| Writing to binlog | 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.02 ms |
| Reset for next command | 0.00 ms |
| # | 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:153 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 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:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `TGp2o_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_extensions | ref | extension | extension | 82 | const | 48 | Using index condition; Using where |
| 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.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.16 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.01 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/libraries/src/Component/ComponentHelper.php:445 |
| 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Derselbe Aufruf in der Zeile darunter. |
| 9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
| 6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
| 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
| 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, rules
FROM `TGp2o_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_viewlevels | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 7 |
| 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.01 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 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.02 ms |
| Reset for next command | 0.00 ms |
| # | 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:321 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT b.id
FROM TGp2o_usergroups AS a
LEFT JOIN TGp2o_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| 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 | 2 | Using where; Using index |
| Status | Duration |
|---|---|
| Starting | 0.04 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.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.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 |
|---|---|---|
| 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:321 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM TGp2o_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_extensions | ALL | extension | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 319 | Using where; filesort wurde genutzt |
| Status | Duration |
|---|---|
| Starting | 0.04 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.02 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| Executing | 0.00 ms |
| Sending data | 0.00 ms |
| Creating sort index | 0.29 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.02 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:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:354 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Derselbe Aufruf in der Zeile darunter. |
| 8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:359 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW TABLES
| Status | Duration |
|---|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.00 ms |
| checking permissions | 0.46 ms |
| Executing | 0.00 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 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 |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:502 |
| 10 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jdownloads/jdownloads.php:78 |
| 9 | plgSystemjdownloads->onAfterInitialise() | Derselbe Aufruf in der Zeile darunter. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:626 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT file_id
from TGp2o_jdownloads_files
WHERE published = 1
AND use_timeframe = 1
AND publish_to != '0000-00-00 00:00:00'
AND publish_to <= '2023-09-24 08:47:06'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_jdownloads_files | ALL | idx_published | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 7 | 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.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 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.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/jdownloads/jdownloads.php:106 |
| 9 | plgSystemjdownloads->onAfterInitialise() | Derselbe Aufruf in der Zeile darunter. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:626 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT file_id
from TGp2o_jdownloads_files
WHERE published = 0
AND use_timeframe = 1
AND publish_from != '0000-00-00 00:00:00'
AND publish_from <= '2023-09-24 08:47:06'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_jdownloads_files | ref | idx_published | idx_published | 1 | const | 2 | Using where |
| Status | Duration |
|---|---|
| Starting | 0.04 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.02 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.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 |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/jdownloads/jdownloads.php:114 |
| 9 | plgSystemjdownloads->onAfterInitialise() | Derselbe Aufruf in der Zeile darunter. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:626 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM TGp2o_menu AS m
LEFT JOIN TGp2o_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | range | idx_client_id_parent_id_alias_language,published,parent_id | idx_client_id_parent_id_alias_language | 5 | NULL | 14 | Using index condition; Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | d01df479.m.component_id | 1 | Using where |
| Status | Duration |
|---|---|
| Starting | 0.06 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.06 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.11 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.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|---|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Derselbe Aufruf in der Zeile darunter. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
| 13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
| 11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:375 |
| 10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:64 |
| 8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:491 |
| 6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
| 5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1073 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `TGp2o_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| Status | Duration |
|---|---|
| Starting | 0.04 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.06 ms |
| Preparing | 0.01 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 |
|---|---|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 19 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 18 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Derselbe Aufruf in der Zeile darunter. |
| 17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 15 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 14 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 13 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/advancedmodules/advancedmodules.php:45 |
| 9 | PlgSystemAdvancedModules->onAfterRoute() | Derselbe Aufruf in der Zeile darunter. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `TGp2o_extensions`
SET `params` = '{\"mediaversion\":\"188450a6a8f6941945260e904cdc8a93\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| 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 for update | 0.03 ms |
| Updating | 0.03 ms |
| End of update loop | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.03 ms |
| Writing to binlog | 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 |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 14 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 13 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/advancedmodules/advancedmodules.php:45 |
| 9 | PlgSystemAdvancedModules->onAfterRoute() | Derselbe Aufruf in der Zeile darunter. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, home, template, s.params
FROM TGp2o_template_styles as s
LEFT JOIN TGp2o_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 | ref | idx_template,idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 1 | |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | d01df479.s.template,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|---|
| Starting | 0.04 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.05 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 |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
| 11 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/t3/includes/core/t3.php:320 |
| 10 | T3::detect() | JROOT/plugins/system/t3/t3.php:81 |
| 9 | plgSystemT3->onAfterRoute() | Derselbe Aufruf in der Zeile darunter. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW TABLES
| 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.00 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.00 ms |
| checking permissions | 0.43 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 |
| Removing tmp table | 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 |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:502 |
| 10 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jdownloads/jdownloads.php:353 |
| 9 | plgSystemjdownloads->onAfterRoute() | Derselbe Aufruf in der Zeile darunter. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM TGp2o_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_languages | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | 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.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.00 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.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 |
|---|---|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
| 4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT setting_name, setting_value
FROM TGp2o_jdownloads_config
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_jdownloads_config | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 269 |
| 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.01 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.19 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.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 |
|---|---|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 8 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:39 |
| 7 | JDHelper::buildjlistConfig() | JROOT/components/com_jdownloads/jdownloads.php:28 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT group_id, importance, id
FROM TGp2o_jdownloads_usergroups_limits
ORDER BY importance
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_jdownloads_usergroups_limits | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 11 | 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.01 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.00 ms |
| Sorting result | 0.00 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.06 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 |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 12 | JDatabaseDriver->loadAssocList() | JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:91 |
| 11 | JDHelper::getUserRules() | JROOT/components/com_jdownloads/views/category/view.html.php:40 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM TGp2o_jdownloads_usergroups_limits
WHERE group_id IN (1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_jdownloads_usergroups_limits | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 11 | Using where |
| 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.04 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.11 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.01 ms |
| Updating status | 0.01 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/components/com_jdownloads/helpers/jdownloadshelper.php:115 |
| 11 | JDHelper::getUserRules() | JROOT/components/com_jdownloads/views/category/view.html.php:40 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `TGp2o_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_j4age','com_jaextmanager','com_jce','com_jdownloads','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slideshowck','com_smartsub','com_tags','com_tcpdf','com_templates','com_uddeim','com_users','com_virtuemart','com_virtuemart_allinone','com_visforms','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_assets | ALL | idx_asset_name | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 169 | Using where |
| Status | Duration |
|---|---|
| Starting | 0.05 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.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.06 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.15 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 |
|---|---|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 18 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_jdownloads/models/category.php:184 |
| 13 | JdownloadsModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 |
| 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jdownloads/views/category/view.html.php:44 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SET SESSION SQL_BIG_SELECTS = 1
| Status | Duration |
|---|---|
| Starting | 0.03 ms |
| Opening tables | 0.00 ms |
| After opening tables | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 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 |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/components/com_jdownloads/helpers/categories.php:219 |
| 15 | JDCategories->_load() | JROOT/components/com_jdownloads/helpers/categories.php:181 |
| 14 | JDCategories->get() | JROOT/components/com_jdownloads/models/category.php:440 |
| 13 | JdownloadsModelCategory->getCategory() | JROOT/components/com_jdownloads/models/category.php:326 |
| 12 | JdownloadsModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jdownloads/views/category/view.html.php:46 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(files.`file_id`) AS numitems,u.name AS creator,u2.name AS modifier,menu.id AS menu_itemid
FROM TGp2o_jdownloads_categories as c
LEFT JOIN TGp2o_jdownloads_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN `TGp2o_jdownloads_files` AS files
ON files.`cat_id` = c.id
AND files.published = 1
LEFT JOIN TGp2o_users AS u
on u.id = files.created_id
LEFT JOIN TGp2o_users AS u2
on u2.id = files.modified_id
LEFT JOIN (SELECT id, link, access, published
from TGp2o_menu
GROUP BY link) AS menu
on menu.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=',c.id)
AND menu.published = 1
AND menu.access IN (1,1,5)
WHERE c.access IN (1,1,5)
AND c.published = 1
AND s.id=6
GROUP BY c.id, c.cat_dir, c.cat_dir_parent, c.parent_id, c.lft, c.rgt, c.level, c.title, c.alias, c.description, c.pic, c.access, c.metakey, c.metadesc, c.robots, c.created_user_id, c.created_time, c.modified_user_id, c.modified_time, c.language, c.notes, c.views, c.params, c.password, c.password_md5, c.ordering, c.published, c.checked_out, c.checked_out_time, c.asset_id
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | PRIMARY | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Using temporary; filesort wurde genutzt |
| 1 | PRIMARY | c | ref | idx_access,idx_left_right,published | published | 1 | const | 3 | Using where |
| 1 | PRIMARY | files | ref|filter | idx_cat_id,idx_published | idx_cat_id|idx_published | 4|1 | d01df479.c.id | 1 (71%) | Using where; Using rowid filter |
| 1 | PRIMARY | u | eq_ref | PRIMARY | PRIMARY | 4 | d01df479.files.created_id | 1 | Using where |
| 1 | PRIMARY | u2 | eq_ref | PRIMARY | PRIMARY | 4 | d01df479.files.modified_id | 1 | Using where |
| 1 | PRIMARY | <derived2> | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 80 | Using where; Using join buffer (flat, BNL join) |
| 2 | DERIVED | TGp2o_menu | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 80 | Using temporary; filesort wurde genutzt |
| Status | Duration |
|---|---|
| Starting | 0.12 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.10 ms |
| Optimizing | 0.02 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.00 ms |
| Statistics | 0.11 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.08 ms |
| Executing | 0.00 ms |
| Sending data | 0.41 ms |
| Creating sort index | 0.16 ms |
| Removing tmp table | 0.05 ms |
| Creating sort index | 0.27 ms |
| Creating sort index | 0.02 ms |
| Removing tmp table | 0.04 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 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.02 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|---|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jdownloads/helpers/categories.php:328 |
| 15 | JDCategories->_load() | JROOT/components/com_jdownloads/helpers/categories.php:181 |
| 14 | JDCategories->get() | JROOT/components/com_jdownloads/models/category.php:440 |
| 13 | JdownloadsModelCategory->getCategory() | JROOT/components/com_jdownloads/models/category.php:326 |
| 12 | JdownloadsModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jdownloads/views/category/view.html.php:46 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `TGp2o_assets`
WHERE `name` LIKE 'com_jdownloads.%' OR `name` = 'com_jdownloads' OR `parent_id` = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_assets | ALL | idx_asset_name,idx_parent_id | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 169 | Using where |
| 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.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.08 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 |
|---|---|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
| 18 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
| 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
| 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_jdownloads/models/category.php:449 |
| 13 | JdownloadsModelCategory->getCategory() | JROOT/components/com_jdownloads/models/category.php:326 |
| 12 | JdownloadsModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jdownloads/views/category/view.html.php:46 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.file_id, a.file_title, a.file_alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.date_added, a.file_date, a.publish_from, a.publish_to, a.use_timeframe, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_id, a.created_mail, a.modified_id, a.modified_date, a.submitted_by, a.set_aup_points, a.downloads, a.cat_id, a.changelog, a.password, a.password_md5, a.views, a.metakey, a.metadesc, a.robots, a.update_active, a.custom_field_1, a.custom_field_2, a.custom_field_3, a.custom_field_4, a.custom_field_5, a.custom_field_6, a.custom_field_7, a.custom_field_8, a.custom_field_9, a.custom_field_10, a.custom_field_11, a.custom_field_12, a.custom_field_13, a.custom_field_14, a.access, a.language, a.ordering, a.featured, a.published, a.checked_out, a.checked_out_time, a.modified_date as modified, a.modified_id,
CASE WHEN a.publish_from = 0 THEN a.date_added ELSE a.publish_from END as publish_from,a.publish_to, a.images, a.metakey, a.metadesc, a.access, a.downloads, LENGTH(a.description_long) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.published END AS state,aa.url_download AS filename_from_other_download,c.title AS category_title, c.access AS category_access, c.alias AS category_alias, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent,u.name AS creator,u2.name AS modifier,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias,menuf.id AS menuf_itemid,menuc.id AS menuc_cat_itemid,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM TGp2o_jdownloads_files AS a
LEFT JOIN TGp2o_jdownloads_files AS aa
on aa.file_id = a.other_file_id
LEFT JOIN TGp2o_jdownloads_categories AS c
ON c.id = a.cat_id
LEFT JOIN TGp2o_users AS ua
ON ua.id = a.created_id
LEFT JOIN TGp2o_users AS uam
ON uam.id = a.modified_id
LEFT JOIN TGp2o_users AS u
on u.id = a.created_id
LEFT JOIN TGp2o_users AS u2
on u2.id = a.modified_id
LEFT JOIN TGp2o_jdownloads_licenses AS l
on l.id = a.license
LEFT JOIN TGp2o_jdownloads_ratings AS r
on r.file_id = a.file_id
LEFT JOIN TGp2o_jdownloads_categories as parent
ON parent.id = c.parent_id
LEFT JOIN (SELECT id, link, access, published
from TGp2o_menu
GROUP BY link) AS menuf
on menuf.link LIKE CONCAT('index.php?option=com_jdownloads&view=download&id=',a.file_id)
AND menuf.published = 1
AND menuf.access IN (1,1,5)
LEFT JOIN (SELECT id, link, access, published
from TGp2o_menu
GROUP BY link) AS menuc
on menuc.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=',a.cat_id)
AND menuc.published = 1
AND menuc.access IN (1,1,5)
LEFT
OUTER JOIN (SELECT cat.id as id
FROM TGp2o_jdownloads_categories AS cat JOIN TGp2o_jdownloads_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND
CASE WHEN badcats.id is null THEN a.published ELSE 0 END = 1
AND a.cat_id = 6
AND (a.publish_from = '0000-00-00 00:00:00' OR a.publish_from <= '2023-09-24 06:47:06')
AND (a.publish_to = '0000-00-00 00:00:00' OR a.publish_to >= '2023-09-24 06:47:06')
ORDER BY a.date_added DESC
LIMIT 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | PRIMARY | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | Using temporary; filesort wurde genutzt |
| 1 | PRIMARY | a | ref | idx_cat_id,idx_access | idx_cat_id | 4 | const | 1 | Using where |
| 1 | PRIMARY | u | eq_ref | PRIMARY | PRIMARY | 4 | d01df479.a.created_id | 1 | |
| 1 | PRIMARY | u2 | eq_ref | PRIMARY | PRIMARY | 4 | d01df479.a.modified_id | 1 | |
| 1 | PRIMARY | l | eq_ref | PRIMARY | PRIMARY | 4 | d01df479.a.license | 1 | Using where |
| 1 | PRIMARY | r | eq_ref | PRIMARY | PRIMARY | 4 | d01df479.a.file_id | 1 | |
| 1 | PRIMARY | parent | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | Using where |
| 1 | PRIMARY | aa | eq_ref | PRIMARY | PRIMARY | 4 | d01df479.a.other_file_id | 1 | |
| 1 | PRIMARY | <derived2> | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 80 | Using where; Using join buffer (flat, BNL join) |
| 1 | PRIMARY | <derived3> | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 80 | Using where; Using join buffer (incremental, BNL join) |
| 1 | PRIMARY | <derived4> | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 15 | Using where; Using join buffer (incremental, BNL join) |
| 4 | DERIVED | parent | range | idx_left_right,published | published | 1 | NULL | 3 | Using index condition; Using temporary; filesort wurde genutzt |
| 4 | DERIVED | cat | index | idx_left_right | idx_left_right | 8 | NULL | 5 | Using where; Using index; Using join buffer (flat, BNL join) |
| 3 | DERIVED | TGp2o_menu | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 80 | Using temporary; filesort wurde genutzt |
| 2 | DERIVED | TGp2o_menu | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 80 | Using temporary; filesort wurde genutzt |
| Status | Duration |
|---|---|
| Starting | 0.20 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.12 ms |
| Optimizing | 0.04 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.00 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.00 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.00 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Statistics | 0.08 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.01 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.05 ms |
| Sorting result | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 11.24 ms |
| Executing | 0.00 ms |
| Sending data | 0.39 ms |
| Creating sort index | 0.18 ms |
| Removing tmp table | 0.05 ms |
| Creating sort index | 0.10 ms |
| Executing | 0.00 ms |
| Sending data | 56.13 ms |
| Creating sort index | 0.28 ms |
| Removing tmp table | 0.08 ms |
| Creating sort index | 0.16 ms |
| Executing | 0.00 ms |
| Sending data | 18.71 ms |
| Creating sort index | 0.02 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.39 ms |
| Creating sort index | 0.04 ms |
| Removing tmp table | 0.07 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|---|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 15 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 14 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_jdownloads/models/downloads.php:560 |
| 13 | jdownloadsModelDownloads->getItems() | JROOT/components/com_jdownloads/models/category.php:344 |
| 12 | JdownloadsModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jdownloads/views/category/view.html.php:46 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `m`.`tag_id`,`t`.*
FROM `TGp2o_contentitem_tag_map` AS m
INNER JOIN `TGp2o_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_jdownloads.download'
AND `m`.`content_item_id` = 7
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | Using where |
| 1 | SIMPLE | t | ALL | PRIMARY,tag_idx,idx_access | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 3 | Using where; Using join buffer (flat, BNL join) |
| 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.00 ms |
| table lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.09 ms |
| Preparing | 0.05 ms |
| Executing | 0.01 ms |
| Sending data | 0.06 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.01 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_jdownloads/models/downloads.php:627 |
| 13 | jdownloadsModelDownloads->getItems() | JROOT/components/com_jdownloads/models/category.php:344 |
| 12 | JdownloadsModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jdownloads/views/category/view.html.php:46 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT COUNT(*)
FROM TGp2o_jdownloads_files AS a
LEFT JOIN TGp2o_jdownloads_files AS aa
on aa.file_id = a.other_file_id
LEFT JOIN TGp2o_jdownloads_categories AS c
ON c.id = a.cat_id
LEFT JOIN TGp2o_users AS ua
ON ua.id = a.created_id
LEFT JOIN TGp2o_users AS uam
ON uam.id = a.modified_id
LEFT JOIN TGp2o_users AS u
on u.id = a.created_id
LEFT JOIN TGp2o_users AS u2
on u2.id = a.modified_id
LEFT JOIN TGp2o_jdownloads_licenses AS l
on l.id = a.license
LEFT JOIN TGp2o_jdownloads_ratings AS r
on r.file_id = a.file_id
LEFT JOIN TGp2o_jdownloads_categories as parent
ON parent.id = c.parent_id
LEFT JOIN (SELECT id, link, access, published
from TGp2o_menu
GROUP BY link) AS menuf
on menuf.link LIKE CONCAT('index.php?option=com_jdownloads&view=download&id=',a.file_id)
AND menuf.published = 1
AND menuf.access IN (1,1,5)
LEFT JOIN (SELECT id, link, access, published
from TGp2o_menu
GROUP BY link) AS menuc
on menuc.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=',a.cat_id)
AND menuc.published = 1
AND menuc.access IN (1,1,5)
LEFT
OUTER JOIN (SELECT cat.id as id
FROM TGp2o_jdownloads_categories AS cat JOIN TGp2o_jdownloads_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND
CASE WHEN badcats.id is null THEN a.published ELSE 0 END = 1
AND a.cat_id = 6
AND (a.publish_from = '0000-00-00 00:00:00' OR a.publish_from <= '2023-09-24 06:47:06')
AND (a.publish_to = '0000-00-00 00:00:00' OR a.publish_to >= '2023-09-24 06:47:06')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | PRIMARY | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | a | ref | idx_cat_id,idx_access | idx_cat_id | 4 | const | 1 | Using where |
| 1 | PRIMARY | <derived2> | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 80 | Using where; Using join buffer (flat, BNL join) |
| 1 | PRIMARY | <derived3> | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 80 | Using where; Using join buffer (incremental, BNL join) |
| 1 | PRIMARY | <derived4> | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 15 | Using where; Using join buffer (incremental, BNL join) |
| 4 | DERIVED | parent | range | idx_left_right,published | published | 1 | NULL | 3 | Using index condition; Using temporary; filesort wurde genutzt |
| 4 | DERIVED | cat | index | idx_left_right | idx_left_right | 8 | NULL | 5 | Using where; Using index; Using join buffer (flat, BNL join) |
| 3 | DERIVED | TGp2o_menu | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 80 | Using temporary; filesort wurde genutzt |
| 2 | DERIVED | TGp2o_menu | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 80 | Using temporary; filesort wurde genutzt |
| Status | Duration |
|---|---|
| Starting | 0.17 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.11 ms |
| Optimizing | 0.05 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Statistics | 0.10 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.01 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.05 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| Executing | 0.00 ms |
| Sending data | 0.64 ms |
| Creating sort index | 0.28 ms |
| Removing tmp table | 0.08 ms |
| Creating sort index | 0.09 ms |
| Executing | 0.00 ms |
| Sending data | 0.61 ms |
| Creating sort index | 0.28 ms |
| Removing tmp table | 0.07 ms |
| Creating sort index | 0.09 ms |
| Executing | 0.00 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|---|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 16 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340 |
| 15 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:282 |
| 14 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:232 |
| 13 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/components/com_jdownloads/models/category.php:353 |
| 12 | JdownloadsModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jdownloads/views/category/view.html.php:46 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT c.id AS id, c.access, a.name AS asset_name
FROM TGp2o_jdownloads_categories AS c
INNER JOIN TGp2o_assets AS a
ON c.asset_id = a.id
WHERE c.published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | c | ref | published | published | 1 | const | 3 | |
| 1 | SIMPLE | a | eq_ref | PRIMARY | PRIMARY | 4 | d01df479.c.asset_id | 1 |
| Status | Duration |
|---|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 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.04 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.05 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.01 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/components/com_jdownloads/helpers/jdownloadshelper.php:3637 |
| 11 | JDHelper::getAuthorisedJDCategories() | JROOT/components/com_jdownloads/views/category/view.html.php:63 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `m`.`tag_id`,`t`.*
FROM `TGp2o_contentitem_tag_map` AS m
INNER JOIN `TGp2o_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_jdownloads.category'
AND `m`.`content_item_id` = 6
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | Using where |
| 1 | SIMPLE | t | ALL | PRIMARY,tag_idx,idx_access | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 3 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|---|
| Starting | 0.04 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.02 ms |
| Statistics | 0.04 ms |
| Preparing | 0.03 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 |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 11 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_jdownloads/views/category/view.html.php:156 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, link
from TGp2o_menu
WHERE link LIKE 'index.php?option=com_jdownloads&view=category%'
AND published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_menu | ALL | published | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 80 | Using where |
| Status | Duration |
|---|---|
| Starting | 0.03 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.03 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.11 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.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 14 | JDatabaseDriver->loadAssocList() | JROOT/plugins/content/jdownloads/jdownloads.php:46 |
| 13 | require_once JROOT/plugins/content/jdownloads/jdownloads.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_jdownloads/views/category/view.html.php:184 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, link, published, access, language
FROM TGp2o_menu
WHERE (link LIKE 'index.php?option=com_jdownloads%')
AND published = 1
AND client_id = 0
AND language = 'de-de'
AND access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_menu | ref | idx_client_id_parent_id_alias_language,idx_language,published,access | idx_language | 28 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|---|
| Starting | 0.04 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.02 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.09 ms |
| Preparing | 0.03 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.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 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/components/com_jdownloads/helpers/jdownloadshelper.php:242 |
| 14 | JDHelper::getMenuItemids() | JROOT/plugins/content/jdownloads/jdownloads.php:55 |
| 13 | require_once JROOT/plugins/content/jdownloads/jdownloads.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_jdownloads/views/category/view.html.php:184 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, link, published, access, language
FROM TGp2o_menu
WHERE (link LIKE 'index.php?option=com_jdownloads%')
AND published = 1
AND client_id = 0
AND access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_menu | ref | idx_client_id_parent_id_alias_language,published,access | idx_client_id_parent_id_alias_language | 1 | const | 15 | Using where |
| 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.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 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.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.01 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/components/com_jdownloads/helpers/jdownloadshelper.php:247 |
| 14 | JDHelper::getMenuItemids() | JROOT/plugins/content/jdownloads/jdownloads.php:55 |
| 13 | require_once JROOT/plugins/content/jdownloads/jdownloads.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_jdownloads/views/category/view.html.php:184 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id
FROM TGp2o_menu
WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' )
AND published = 1
AND client_id = 0
AND language = 'de-de'
AND access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_menu | ref | idx_client_id_parent_id_alias_language,idx_language,published,access | idx_language | 28 | const | 1 | Using index condition; Using where |
| 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.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.03 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 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.01 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:294 |
| 14 | JDHelper::getMenuItemids() | JROOT/plugins/content/jdownloads/jdownloads.php:55 |
| 13 | require_once JROOT/plugins/content/jdownloads/jdownloads.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_jdownloads/views/category/view.html.php:184 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id
FROM TGp2o_menu
WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' )
AND published = 1
AND client_id = 0
AND access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_menu | ref | idx_client_id_parent_id_alias_language,published,access | idx_client_id_parent_id_alias_language | 1 | const | 15 | Using where |
| 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.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.05 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.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.01 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:298 |
| 14 | JDHelper::getMenuItemids() | JROOT/plugins/content/jdownloads/jdownloads.php:55 |
| 13 | require_once JROOT/plugins/content/jdownloads/jdownloads.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_jdownloads/views/category/view.html.php:184 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id
FROM TGp2o_menu
WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' )
AND published = 1
AND client_id = 0
AND language = 'de-de'
AND access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_menu | ref | idx_client_id_parent_id_alias_language,idx_language,published,access | idx_language | 28 | const | 1 | Using index condition; Using where |
| 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.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.03 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 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.01 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:352 |
| 14 | JDHelper::getMenuItemids() | JROOT/plugins/content/jdownloads/jdownloads.php:55 |
| 13 | require_once JROOT/plugins/content/jdownloads/jdownloads.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_jdownloads/views/category/view.html.php:184 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id
FROM TGp2o_menu
WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' )
AND published = 1
AND client_id = 0
AND access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_menu | ref | idx_client_id_parent_id_alias_language,published,access | idx_client_id_parent_id_alias_language | 1 | const | 15 | Using where |
| 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.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.05 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 |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:356 |
| 14 | JDHelper::getMenuItemids() | JROOT/plugins/content/jdownloads/jdownloads.php:55 |
| 13 | require_once JROOT/plugins/content/jdownloads/jdownloads.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_jdownloads/views/category/view.html.php:184 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id
FROM TGp2o_menu
WHERE link = 'index.php?option=com_jdownloads&view=search'
AND published = 1
AND client_id = 0
AND language = 'de-de'
AND access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_menu | ref | idx_client_id_parent_id_alias_language,idx_language,published,access | idx_language | 28 | const | 1 | Using index condition; Using where |
| 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.05 ms |
| Preparing | 0.02 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.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 |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:370 |
| 14 | JDHelper::getMenuItemids() | JROOT/plugins/content/jdownloads/jdownloads.php:55 |
| 13 | require_once JROOT/plugins/content/jdownloads/jdownloads.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_jdownloads/views/category/view.html.php:184 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id
FROM TGp2o_menu
WHERE link = 'index.php?option=com_jdownloads&view=search'
AND published = 1
AND client_id = 0
AND access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_menu | ref | idx_client_id_parent_id_alias_language,published,access | idx_client_id_parent_id_alias_language | 1 | const | 15 | 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.01 ms |
| Statistics | 0.03 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.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 |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:374 |
| 14 | JDHelper::getMenuItemids() | JROOT/plugins/content/jdownloads/jdownloads.php:55 |
| 13 | require_once JROOT/plugins/content/jdownloads/jdownloads.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_jdownloads/views/category/view.html.php:184 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id
FROM TGp2o_menu
WHERE link = 'index.php?option=com_jdownloads&view=form&layout=edit'
AND published = 1
AND client_id = 0
AND language = 'de-de'
AND access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_menu | ref | idx_client_id_parent_id_alias_language,idx_language,published,access | idx_language | 28 | 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.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 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.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 |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:380 |
| 14 | JDHelper::getMenuItemids() | JROOT/plugins/content/jdownloads/jdownloads.php:55 |
| 13 | require_once JROOT/plugins/content/jdownloads/jdownloads.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_jdownloads/views/category/view.html.php:184 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id
FROM TGp2o_menu
WHERE link = 'index.php?option=com_jdownloads&view=form&layout=edit'
AND published = 1
AND client_id = 0
AND access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_menu | ref | idx_client_id_parent_id_alias_language,published,access | idx_client_id_parent_id_alias_language | 1 | const | 15 | 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.01 ms |
| Statistics | 0.04 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.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 |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:384 |
| 14 | JDHelper::getMenuItemids() | JROOT/plugins/content/jdownloads/jdownloads.php:55 |
| 13 | require_once JROOT/plugins/content/jdownloads/jdownloads.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_jdownloads/views/category/view.html.php:184 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, link
from TGp2o_menu
WHERE link LIKE 'index.php?option=com_jdownloads&view=category&catid%'
AND published = 1
AND access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_menu | ALL | published,access | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 80 | 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.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 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 |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 15 | JDatabaseDriver->loadAssocList() | JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:416 |
| 14 | JDHelper::getAllJDCategoryMenuIDs() | JROOT/plugins/content/jdownloads/jdownloads.php:59 |
| 13 | require_once JROOT/plugins/content/jdownloads/jdownloads.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_jdownloads/views/category/view.html.php:184 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id
from TGp2o_menu
WHERE link = 'index.php?option=com_jdownloads&view=categories'
and published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_menu | ALL | published | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 80 | 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.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.06 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 |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/plugins/content/jdownloads/jdownloads.php:1897 |
| 14 | jd_CalcItemid() | JROOT/plugins/content/jdownloads/jdownloads.php:69 |
| 13 | require_once JROOT/plugins/content/jdownloads/jdownloads.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_jdownloads/views/category/view.html.php:184 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT setting_name, setting_value
FROM TGp2o_jdownloads_config
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_jdownloads_config | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 269 |
| Status | Duration |
|---|---|
| Starting | 0.01 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.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.21 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.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/jdownloads/jdownloads.php:203 |
| 14 | buildjlistConfigM() | JROOT/plugins/content/jdownloads/jdownloads.php:71 |
| 13 | require_once JROOT/plugins/content/jdownloads/jdownloads.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_jdownloads/views/category/view.html.php:184 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM TGp2o_fields AS a
LEFT JOIN `TGp2o_languages` AS l
ON l.lang_code = a.language
LEFT JOIN TGp2o_users AS uc
ON uc.id=a.checked_out
LEFT JOIN TGp2o_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN TGp2o_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN TGp2o_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_jdownloads.category'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | d01df479.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | d01df479.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | d01df479.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | d01df479.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | d01df479.a.group_id | 1 | Using where |
| Status | Duration |
|---|---|
| Starting | 0.08 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.04 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.10 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.04 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.23 ms |
| Creating sort index | 0.02 ms |
| Removing tmp table | 0.05 ms |
| Creating sort index | 0.01 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.01 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|---|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 17 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 14 | PlgSystemFields->onContentPrepare() | Derselbe Aufruf in der Zeile darunter. |
| 13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_jdownloads/views/category/view.html.php:185 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT group_id, importance, id
FROM TGp2o_jdownloads_usergroups_limits
ORDER BY importance
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_jdownloads_usergroups_limits | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 11 | 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.01 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.00 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.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 |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 15 | JDatabaseDriver->loadAssocList() | JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:91 |
| 14 | JDHelper::getUserRules() | JROOT/components/com_jdownloads/views/category/tmpl/default.php:32 |
| 13 | include JROOT/components/com_jdownloads/views/category/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_jdownloads/views/category/view.html.php:241 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM TGp2o_jdownloads_usergroups_limits
WHERE group_id IN (1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_jdownloads_usergroups_limits | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 11 | Using where |
| 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.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.11 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.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:115 |
| 14 | JDHelper::getUserRules() | JROOT/components/com_jdownloads/views/category/tmpl/default.php:32 |
| 13 | include JROOT/components/com_jdownloads/views/category/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_jdownloads/views/category/view.html.php:241 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM TGp2o_jdownloads_templates
WHERE template_typ = '1'
AND template_active = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_jdownloads_templates | ref | idx_template_typ | idx_template_typ | 1 | const | 7 | Using where |
| 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.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.06 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 |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 15 | JDatabaseDriver->loadObject() | JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:519 |
| 14 | JDHelper::getLayout() | JROOT/components/com_jdownloads/views/category/tmpl/default.php:66 |
| 13 | include JROOT/components/com_jdownloads/views/category/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_jdownloads/views/category/view.html.php:241 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM TGp2o_jdownloads_templates
WHERE template_typ = '4'
AND template_active = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_jdownloads_templates | ref | idx_template_typ | idx_template_typ | 1 | const | 2 | Using where |
| 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.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 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 |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 15 | JDatabaseDriver->loadObject() | JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:511 |
| 14 | JDHelper::getLayout() | JROOT/components/com_jdownloads/views/category/tmpl/default.php:79 |
| 13 | include JROOT/components/com_jdownloads/views/category/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_jdownloads/views/category/view.html.php:241 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM TGp2o_jdownloads_templates
WHERE template_typ = '2'
AND template_active = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_jdownloads_templates | ref | idx_template_typ | idx_template_typ | 1 | const | 11 | Using where |
| 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.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.06 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 |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 15 | JDatabaseDriver->loadObject() | JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:511 |
| 14 | JDHelper::getLayout() | JROOT/components/com_jdownloads/views/category/tmpl/default.php:93 |
| 13 | include JROOT/components/com_jdownloads/views/category/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_jdownloads/views/category/view.html.php:241 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, link, published, access, language
FROM TGp2o_menu
WHERE (link LIKE 'index.php?option=com_jdownloads%')
AND published = 1
AND client_id = 0
AND language = 'de-de'
AND access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TGp2o_menu | ref | idx_client_id_parent_id_alias_language,idx_language,published,access | idx_language | 28 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|---|
| Starting | 0.04 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.04 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.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 |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:242 |
| 14 | JDHelper::getMenuItemids() | JROOT/components/com_jdownloads/views/category/tmpl/default.php:139 |
| 13 | include JROOT/components/com_jdownloads/views/category/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
| 12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_jdownloads/views/category/view.html.php:241 |
| 10 | JdownloadsViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_jdownloads/controller.php:92 |
| 8 | jdownloadsController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jdownloads/jdownloads.php:34 |
| 6 | require_once JROOT/components/com_jdownloads/jdownloads.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |