Gutes Brustschwimmen braucht hohe Aufmerksamkeit für jedes Detail. Brustschwimmen mit Paddles ohne Riemen ist ein Weg die Hände zu isolieren und zu überprüfen, wie gut sie mit dem Wasser arbeiten. Das Ziel ist, dass sie in permanentem Kontakt mit dem Wasser sind, auch wenn du meinst, es wäre mal Zeit zum Entspannen. .
Wie gut ist dein Brustschwimmen ? Ein Weg das herauszufinden ist die Anzahl der Riemen zu zählen, die du an deinen Paddles brauchst. Je kompletter der Schwimmer, desto weniger Riemen braucht er. Es hängt alles davon ab wie gut du mit dem Wasser verbunden bist.
Ein guter Brustschwimmer weiß, wie er an jedem Punkt des Armzyklus konstanten Vortrieb erzeugt. Wenn du sehen willst, wie weit du schon bist, dann verwende gar keine Bändchen !
Starte in ausgestreckter Position und presse die Handflächen für den Auswärtszug direkt gegen die Paddles. Während der ersten Zugphase, sollte es kein Problem geben, die Paddles zu halten
Beim Einwärtszug wird's ein bisschen tricky. Wenn deine Hände sich drehen, musst du ein paar Dinge machen, die sich wahrscheinlich anders anfühlen, als bei deinem normalen Armzug.
- Du mußt die Händeleicht einwärts drehen, um Druck auf die Paddles aufrecht zu erhalten.
- Du mußt die Hände früher und mit mehr Beschleunigung drehen als normal
- Du wirst deine Ellbogen und Unterarme mehr benutzen müssen als normal
Wenn du zu weit nach hinten ziehst oder mit den Händen Pause machst, oder zu langsam ziehst oder die Hände auswärts drehst statt einwärts, werden die Paddles heruntergleiten, bevor du die Erholungsphase beginnst. Der Schwimmer auf dem Bild hat ein gutes Wassergefühl und verwendet Ellbogen und Unterarme um die Paddles im richtigen Winkel zu halten. Es ist, als ob seine Hände an den Paddles kleben.
Drücke weiter nach innen und vorwärts mit den Händen. Wenn deine Hände unterhalb des Kinns zögern, werden sie herunter fallen. Halte die Hände auf dem Paddle und schieße sie vorwärts. Beschleunige die Hände während des Armzugs in die Erholungsphase hinein.
<
Wenn du die Arme streckst, justiere den Winkel der Hände, so dass du leicht nach unten auf das Wasser drückst und nicht gegen es.
Bleibe mit den Paddles verbunden indem du nach vorne schwimmst und gleich mit der Zugphase beginnst.
Wenn du nach vorne drückst halte die Hände nahe zusammen und bleibe aggressiv. Dieser Schwimmer überlappt seine Hände ein wenig, um sie so nah zusammen zu halten wie möglich. Das erlaubt es ihm ,die Geschwindigkeit bei zu behalten.
Bevor du jetzt alle Bändchen herausziehst denke daran, dass Paddles ohne Bändchen nur fürs Brustschwimmen sind. Wenn du ohne Bändchen Kraul, Rücken oder Delphin schwimmst, fallen die Paddles ab wenn du in der Erholungsphase bist.
Diese besondere Übung zielt auf zwei häufige Fehler bei unerfahrenen, aggressiven Brustschwimmern: Armzug zu weit nach hinten und Pause während der Atmung.
Wenn du zu weit nach hinten ziehst, zeigen die Handflächen nach oben und die Paddles fallen herunter. Wenn du während der Atmung Pause machst, stoppen die Hände unter dem Kinn und die Paddles fallen auch herunter.
Um den Armzug zu isolieren und um sicherzustellen, dass die Handbewegung richtig sind, ist es am besten, diese Übung mit PullBuoys zu machen.
Neuere Artikel
Weitere Artikel
Beliebte Artikel
- Auftrieb und Vortrieb beim Schwimmen - 14/02/2007 - 34047 Artikel-Aufrufe
- Rythmus beim Kraulschwimmen - 14/02/2007 - 22772 Artikel-Aufrufe
- Ernährungstipps für Schwimmer - 13/02/2007 - 19255 Artikel-Aufrufe
- Frequenz - Zuglänge - 14/02/2007 - 18757 Artikel-Aufrufe
- Brustschwimmen - Unterwasserzug - 13/02/2007 - 17994 Artikel-Aufrufe
- Brustschwimmen - gestreckte Fußzehen - 13/02/2006 - 16469 Artikel-Aufrufe
Nächste Wettkämpfe und Veranstaltungen
-
So, 15. Dezember 2024 - Mi, 23. April 2025
DMS Lanedsliga -
Mo, 24. März 2025 - Mi, 26. März 2025
Deutsche Masters Lange St... -
Fr, 30. Mai 2025 - So, 1. Juni 2025
Deutsche Masters kurze St... -
Sa, 26. Juli 2025 - So, 27. Juli 2025
Masters WM 2025 in Singap... -
Do, 7. August 2025 - Do, 14. August 2025
Masters WM 2025 in Singap...
GSV History today....
- 3th anniversary of event Jahresrückblick und Statistik 2021
- 6th anniversary of event Weihnachtswünsche 2018
- 13th anniversary of event GSV Förderverein
- 15th anniversary of event SGMH Winterwanderung
Nächste Events
Mo | Di | Mi | Do | Fr | Sa | So |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 | 31 |
Joomla!-Debug-Konsole
{ "__default": { "session": { "counter": 1, "timer": { "start": 1734890865, "last": 1734890865, "now": 1734890865 }, "token": "vTZ5GjkrTIoUr3EqqWGllLeqjscM6Nwx" }, "registry": { "modjemcal": { "month": { "331": 1 }, "year": { "331": 2024 } } }, "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 } } }
Zeit
Speicher
68 ausgeführte Abfragen 36.74 ms
11 Duplikate gefunden!
- Abfragezeit: 0.20 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.194 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `jos331_session`
WHERE `session_id` = X'6233303737373930353637663839393832393161356139343932396635313564'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 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() Der selbe Aufruf in der Zeile darunter. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 0.11 ms Nach letzter Abfrage: 1.17 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.289 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `jos331_session`
WHERE `session_id` = X'6233303737373930353637663839393832393161356139343932396635313564'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 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:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.294 MB
INSERT INTO `jos331_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6233303737373930353637663839393832393161356139343932396635313564', 1, 1734890865, 0, '', 0)„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `jos331_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6233303737373930353637663839393832393161356139343932396635313564', 1, 1734890865, 0, '', 0)Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms update 0.09 ms Waiting for query cache lock 0.00 ms update 0.01 ms end 0.00 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 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:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 0.19 ms Nach letzter Abfrage: 5.23 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.914 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `jos331_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_viewlevels NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 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 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 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:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.926 MB Zeilen zurückgegeben: 2
SELECT b.id
FROM jos331_usergroups AS a
LEFT JOIN jos331_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 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 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.01 ms cleaning up 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:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.55 ms Nach letzter Abfrage: 9.86 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 6.387 MB Zeilen zurückgegeben: 2
SHOW FULL COLUMNS
FROM `jos331_gsd_config`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `jos331_gsd_config`Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.17 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.01 ms checking permissions 0.04 ms checking permissions 0.02 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.03 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 11 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_gsd/tables/config.php:26 10 GSDTableConfig->__construct() JROOT/libraries/src/Table/Table.php:328 9 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_gsd/GSD/Helper.php:401 8 GSD\Helper::getParams() JROOT/plugins/system/gsd/gsd.php:61 7 plgSystemGSD->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.17 ms Nach letzter Abfrage: 0.43 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 6.415 MB Zeilen zurückgegeben: 1
SELECT *
FROM jos331_gsd_config
WHERE `name` = 'config'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_gsd_config NULL system NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 9 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_gsd/GSD/Helper.php:402 8 GSD\Helper::getParams() JROOT/plugins/system/gsd/gsd.php:61 7 plgSystemGSD->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.51 ms Nach letzter Abfrage: 52.45 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 11.387 MB
UPDATE `jos331_extensions`
SET `params` = '{\"mediaversion\":\"57eae9eb2e22f36ce39aca1eecf18754\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE jos331_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.12 ms updating 0.07 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.05 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/seole/seole.php:159 8 plgSystemSEOle->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.34 ms Nach letzter Abfrage: 3.22 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.371 MB Zeilen zurückgegeben: 0
SELECT *
FROM `jos331_redirect_links`
WHERE (`old_url` = 'https://gsv-schwimmen.de/ratgeber/technik/brustschwimmen-mit-losen-paddles?modjemcal_id=331&modjemcal_month=1&modjemcal_year=2024' OR `old_url` = '/ratgeber/technik/brustschwimmen-mit-losen-paddles?modjemcal_id=331&modjemcal_month=1&modjemcal_year=2024' OR `old_url` = 'https://gsv-schwimmen.de/ratgeber/technik/brustschwimmen-mit-losen-paddles' OR `old_url` = '/ratgeber/technik/brustschwimmen-mit-losen-paddles')
AND published=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_redirect_links NULL ALL idx_old_url ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 10 JDatabaseDriver->loadAssocList() JROOT/plugins/system/seole/class/seo.class.php:543 9 redim_seo_class::check_redirects() JROOT/plugins/system/seole/seole.php:171 8 plgSystemSEOle->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.19 ms Nach letzter Abfrage: 1.07 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.408 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '516'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-12-22 18:07:45'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref idx_catid idx_catid 4 const 1 30.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/autoarchive/autoarchive.php:113 10 plgSystemAutoArchive->artRead() JROOT/plugins/system/autoarchive/autoarchive.php:33 9 plgSystemAutoArchive->kat2kat() JROOT/plugins/system/autoarchive/autoarchive.php:22 8 plgSystemAutoArchive->OnAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.413 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '521'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-12-22 18:07:45'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref idx_catid idx_catid 4 const 1 30.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/autoarchive/autoarchive.php:113 10 plgSystemAutoArchive->artRead() JROOT/plugins/system/autoarchive/autoarchive.php:33 9 plgSystemAutoArchive->kat2kat() JROOT/plugins/system/autoarchive/autoarchive.php:22 8 plgSystemAutoArchive->OnAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.419 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '518'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-12-22 18:07:45'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref idx_catid idx_catid 4 const 1 30.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/autoarchive/autoarchive.php:113 10 plgSystemAutoArchive->artRead() JROOT/plugins/system/autoarchive/autoarchive.php:33 9 plgSystemAutoArchive->kat2kat() JROOT/plugins/system/autoarchive/autoarchive.php:22 8 plgSystemAutoArchive->OnAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.424 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '523'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-12-22 18:07:45'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref idx_catid idx_catid 4 const 1 30.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/autoarchive/autoarchive.php:113 10 plgSystemAutoArchive->artRead() JROOT/plugins/system/autoarchive/autoarchive.php:33 9 plgSystemAutoArchive->kat2kat() JROOT/plugins/system/autoarchive/autoarchive.php:22 8 plgSystemAutoArchive->OnAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.429 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '0'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-12-22 18:07:45'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref idx_catid idx_catid 4 const 2 30.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/autoarchive/autoarchive.php:113 10 plgSystemAutoArchive->artRead() JROOT/plugins/system/autoarchive/autoarchive.php:82 9 plgSystemAutoArchive->kat2other() JROOT/plugins/system/autoarchive/autoarchive.php:23 8 plgSystemAutoArchive->OnAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.435 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '0'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-12-22 18:07:45'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref idx_catid idx_catid 4 const 2 30.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/autoarchive/autoarchive.php:113 10 plgSystemAutoArchive->artRead() JROOT/plugins/system/autoarchive/autoarchive.php:82 9 plgSystemAutoArchive->kat2other() JROOT/plugins/system/autoarchive/autoarchive.php:24 8 plgSystemAutoArchive->OnAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.440 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '0'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-12-22 18:07:45'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref idx_catid idx_catid 4 const 2 30.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/autoarchive/autoarchive.php:113 10 plgSystemAutoArchive->artRead() JROOT/plugins/system/autoarchive/autoarchive.php:82 9 plgSystemAutoArchive->kat2other() JROOT/plugins/system/autoarchive/autoarchive.php:25 8 plgSystemAutoArchive->OnAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.18 ms Nach letzter Abfrage: 3.40 ms Abfragespeichernutzung: 0.062 MB Speichernutzung vor Abfrage: 12.743 MB Zeilen zurückgegeben: 1
select version, dir_online, value
from `jos331_jvld_settings`
where id = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_jvld_settings NULL const PRIMARY PRIMARY 2 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jvldframework/library/class.cfg.php:33 12 JvldCfg->loadData() JROOT/plugins/system/jvldframework/library/class.cfg.php:24 11 JvldCfg->__construct() JROOT/plugins/system/jvldframework/library/class.cfg.php:48 10 JvldCfg::getInstance() JROOT/plugins/system/jvldframework/jvldframework.php:101 9 plgSystemJvldframework->initializeDirectory() JROOT/plugins/system/jvldframework/jvldframework.php:47 8 plgSystemJvldframework->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.29 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.806 MB Zeilen zurückgegeben: 1
select id
from jos331_menu
where link = 'index.php?option=com_jvld&view=jvld'
and published = 1
and client_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 68 1.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.15 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/plugins/system/jvldframework/library/class.db.php:53 10 JvldDb::getRow() JROOT/plugins/system/jvldframework/jvldframework.php:106 9 plgSystemJvldframework->initializeDirectory() JROOT/plugins/system/jvldframework/jvldframework.php:47 8 plgSystemJvldframework->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.813 MB Zeilen zurückgegeben: 1
select sparams
from `jos331_jvld_styles`
where stylename = 'default'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_jvld_styles NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 3 33.33 Using where Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/plugins/system/jvldframework/library/class.cfg.php:90 10 JvldCfg->overrideWithStyleParams() JROOT/plugins/system/jvldframework/jvldframework.php:123 9 plgSystemJvldframework->initializeDirectory() JROOT/plugins/system/jvldframework/jvldframework.php:47 8 plgSystemJvldframework->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.32 ms Nach letzter Abfrage: 11.20 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 14.214 MB Zeilen zurückgegeben: 1
select email
from jos331_users
where id=706
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_users NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/plugins/system/bfstop/helpers/db.php:307 12 BFStopDBHelper->getUserEmailWhere() JROOT/plugins/system/bfstop/helpers/db.php:320 11 BFStopDBHelper->getUserEmailByID() JROOT/plugins/system/bfstop/helpers/notify.php:23 10 BFStopNotifier->__construct() JROOT/plugins/system/bfstop/bfstop.php:197 9 plgSystembfstop->init() JROOT/plugins/system/bfstop/bfstop.php:369 8 plgSystembfstop->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.15 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 14.221 MB Zeilen zurückgegeben: 0
SELECT id, ipaddress
from jos331_bfstop_allowlist
WHERE (ipaddress='18.222.118.236'
AND LOCATE('/', ipaddress) = 0)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bfstop/helpers/db.php:188 10 BFStopDBHelper->checkForEntries() JROOT/plugins/system/bfstop/helpers/db.php:224 9 BFStopDBHelper->isIPOnAllowList() JROOT/plugins/system/bfstop/bfstop.php:388 8 plgSystembfstop->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.17 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 14.227 MB Zeilen zurückgegeben: 0
SELECT id, ipaddress
from jos331_bfstop_allowlist
WHERE ((LOCATE('/', ipaddress) != 0
AND LOCATE('.', ipaddress) != 0
AND (INET_ATON('18.222.118.236') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.06 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bfstop/helpers/db.php:188 10 BFStopDBHelper->checkForEntries() JROOT/plugins/system/bfstop/helpers/db.php:225 9 BFStopDBHelper->isIPOnAllowList() JROOT/plugins/system/bfstop/bfstop.php:388 8 plgSystembfstop->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 14.234 MB Zeilen zurückgegeben: 0
SELECT id, ipaddress, crdate, duration
FROM jos331_bfstop_bannedip b
WHERE (ipaddress='18.222.118.236'
AND LOCATE('/', ipaddress) = 0)
AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2024-12-22 19:07:45')
AND NOT EXISTS (SELECT 1
FROM jos331_bfstop_unblock u
WHERE b.id = u.block_id)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY b NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 47 10.00 Using where 2 DEPENDENT SUBQUERY u NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.b.id 1 100.00 Using index Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 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 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bfstop/helpers/db.php:188 10 BFStopDBHelper->checkForEntries() JROOT/plugins/system/bfstop/helpers/db.php:214 9 BFStopDBHelper->isIPBlocked() JROOT/plugins/system/bfstop/bfstop.php:392 8 plgSystembfstop->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 14.240 MB Zeilen zurückgegeben: 0
SELECT id, ipaddress, crdate, duration
FROM jos331_bfstop_bannedip b
WHERE ((LOCATE('/', ipaddress) != 0
AND LOCATE('.', ipaddress) != 0
AND (INET_ATON('18.222.118.236') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))
AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2024-12-22 19:07:45')
AND NOT EXISTS (SELECT 1
FROM jos331_bfstop_unblock u
WHERE b.id = u.block_id)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY b NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 47 100.00 Using where 2 DEPENDENT SUBQUERY u NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.b.id 1 100.00 Using index Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.00 ms optimizing 0.02 ms statistics 0.01 ms preparing 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.00 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bfstop/helpers/db.php:188 10 BFStopDBHelper->checkForEntries() JROOT/plugins/system/bfstop/helpers/db.php:215 9 BFStopDBHelper->isIPBlocked() JROOT/plugins/system/bfstop/bfstop.php:392 8 plgSystembfstop->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.31 ms Nach letzter Abfrage: 10.80 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 15.060 MB Zeilen zurückgegeben: 4
select id, title, alias
from jos331_jumi
where published = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_jumi NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5 20.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 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 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1811 12 JDatabaseDriver->loadRowList() JROOT/plugins/system/jumirouter/jumirouter.php:57 11 parseJumiRouter() Der selbe Aufruf in der Zeile darunter. 10 call_user_func_array() JROOT/libraries/src/Router/Router.php:596 9 Joomla\CMS\Router\Router->processParseRules() JROOT/libraries/src/Router/SiteRouter.php:597 8 Joomla\CMS\Router\SiteRouter->processParseRules() JROOT/libraries/src/Router/Router.php:570 7 Joomla\CMS\Router\Router->_processParseRules() JROOT/libraries/src/Router/Router.php:216 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.66 ms Nach letzter Abfrage: 1.72 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 15.183 MB Zeilen zurückgegeben: 9
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jos331_categories` AS `s`
INNER JOIN `jos331_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 314
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 filesort wurde genutzt 1 SIMPLE c NULL ALL cat_idx,idx_left_right ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 104 18.71 Using where Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.12 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.22 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 14 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 13 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:165 12 ContentRouter->getCategoryId() Der selbe Aufruf in der Zeile darunter. 11 call_user_func_array() JROOT/libraries/src/Component/Router/Rules/StandardRules.php:140 10 Joomla\CMS\Component\Router\Rules\StandardRules->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.55 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 15.256 MB Zeilen zurückgegeben: 1
SELECT `id`
FROM `jos331_content`
WHERE alias = 'brustschwimmen-mit-losen-paddles'
AND catid = '64'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_content NULL ref idx_catid,alias,alias_2,idx_alias alias 766 const 1 6.10 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:225 12 ContentRouter->getArticleId() Der selbe Aufruf in der Zeile darunter. 11 call_user_func_array() JROOT/libraries/src/Component/Router/Rules/StandardRules.php:140 10 Joomla\CMS\Component\Router\Rules\StandardRules->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.28 ms Nach letzter Abfrage: 5.42 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 15.665 MB Zeilen zurückgegeben: 1
SELECT s.*
FROM jos331_template_styles as s
WHERE s.client_id = 0
AND s.id =67id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_client_id,idx_client_id_home PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 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 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/phocaupgrade/phocaupgrade.php:216 8 plgSystemPhocaUpgrade->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.63 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 15.698 MB Zeilen zurückgegeben: 4
SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type`
FROM `jos331_obrss`
WHERE `published` = 1
AND `feeded` = 1
ORDER BY `ordering`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_obrss NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 6 16.67 Using where; filesort wurde genutzt Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 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.06 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/obrss/obrss.php:40 8 plgSystemobrss->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.21 ms Nach letzter Abfrage: 8.45 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 16.403 MB Zeilen zurückgegeben: 68
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos331_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_adminmenumanager','com_ajax','com_akeeba','com_alfcontact','com_articlegenerator','com_associations','com_asurveys','com_attachments','com_bfstop','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativeimageslider','com_customproperties','com_dbreplacer','com_docindexer','com_fields','com_finder','com_flexicontactplus','com_googlesearch_cse','com_gsd','com_installer','com_instantfblogin','com_jce','com_jcomments','com_jem','com_jextranet','com_jmap','com_joomlaupdate','com_jsocialfeed','com_jumi','com_jvld','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_nextend2','com_obrss','com_offlajn_installer','com_phocadownload','com_phocagallery','com_phocamaps','com_phocapdf','com_plugins','com_postinstall','com_privacy','com_redirect','com_responsivizer','com_search','com_spambotcheck','com_tags','com_templateck','com_templates','com_userextranet','com_users','com_weblinks','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_assets NULL range idx_asset_name idx_asset_name 202 NULL 69 100.00 Using index condition Status Duration starting 0.14 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.08 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.24 ms preparing 0.01 ms executing 0.00 ms Sending data 0.55 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 5.89 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.716 MB Speichernutzung vor Abfrage: 16.482 MB Zeilen zurückgegeben: 3881
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos331_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_assets NULL ALL idx_asset_name,idx_parent_id ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5783 21.48 Using where Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 5.55 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.65 ms Nach letzter Abfrage: 8.68 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 19.833 MB Zeilen zurückgegeben: 8
SHOW FULL COLUMNS
FROM `jos331_assets`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `jos331_assets`Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms Sending data 0.05 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.04 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 19 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 18 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 17 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Asset.php:61 16 Joomla\CMS\Table\Asset->__construct() JROOT/libraries/src/Access/Access.php:783 15 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.17 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 19.861 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_assets
WHERE `name` = 'com_content.article.104'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 16 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 15 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.90 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 19.900 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_assets
WHERE `name` = 'com_content.article.104'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 16 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 15 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.60 ms Nach letzter Abfrage: 0.56 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 19.780 MB Zeilen zurückgegeben: 31
SHOW FULL COLUMNS
FROM `jos331_content`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `jos331_content`Status Duration starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.11 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.12 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.03 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.30 ms Nach letzter Abfrage: 2.41 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 19.998 MB
UPDATE jos331_content
SET `hits` = (`hits` + 1)
WHERE `id` = '104'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE jos331_content NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.05 ms updating 0.07 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.51 ms Nach letzter Abfrage: 12.97 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 21.020 MB Zeilen zurückgegeben: 1
SELECT a.id,a.params
FROM jos331_users AS a
WHERE a.name='706' or a.id='706'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL index_merge PRIMARY,idx_name idx_name,PRIMARY 402,4 NULL 2 100.00 Using sort_union(idx_name,PRIMARY); Using where Status Duration starting 0.12 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.00 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 9 JDatabaseDriver->loadObject() JROOT/plugins/system/jgoogleauthor/jgoogleauthor.php:78 8 plgSystemJGoogleAuthor->_get_googleauthorlink() JROOT/plugins/system/jgoogleauthor/jgoogleauthor.php:55 7 plgSystemJGoogleAuthor->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.75 ms Nach letzter Abfrage: 5.08 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 21.369 MB Zeilen zurückgegeben: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jos331_categories` AS `s`
INNER JOIN `jos331_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 64
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 filesort wurde genutzt 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 104 16.86 Using where Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.17 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 23 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 22 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 21 ContentRouter->getCategorySegment() Der selbe Aufruf in der Zeile darunter. 20 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 19 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 18 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 17 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 16 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/administrator/components/com_gsd/GSD/Helper.php:217 11 GSD\Helper::route() JROOT/administrator/components/com_gsd/GSD/Helper.php:89 10 GSD\Helper::getCrumbs() JROOT/plugins/system/gsd/gsd.php:299 9 plgSystemGSD->getJSONBreadcrumbs() JROOT/plugins/system/gsd/gsd.php:118 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1102 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.32 ms Nach letzter Abfrage: 3.52 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 21.660 MB Zeilen zurückgegeben: 1
SELECT a.*
FROM jos331_gsd a
WHERE a.state = 1
AND a.plugin = 'menus'
ORDER BY a.id descid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref state,plugin plugin 152 const 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_gsd/models/items.php:167 15 GSDModelItems->getItems() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:220 14 GSD\PluginBase->getSnippets() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:161 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1102 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.16 ms Nach letzter Abfrage: 1.51 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 21.899 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_assets
WHERE `name` = 'com_content.article.104'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 24 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 23 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 22 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 21 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 20 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 19 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 18 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:78 16 ContentModelArticle->getItem() JROOT/plugins/gsd/content/content.php:57 15 plgGSDContent->viewArticle() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:318 14 GSD\PluginBase->getPayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:155 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1102 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.27 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 21.910 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_assets
WHERE `name` = 'com_content.article.104'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 24 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 23 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 22 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 21 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 20 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 19 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 18 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:78 16 ContentModelArticle->getItem() JROOT/plugins/gsd/content/content.php:57 15 plgGSDContent->viewArticle() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:318 14 GSD\PluginBase->getPayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:155 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1102 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 21.925 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_assets
WHERE `name` = 'com_content.article.104'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 22 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 21 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 20 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 19 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 18 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 17 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:128 16 ContentModelArticle->getItem() JROOT/plugins/gsd/content/content.php:57 15 plgGSDContent->viewArticle() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:318 14 GSD\PluginBase->getPayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:155 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1102 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 21.935 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_assets
WHERE `name` = 'com_content.article.104'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 22 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 21 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 20 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 19 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 18 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 17 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:128 16 ContentModelArticle->getItem() JROOT/plugins/gsd/content/content.php:57 15 plgGSDContent->viewArticle() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:318 14 GSD\PluginBase->getPayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:155 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1102 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.51 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 21.785 MB Zeilen zurückgegeben: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jos331_content AS a
INNER JOIN jos331_categories AS c
on c.id = a.catid
LEFT JOIN jos331_users AS u
on u.id = a.created_by
LEFT JOIN jos331_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos331_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 104
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-22 18:07:45')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-22 18:07:45')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.12 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.07 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 16 ContentModelArticle->getItem() JROOT/plugins/gsd/content/content.php:57 15 plgGSDContent->viewArticle() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:318 14 GSD\PluginBase->getPayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:155 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1102 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.90 ms Nach letzter Abfrage: 2.52 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 21.979 MB Zeilen zurückgegeben: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jos331_fields AS a
LEFT JOIN `jos331_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos331_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos331_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos331_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos331_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos331_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (64,0,314))
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 ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; filesort wurde genutzt 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 usr_web689_1.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 usr_web689_1.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms Creating tmp table 0.06 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.19 ms Creating sort index 0.03 ms end 0.00 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/gsd/content/content.php:267 17 plgGSDContent->getCustomFields() JROOT/plugins/gsd/content/content.php:120 16 plgGSDContent->attachCustomFields() JROOT/plugins/gsd/content/content.php:103 15 plgGSDContent->viewArticle() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:318 14 GSD\PluginBase->getPayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:155 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1102 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 3.26 ms Nach letzter Abfrage: 3.30 ms Abfragespeichernutzung: 0.798 MB Speichernutzung vor Abfrage: 22.267 MB Zeilen zurückgegeben: 513
SELECT a.*
FROM jos331_gsd a
WHERE a.state = 1
AND a.plugin = 'content'
ORDER BY a.id descid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref state,plugin state 1 const 514 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 2.91 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_gsd/models/items.php:167 15 GSDModelItems->getItems() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:220 14 GSD\PluginBase->getSnippets() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:161 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1102 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.65 ms Nach letzter Abfrage: 42.65 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 22.648 MB Zeilen zurückgegeben: 18
SHOW FULL COLUMNS
FROM `jos331_users`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `jos331_users`Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.17 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.07 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.03 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 32 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 31 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 30 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 29 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 28 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 27 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:328 26 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 25 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 24 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 23 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 22 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 21 Joomla\CMS\Factory::getUser() JROOT/plugins/system/nrframework/NRFramework/Factory.php:41 20 NRFramework\Factory->getUser() JROOT/plugins/system/nrframework/NRFramework/SmartTags.php:161 19 NRFramework\SmartTags->addUserTags() JROOT/plugins/system/nrframework/NRFramework/SmartTags.php:105 18 NRFramework\SmartTags->addDefaultTags() JROOT/plugins/system/nrframework/NRFramework/SmartTags.php:431 17 NRFramework\SmartTags->prepare() JROOT/plugins/system/nrframework/NRFramework/SmartTags.php:369 16 NRFramework\SmartTags->replace() JROOT/administrator/components/com_gsd/GSD/MappingOptions.php:125 15 GSD\MappingOptions::replace() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:347 14 GSD\PluginBase->preparePayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:171 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1102 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.16 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 22.683 MB Zeilen zurückgegeben: 0
SELECT *
FROM `jos331_users`
WHERE `id` = 62id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms executing 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 26 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 25 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 24 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 23 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 22 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 21 Joomla\CMS\Factory::getUser() JROOT/plugins/system/nrframework/NRFramework/Factory.php:41 20 NRFramework\Factory->getUser() JROOT/plugins/system/nrframework/NRFramework/SmartTags.php:161 19 NRFramework\SmartTags->addUserTags() JROOT/plugins/system/nrframework/NRFramework/SmartTags.php:105 18 NRFramework\SmartTags->addDefaultTags() JROOT/plugins/system/nrframework/NRFramework/SmartTags.php:431 17 NRFramework\SmartTags->prepare() JROOT/plugins/system/nrframework/NRFramework/SmartTags.php:369 16 NRFramework\SmartTags->replace() JROOT/administrator/components/com_gsd/GSD/MappingOptions.php:125 15 GSD\MappingOptions::replace() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:347 14 GSD\PluginBase->preparePayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:171 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1102 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.36 ms Nach letzter Abfrage: 9.47 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 23.226 MB Zeilen zurückgegeben: 80
SELECT `keyname`,`value`
FROM jos331_jem_configid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_jem_config NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 80 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.07 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/components/com_jem/classes/config.class.php:108 14 JemConfig->loadData() JROOT/components/com_jem/classes/config.class.php:65 13 JemConfig->__construct() JROOT/components/com_jem/classes/config.class.php:49 12 JemConfig::getInstance() JROOT/components/com_jem/helpers/helper.php:77 11 JemHelper::addFileLogger() JROOT/modules/mod_jem_cal/mod_jem_cal.php:25 10 include JROOT/modules/mod_jem_cal/mod_jem_cal.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 3.58 ms Nach letzter Abfrage: 2.02 ms Abfragespeichernutzung: 0.134 MB Speichernutzung vor Abfrage: 23.393 MB Zeilen zurückgegeben: 609
SELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,a.id AS multi
FROM jos331_jem_categories as c
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN jos331_jem_events AS a
ON a.id = rel.itemid
WHERE c.published = 1
AND (c.access IN (1,1,5))
AND c.id IN (2,3,5,9,4,10)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ALL PRIMARY ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 14 7.14 Using where; Using temporary 1 SIMPLE rel NULL ref category event relation,catid category event relation 4 usr_web689_1.c.id 23 100.00 Using where; Using index 1 SIMPLE a NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.rel.itemid 1 100.00 Using where; Using index Status Duration starting 0.09 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms Creating tmp table 0.03 ms executing 0.00 ms Sending data 3.17 ms end 0.01 ms query end 0.01 ms removing tmp table 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 17 JDatabaseDriver->loadColumn() JROOT/components/com_jem/models/eventslist.php:658 16 JemModelEventslist->getCategories() JROOT/components/com_jem/models/eventslist.php:375 15 JemModelEventslist->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 14 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_jem/models/eventslist.php:483 12 JemModelEventslist->getItems() JROOT/modules/mod_jem_cal/helper.php:154 11 ModJemCalHelper::getDays() JROOT/modules/mod_jem_cal/mod_jem_cal.php:152 10 include JROOT/modules/mod_jem_cal/mod_jem_cal.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.42 ms Nach letzter Abfrage: 0.62 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 23.401 MB Zeilen zurückgegeben: 0
SELECT a.access,a.alias,a.attribs,a.checked_out,a.checked_out_time,a.contactid,a.created,a.created_by,a.created_by_alias,a.custom1,a.custom2,a.custom3,a.custom4,a.custom5,a.custom6,a.custom7,a.custom8,a.custom9,a.custom10,a.dates,a.datimage,a.enddates,a.endtimes,a.featured,a.fulltext,a.hits,a.id,a.introtext,a.language,a.locid,a.maxplaces,a.metadata,a.meta_keywords,a.meta_description,a.modified,a.modified_by,a.published,a.registra,a.times,a.title,a.unregistra,a.waitinglist,DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month,a.recurrence_byday,a.recurrence_counter,a.recurrence_first_id,a.recurrence_limit,a.recurrence_limit_date,a.recurrence_number, a.recurrence_type,a.version,u.name AS author,l.alias AS l_alias,l.checked_out AS l_checked_out,l.checked_out_time AS l_checked_out_time,l.city,l.country,l.created AS l_created,l.created_by AS l_createdby,l.custom1 AS l_custom1,l.custom2 AS l_custom2,l.custom3 AS l_custom3,l.custom4 AS l_custom4,l.custom5 AS l_custom5,l.custom6 AS l_custom6,l.custom7 AS l_custom7,l.custom8 AS l_custom8,l.custom9 AS l_custom9,l.custom10 AS l_custom10,l.id AS l_id,l.latitude,l.locdescription,l.locimage,l.longitude,l.map,l.meta_description AS l_meta_description,l.meta_keywords AS l_meta_keywords,l.modified AS l_modified,l.modified_by AS l_modified_by,l.postalCode,l.publish_up AS l_publish_up,l.publish_down AS l_publish_down,l.published AS l_published,l.state,l.street,l.url,l.venue,l.version AS l_version,ct.name AS countryname,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(l.alias) != 0 THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug
FROM jos331_jem_events as a
LEFT JOIN jos331_users AS u
on u.id = a.created_by
LEFT JOIN jos331_jem_venues AS l
ON l.id = a.locid
LEFT JOIN jos331_jem_countries AS ct
ON ct.iso2 = l.country
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.itemid = a.id
LEFT JOIN jos331_jem_categories AS c
ON c.id = rel.catid
WHERE a.access IN (1,1,5)
AND ((`a`.published = 1))
AND DATEDIFF(IF (a.enddates IS NOT NULL, a.enddates, a.dates), '2024-01-01') >= 0
AND DATEDIFF(a.dates, '2024-01-31') <= 0
AND a.dates IS NOT NULL
AND c.id IN (2,3,4,5,9,10)
GROUP BY a.idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref PRIMARY,idx_access,idx_pubstate idx_pubstate 1 const 16 89.96 Using index condition; Using where; Using temporary; filesort wurde genutzt 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.a.created_by 1 100.00 Using where 1 SIMPLE l NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.a.locid 1 100.00 NULL 1 SIMPLE ct NULL ref iso2 iso2 8 usr_web689_1.l.country 1 100.00 NULL 1 SIMPLE rel NULL ref category event relation,catid,itemid itemid 4 usr_web689_1.a.id 1 100.00 Using index condition 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.rel.catid 1 100.00 Using where; Using index Status Duration starting 0.22 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.12 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.03 ms Creating tmp table 0.11 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.50 ms Creating sort index 0.05 ms end 0.00 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_jem/models/eventslist.php:483 12 JemModelEventslist->getItems() JROOT/modules/mod_jem_cal/helper.php:154 11 ModJemCalHelper::getDays() JROOT/modules/mod_jem_cal/mod_jem_cal.php:152 10 include JROOT/modules/mod_jem_cal/mod_jem_cal.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.07 ms Nach letzter Abfrage: 7.80 ms Abfragespeichernutzung: 0.041 MB Speichernutzung vor Abfrage: 24.086 MB Zeilen zurückgegeben: 384
SHOW TABLES
„EXPLAIN“ unmöglich für Abfrage: SHOW TABLESStatus Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms checking permissions 1.55 ms Sending data 0.17 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.01 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 17 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:505 16 JDatabaseDriverMysqli->getTableList() JROOT/administrator/components/com_acymailing/compat/joomla.php:552 15 acymailing_getTableList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:18 14 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:523 13 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:840 12 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:25 11 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/modules/mod_acymailing/mod_acymailing.php:13 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.26 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 24.134 MB Zeilen zurückgegeben: 182
SELECT *
FROM jos331_acymailing_configid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_acymailing_config NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 182 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.11 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:478 15 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:23 14 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:523 13 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:840 12 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:25 11 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/modules/mod_acymailing/mod_acymailing.php:13 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.26 ms Nach letzter Abfrage: 5.79 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 24.573 MB Zeilen zurückgegeben: 1
SELECT *
FROM jos331_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_acymailing_list NULL system typeorderingindex,typeuseridindex ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:478 12 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/list.php:30 11 listClass->getLists() JROOT/modules/mod_acymailing/mod_acymailing.php:149 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.53 ms Nach letzter Abfrage: 24.33 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 26.990 MB Zeilen zurückgegeben: 3
SELECT *
FROM `jos331_acymailing_fields` as a
WHERE a.`published` = 1
AND (a.access = 'all' OR a.access LIKE ('%,9,%'))
ORDER BY a.`ordering` ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref orderingindex orderingindex 1 const 2 55.56 Using index condition; Using where Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 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.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:478 12 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/fields.php:85 11 fieldsClass->getFields() JROOT/modules/mod_acymailing/mod_acymailing.php:245 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.14 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 27.002 MB Zeilen zurückgegeben: 3
SELECT *
FROM `jos331_acymailing_fields`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_acymailing_fields NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 3 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:478 12 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/fields.php:100 11 fieldsClass->getFields() JROOT/modules/mod_acymailing/mod_acymailing.php:245 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.48 ms Nach letzter Abfrage: 3.75 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 27.167 MB Zeilen zurückgegeben: 71
SELECT c.id AS CID
FROM jos331_categories AS c
LEFT JOIN jos331_content AS content
ON c.id = content.catid
WHERE ( c.id = 521 OR c.id = 516 OR c.id = 522 OR c.id = 517 OR c.id = 524 OR c.id = 519 )
AND c.extension = 'com_content'
AND c.published = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL range PRIMARY,cat_idx PRIMARY 4 NULL 6 43.27 Using where 1 SIMPLE content NULL ref idx_catid idx_catid 4 usr_web689_1.c.id 99 100.00 Using where; Using index Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.00 ms Sending data 0.09 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_highlighter_gk5/gk_classes/gk.source.joomla.php:64 12 NH_GK5_Joomla_Source::getSources() JROOT/modules/mod_highlighter_gk5/helper.php:91 11 NH_GK5_Helper->getDatas() JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:21 10 include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.78 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 27.176 MB Zeilen zurückgegeben: 20
SELECT content.id AS iid, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.language AS language, content.featured AS frontpage
FROM jos331_content AS content
WHERE content.state = 1
AND content.access IN (1,1,5)
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2024-12-22 18:07:45' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2024-12-22 18:07:45' )
AND ( content.catid = 517 OR content.catid = 522 )
ORDER BY content.created DESC
LIMIT 0,20;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE content NULL range idx_access,idx_state,idx_catid idx_catid 4 NULL 71 16.00 Using index condition; Using where; filesort wurde genutzt Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.03 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.49 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 13 JDatabaseDriver->loadAssocList() JROOT/modules/mod_highlighter_gk5/gk_classes/gk.source.joomla.php:189 12 NH_GK5_Joomla_Source::getArticles() JROOT/modules/mod_highlighter_gk5/helper.php:93 11 NH_GK5_Helper->getDatas() JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:21 10 include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.62 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 27.212 MB Zeilen zurückgegeben: 20
SELECT content.id AS iid, content.access AS access, categories.title AS catname, users.email AS author_email, content.created_by_alias AS author_alias, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as id,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as cid
FROM jos331_content AS content
LEFT JOIN jos331_categories AS categories
ON categories.id = content.catid
LEFT JOIN jos331_users AS users
ON users.id = content.created_by
LEFT JOIN jos331_content_rating AS content_rating
ON content_rating.content_id = content.id
WHERE content.id = 60464 OR content.id = 60448 OR content.id = 60447 OR content.id = 60439 OR content.id = 60431 OR content.id = 60374 OR content.id = 60307 OR content.id = 60275 OR content.id = 59763 OR content.id = 59755 OR content.id = 59725 OR content.id = 59722 OR content.id = 59680 OR content.id = 59668 OR content.id = 59657 OR content.id = 59650 OR content.id = 59638 OR content.id = 59614 OR content.id = 59603 OR content.id = 59599
ORDER BY content.created DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE content NULL range PRIMARY PRIMARY 4 NULL 20 100.00 Using where; filesort wurde genutzt 1 SIMPLE categories NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.content.catid 1 100.00 Using where 1 SIMPLE users NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.content.created_by 1 100.00 Using where 1 SIMPLE content_rating NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.content.id 1 100.00 Using where Status Duration starting 0.12 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.25 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 13 JDatabaseDriver->loadAssocList() JROOT/modules/mod_highlighter_gk5/gk_classes/gk.source.joomla.php:238 12 NH_GK5_Joomla_Source::getArticles() JROOT/modules/mod_highlighter_gk5/helper.php:93 11 NH_GK5_Helper->getDatas() JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:21 10 include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.51 ms Nach letzter Abfrage: 0.43 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 27.243 MB Zeilen zurückgegeben: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jos331_categories` AS `s`
INNER JOIN `jos331_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 522
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 filesort wurde genutzt 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 104 26.63 Using where Status Duration starting 0.08 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.15 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 23 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 22 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 21 ContentRouter->getCategorySegment() Der selbe Aufruf in der Zeile darunter. 20 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 19 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 18 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 17 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 16 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_highlighter_gk5/helper.php:152 11 NH_GK5_Helper->renderLayout() JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:22 10 include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.52 ms Nach letzter Abfrage: 9.70 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 27.739 MB Zeilen zurückgegeben: 1
SELECT sp.id slider_id, sp.id_template, sp.width, sp.height, sp.itemsoffset, sp.margintop, sp.marginbottom, sp.paddingtop, sp.paddingbottom, sp.showarrows, sp.bgcolor, sp.showreadmore, sp.readmoretext, sp.readmorestyle, sp.readmoresize, sp.readmoreicon, sp.readmorealign, sp.readmoremargin, sp.captionalign, sp.captionmargin, sp.overlaycolor, sp.overlayopacity, sp.textcolor, sp.overlayfontsize, sp.textshadowcolor, sp.textshadowsize, sp.arrow_template, sp.arrow_width, sp.arrow_left_offset, sp.arrow_center_offset, sp.arrow_passive_opacity, sp.move_step, sp.move_time, sp.move_ease, sp.autoplay, sp.autoplay_start_timeout, sp.autoplay_hover_timeout, sp.autoplay_step_timeout, sp.autoplay_evenly_speed, sp.overlayanimationtype, sp.popup_max_size, sp.popup_item_min_width, sp.popup_use_back_img, sp.popup_arrow_passive_opacity, sp.popup_arrow_left_offset, sp.popup_arrow_min_height, sp.popup_arrow_max_height, sp.popup_showarrows, sp.popup_image_order_opacity, sp.popup_image_order_top_offset, sp.popup_show_orderdata, sp.popup_icons_opacity, sp.popup_show_icons, sp.popup_autoplay_default, sp.popup_closeonend, sp.popup_autoplay_time, sp.popup_open_event, sp.link_open_event, sp.cis_touch_enabled, sp.cis_inf_scroll_enabled, sp.cis_mouse_scroll_enabled, sp.cis_item_correction_enabled, sp.cis_animation_type, sp.cis_item_hover_effect, sp.cis_items_appearance_effect, sp.cis_overlay_type, sp.cis_touch_type, sp.cis_font_family, sp.cis_font_effect, sp.icons_size, sp.icons_margin, sp.icons_offset, sp.icons_animation, sp.icons_color, sp.icons_valign, sp.cis_button_font_family, sp.ov_items_offset, sp.ov_items_m_offset, sp.custom_css, sp.custom_js,sp.slider_full_size
FROM `jos331_cis_sliders` sp
WHERE sp.published = '1'
AND sp.id = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE sp NULL system PRIMARY ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 NULL Status Duration starting 0.17 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.08 ms System lock 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 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/components/com_creativeimageslider/helpers/helper.php:174 13 CreativeimagesliderHelper->get_slider_data() JROOT/components/com_creativeimageslider/helpers/helper.php:236 12 CreativeimagesliderHelper->render_slider() JROOT/components/com_creativeimageslider/helpers/helper.php:608 11 CreativeimagesliderHelper->render_html() JROOT/modules/mod_creativeimageslider/mod_creativeimageslider.php:30 10 include JROOT/modules/mod_creativeimageslider/mod_creativeimageslider.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.43 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 27.755 MB Zeilen zurückgegeben: 13
SELECT sa.id img_id, sa.name img_name, sa.img_name img_path, sa.img_url img_url_path ,sa.caption ,sa.showarrows item_showarrows, sa.showreadmore item_showreadmore, sa.readmoretext item_readmoretext, sa.readmorestyle item_readmorestyle, sa.readmoresize item_readmoresize, sa.readmoreicon item_readmoreicon, sa.readmorealign item_readmorealign, sa.readmoremargin item_readmoremargin, sa.captionalign item_captionalign, sa.captionmargin item_captionmargin, sa.overlaycolor item_overlaycolor, sa.overlayopacity item_overlayopacity, sa.textcolor item_textcolor, sa.overlayfontsize item_overlayfontsize, sa.textshadowcolor item_textshadowcolor, sa.textshadowsize item_textshadowsize, sa.overlayusedefault, sa.buttonusedefault, sa.redirect_url, sa.redirect_itemid, sa.redirect_target, sa.popup_img_name, sa.popup_img_url, sa.popup_open_event item_popup_open_event
FROM `jos331_cis_images` sa
WHERE sa.published = '1'
AND sa.id_slider = '1'
ORDER BY sa.ordering,sa.idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE sa NULL ref id_slider id_slider 4 const 14 10.00 Using index condition; Using where; filesort wurde genutzt Status Duration starting 0.06 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.17 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 14 JDatabaseDriver->loadAssocList() JROOT/components/com_creativeimageslider/helpers/helper.php:221 13 CreativeimagesliderHelper->get_slider_items() JROOT/components/com_creativeimageslider/helpers/helper.php:239 12 CreativeimagesliderHelper->render_slider() JROOT/components/com_creativeimageslider/helpers/helper.php:608 11 CreativeimagesliderHelper->render_html() JROOT/modules/mod_creativeimageslider/mod_creativeimageslider.php:30 10 include JROOT/modules/mod_creativeimageslider/mod_creativeimageslider.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.20 ms Nach letzter Abfrage: 1.96 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 27.808 MB Zeilen zurückgegeben: 1Doppelte Abfragen: #64
SELECT COUNT(network) AS cnt
FROM `jos331_cleantalk_sfw`
WHERE network = 316569324 & maskid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_cleantalk_sfw NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 13 10.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:41 15 CleantalkSFW->unversal_query() JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:88 14 CleantalkSFW->check_ip() JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2045 13 plgSystemAntispambycleantalk->sfw_check() JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:749 12 plgSystemAntispambycleantalk->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 27.815 MB Zeilen zurückgegeben: 1Doppelte Abfragen: #63
SELECT COUNT(network) AS cnt
FROM `jos331_cleantalk_sfw`
WHERE network = 316569324 & maskid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_cleantalk_sfw NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 13 10.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 16 JDatabaseDriver->loadAssoc() JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:49 15 CleantalkSFW->unversal_fetch() JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:89 14 CleantalkSFW->check_ip() JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2045 13 plgSystemAntispambycleantalk->sfw_check() JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:749 12 plgSystemAntispambycleantalk->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 27.825 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_jmap_metainfo
WHERE `linkurl` = 'https://gsv-schwimmen.de/ratgeber/technik/brustschwimmen-mit-losen-paddles'
AND `published` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_jmap_metainfo NULL ALL published ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 40 10.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.09 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:426 12 plgSystemJMap->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 27.836 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_jmap_canonicals
WHERE `linkurl` = 'https://gsv-schwimmen.de/ratgeber/technik/brustschwimmen-mit-losen-paddles'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_jmap_canonicals NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:504 12 plgSystemJMap->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.46 ms Nach letzter Abfrage: 15.43 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 29.668 MB Zeilen zurückgegeben: 1
SELECT a.id, a.alias, a.attribs, a.catid, c.alias AS category_alias
FROM jos331_content AS a
LEFT JOIN jos331_categories AS c
on c.id = a.catid
WHERE a.id = 104
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 8 JDatabaseDriver->loadObject() JROOT/plugins/system/phocapdf/phocapdf.php:62 7 plgSystemPhocaPDF->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.26 ms Nach letzter Abfrage: 6.12 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 29.898 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_jmap_headings
WHERE `linkurl` = 'https://gsv-schwimmen.de/ratgeber/technik/brustschwimmen-mit-losen-paddles'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_jmap_headings NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 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 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 8 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:813 7 plgSystemJMap->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
50 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
7 × SELECT c.id
FROM jos331_content AS c6 × SELECT *
FROM jos331_assets3 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jos331_categories` AS `s`
INNER JOIN `jos331_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)2 × SELECT a.*
FROM jos331_gsd a2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos331_assets`2 × SELECT id, ipaddress, crdate, duration
FROM jos331_bfstop_bannedip b2 × SELECT id, ipaddress
from jos331_bfstop_allowlist2 × SELECT COUNT(network) AS cnt
FROM `jos331_cleantalk_sfw`1 × SELECT sa.id img_id, sa.name img_name, sa.img_name img_path, sa.img_url img_url_path ,sa.caption ,sa.showarrows item_showarrows, sa.showreadmore item_showreadmore, sa.readmoretext item_readmoretext, sa.readmorestyle item_readmorestyle, sa.readmoresize item_readmoresize, sa.readmoreicon item_readmoreicon, sa.readmorealign item_readmorealign, sa.readmoremargin item_readmoremargin, sa.captionalign item_captionalign, sa.captionmargin item_captionmargin, sa.overlaycolor item_overlaycolor, sa.overlayopacity item_overlayopacity, sa.textcolor item_textcolor, sa.overlayfontsize item_overlayfontsize, sa.textshadowcolor item_textshadowcolor, sa.textshadowsize item_textshadowsize, sa.overlayusedefault, sa.buttonusedefault, sa.redirect_url, sa.redirect_itemid, sa.redirect_target, sa.popup_img_name, sa.popup_img_url, sa.popup_open_event item_popup_open_event
FROM `jos331_cis_images` sa1 × SELECT sp.id slider_id, sp.id_template, sp.width, sp.height, sp.itemsoffset, sp.margintop, sp.marginbottom, sp.paddingtop, sp.paddingbottom, sp.showarrows, sp.bgcolor, sp.showreadmore, sp.readmoretext, sp.readmorestyle, sp.readmoresize, sp.readmoreicon, sp.readmorealign, sp.readmoremargin, sp.captionalign, sp.captionmargin, sp.overlaycolor, sp.overlayopacity, sp.textcolor, sp.overlayfontsize, sp.textshadowcolor, sp.textshadowsize, sp.arrow_template, sp.arrow_width, sp.arrow_left_offset, sp.arrow_center_offset, sp.arrow_passive_opacity, sp.move_step, sp.move_time, sp.move_ease, sp.autoplay, sp.autoplay_start_timeout, sp.autoplay_hover_timeout, sp.autoplay_step_timeout, sp.autoplay_evenly_speed, sp.overlayanimationtype, sp.popup_max_size, sp.popup_item_min_width, sp.popup_use_back_img, sp.popup_arrow_passive_opacity, sp.popup_arrow_left_offset, sp.popup_arrow_min_height, sp.popup_arrow_max_height, sp.popup_showarrows, sp.popup_image_order_opacity, sp.popup_image_order_top_offset, sp.popup_show_orderdata, sp.popup_icons_opacity, sp.popup_show_icons, sp.popup_autoplay_default, sp.popup_closeonend, sp.popup_autoplay_time, sp.popup_open_event, sp.link_open_event, sp.cis_touch_enabled, sp.cis_inf_scroll_enabled, sp.cis_mouse_scroll_enabled, sp.cis_item_correction_enabled, sp.cis_animation_type, sp.cis_item_hover_effect, sp.cis_items_appearance_effect, sp.cis_overlay_type, sp.cis_touch_type, sp.cis_font_family, sp.cis_font_effect, sp.icons_size, sp.icons_margin, sp.icons_offset, sp.icons_animation, sp.icons_color, sp.icons_valign, sp.cis_button_font_family, sp.ov_items_offset, sp.ov_items_m_offset, sp.custom_css, sp.custom_js,sp.slider_full_size
FROM `jos331_cis_sliders` sp1 × SELECT content.id AS iid, content.access AS access, categories.title AS catname, users.email AS author_email, content.created_by_alias AS author_alias, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as id,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as cid
FROM jos331_content AS content
LEFT JOIN jos331_categories AS categories
ON categories.id = content.catid
LEFT JOIN jos331_users AS users
ON users.id = content.created_by
LEFT JOIN jos331_content_rating AS content_rating
ON content_rating.content_id = content.id1 × SELECT content.id AS iid, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.language AS language, content.featured AS frontpage
FROM jos331_content AS content1 × SELECT `keyname`,`value`
FROM jos331_jem_confi1 × SELECT c.id AS CID
FROM jos331_categories AS c
LEFT JOIN jos331_content AS content
ON c.id = content.catid1 × SELECT *
FROM jos331_jmap_metainfo1 × SELECT *
FROM `jos331_acymailing_fields1 × SELECT *
FROM `jos331_acymailing_fields` as a1 × SELECT *
FROM jos331_acymailing_list1 × SELECT *
FROM jos331_jmap_canonicals1 × SELECT a.id, a.alias, a.attribs, a.catid, c.alias AS category_alias
FROM jos331_content AS a
LEFT JOIN jos331_categories AS c
on c.id = a.catid1 × SELECT *
FROM jos331_acymailing_confi1 × SELECT a.access,a.alias,a.attribs,a.checked_out,a.checked_out_time,a.contactid,a.created,a.created_by,a.created_by_alias,a.custom1,a.custom2,a.custom3,a.custom4,a.custom5,a.custom6,a.custom7,a.custom8,a.custom9,a.custom10,a.dates,a.datimage,a.enddates,a.endtimes,a.featured,a.fulltext,a.hits,a.id,a.introtext,a.language,a.locid,a.maxplaces,a.metadata,a.meta_keywords,a.meta_description,a.modified,a.modified_by,a.published,a.registra,a.times,a.title,a.unregistra,a.waitinglist,DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month,a.recurrence_byday,a.recurrence_counter,a.recurrence_first_id,a.recurrence_limit,a.recurrence_limit_date,a.recurrence_number, a.recurrence_type,a.version,u.name AS author,l.alias AS l_alias,l.checked_out AS l_checked_out,l.checked_out_time AS l_checked_out_time,l.city,l.country,l.created AS l_created,l.created_by AS l_createdby,l.custom1 AS l_custom1,l.custom2 AS l_custom2,l.custom3 AS l_custom3,l.custom4 AS l_custom4,l.custom5 AS l_custom5,l.custom6 AS l_custom6,l.custom7 AS l_custom7,l.custom8 AS l_custom8,l.custom9 AS l_custom9,l.custom10 AS l_custom10,l.id AS l_id,l.latitude,l.locdescription,l.locimage,l.longitude,l.map,l.meta_description AS l_meta_description,l.meta_keywords AS l_meta_keywords,l.modified AS l_modified,l.modified_by AS l_modified_by,l.postalCode,l.publish_up AS l_publish_up,l.publish_down AS l_publish_down,l.published AS l_published,l.state,l.street,l.url,l.venue,l.version AS l_version,ct.name AS countryname,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(l.alias) != 0 THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug
FROM jos331_jem_events as a
LEFT JOIN jos331_users AS u
on u.id = a.created_by
LEFT JOIN jos331_jem_venues AS l
ON l.id = a.locid
LEFT JOIN jos331_jem_countries AS ct
ON ct.iso2 = l.country
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.itemid = a.id
LEFT JOIN jos331_jem_categories AS c
ON c.id = rel.catid1 × SELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,a.id AS multi
FROM jos331_jem_categories as c
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN jos331_jem_events AS a
ON a.id = rel.itemid1 × SELECT `data`
FROM `jos331_session`1 × SELECT *
FROM `jos331_users`1 × select sparams
from `jos331_jvld_styles`1 × SELECT id, rules
FROM `jos331_viewlevels1 × SELECT b.id
FROM jos331_usergroups AS a
LEFT JOIN jos331_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT *
FROM jos331_gsd_config1 × SELECT *
FROM `jos331_redirect_links`1 × select version, dir_online, value
from `jos331_jvld_settings`1 × select id
from jos331_menu1 × select email
from jos331_users1 × 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 jos331_fields AS a
LEFT JOIN `jos331_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos331_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos331_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos331_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos331_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos331_fields_categories` AS fc
ON fc.field_id = a.id1 × select id, title, alias
from jos331_jumi1 × SELECT `id`
FROM `jos331_content`1 × SELECT s.*
FROM jos331_template_styles as s1 × SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type`
FROM `jos331_obrss`1 × SELECT a.id,a.params
FROM jos331_users AS a1 × SELECT `session_id`
FROM `jos331_session`1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jos331_content AS a
INNER JOIN jos331_categories AS c
on c.id = a.catid
LEFT JOIN jos331_users AS u
on u.id = a.created_by
LEFT JOIN jos331_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos331_content_rating AS v
ON a.id = v.content_id1 × SELECT *
FROM jos331_jmap_headings
Andere Tabellen:
1 × INSERT INTO `jos331_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6233303737373930353637663839393832393161356139343932396635313564', 1, 1734890865, 0, '', 01 × SHOW FULL COLUMNS
FROM `jos331_gsd_config1 × UPDATE `jos331_extensions`
SET `params` = '{\"mediaversion\":\"57eae9eb2e22f36ce39aca1eecf18754\"}'1 × SHOW FULL COLUMNS
FROM `jos331_assets1 × SHOW FULL COLUMNS
FROM `jos331_content1 × UPDATE jos331_content
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `jos331_users1 × SHOW TABLE