IT Know How.

Beratung und Service – alles aus einer Hand. Wir analysieren das Optimierungspotential Ihrer Unternehmens-IT und sorgen für die Einrichtung und den reibungslosen Betrieb.

zum IT-Consulting

IT-Training

Ihr Ansprechpartner:

Harald Radtke

+49 40 37 08 82 98

Sie wollen, dass Ihre Mitarbeiter die Programme, die sie einsetzen, effizienter nutzen? Durch die enge Zusammenarbeit zwischen Ihnen und unserem Trainingmanager garantieren wir Ihnen das Erreichen der definierten Ziele.

zum IT-Training

Skillfactory

Ihre Ansprechpartnerin:

Eva Pleger

+49 40 37 08 82 99

Wenn es um Softskill-Training geht, sollte die Skillfactory Ihre erste Wahl sein. Denn bei uns ermittelt Ihr Kundenbetreuer in enger Abstimmung mit Ihnen Ihren Bedarf und sucht daraufhin den geeigneten Trainer für Sie aus.

zur Skillfactory

Webdesign

Ihr Ansprechpartner:

Uli Himstedt

+49 40 37 08 83 10

Ihre Website soll elegant gestaltet sein, jedoch selbst bei schlechtem Netzempfang schnell laden? Wir gestalten und entwickeln Ihren Webauftritt „Mobile First“, also mit Hauptaugenmerk auf der Nutzung mit mobilen Endgeräten.

zum Webdesign

News & Trends

Updates zu technischen Themen wie Docker oder VMware sowie Softskill-Themen wie Digitale Transformation oder Führung in der IT finden Sie auf unserem Blog.

Aktuelle Artikel:

weitere Blogartikel

Unser Standort:
HafenCity Hamburg

Sicher zu finden: Unser Trainingszentrum und unser Büro am Hamburger Hafen liegen direkt am Überseequartier – citynah und mit öffentlichen Verkehrsmitteln perfekt erreichbar.

Anschrift, Anfahrt & Hotels

zu Google Maps

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1679351029,
                "last": 1679351029,
                "now": 1679351029
            },
            "token": "6FRF1u64a6Omn1CA8aRXTab2P20Gm4PJ"
        },
        "registry": {
            "plg_system_eprivacygeoip_cache": {
                "cc": "US",
                "abbr": "USA",
                "name": "United States"
            }
        },
        "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
        }
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 1.27 ms / 1.27 ms Speicher: 0.051 MB / 0.38 MB Application: afterLoad

Zeit: 31.05 ms / 32.32 ms Speicher: 0.883 MB / 1.27 MB Application: afterInitialise

Zeit: 9.22 ms / 41.54 ms Speicher: 1.709 MB / 2.98 MB Application: afterRoute

Zeit: 0.69 ms / 42.23 ms Speicher: 0.022 MB / 3.00 MB Application: beforeRenderComponent com_users

Zeit: 4.08 ms / 46.31 ms Speicher: 0.224 MB / 3.22 MB Application: afterRenderComponent com_users

Zeit: 0.24 ms / 46.55 ms Speicher: 0.005 MB / 3.23 MB Application: afterDispatch

Zeit: 10.68 ms / 57.22 ms Speicher: 0.248 MB / 3.47 MB Application: beforeRenderModule mod_menu (Hier finden Sie uns)

Zeit: 0.54 ms / 57.77 ms Speicher: 0.028 MB / 3.50 MB Application: afterRenderModule mod_menu (Hier finden Sie uns)

Zeit: 0.03 ms / 57.80 ms Speicher: 0.000 MB / 3.50 MB Application: beforeRenderModule mod_menu (Rechtliches)

Zeit: 0.41 ms / 58.21 ms Speicher: 0.037 MB / 3.54 MB Application: afterRenderModule mod_menu (Rechtliches)

Zeit: 0.03 ms / 58.24 ms Speicher: 0.000 MB / 3.54 MB Application: beforeRenderModule mod_menu (Unternehmen)

Zeit: 0.36 ms / 58.60 ms Speicher: 0.029 MB / 3.56 MB Application: afterRenderModule mod_menu (Unternehmen)

Zeit: 0.03 ms / 58.63 ms Speicher: 0.000 MB / 3.56 MB Application: beforeRenderModule mod_custom (Startseite - Anfahrt)

Zeit: 0.15 ms / 58.78 ms Speicher: 0.005 MB / 3.57 MB Application: afterRenderModule mod_custom (Startseite - Anfahrt)

Zeit: 0.01 ms / 58.79 ms Speicher: 0.000 MB / 3.56 MB Application: beforeRenderModule mod_custom (Anfahrt (Google Maps))

Zeit: 0.03 ms / 58.82 ms Speicher: 0.003 MB / 3.57 MB Application: afterRenderModule mod_custom (Anfahrt (Google Maps))

Zeit: 0.03 ms / 58.85 ms Speicher: 0.004 MB / 3.57 MB Application: beforeRenderModule mod_acymailing (Startseite - Newsletter)

Zeit: 2.51 ms / 61.36 ms Speicher: 0.455 MB / 4.03 MB Application: afterRenderModule mod_acymailing (Startseite - Newsletter)

Zeit: 0.03 ms / 61.39 ms Speicher: 0.000 MB / 4.00 MB Application: beforeRenderModule mod_custom (Startseite - Blog Post)

Zeit: 0.04 ms / 61.43 ms Speicher: 0.003 MB / 4.00 MB Application: afterRenderModule mod_custom (Startseite - Blog Post)

Zeit: 0.02 ms / 61.45 ms Speicher: 0.000 MB / 4.00 MB Application: beforeRenderModule mod_custom (Startseite - Blog Pre)

Zeit: 0.03 ms / 61.48 ms Speicher: 0.003 MB / 4.01 MB Application: afterRenderModule mod_custom (Startseite - Blog Pre)

Zeit: 0.02 ms / 61.50 ms Speicher: 0.000 MB / 4.01 MB Application: beforeRenderModule mod_custom (Startseite - Unit Skillfactory)

Zeit: 0.03 ms / 61.52 ms Speicher: 0.003 MB / 4.01 MB Application: afterRenderModule mod_custom (Startseite - Unit Skillfactory)

Zeit: 0.01 ms / 61.53 ms Speicher: 0.000 MB / 4.01 MB Application: beforeRenderModule mod_custom (Startseite - Unit Webdesign)

Zeit: 0.03 ms / 61.56 ms Speicher: 0.003 MB / 4.01 MB Application: afterRenderModule mod_custom (Startseite - Unit Webdesign)

Zeit: 0.02 ms / 61.58 ms Speicher: 0.001 MB / 4.01 MB Application: beforeRenderModule mod_custom (Herstellerliste Microsoft, VMware, Cisco, Citrix Online)

Zeit: 0.03 ms / 61.60 ms Speicher: 0.003 MB / 4.01 MB Application: afterRenderModule mod_custom (Herstellerliste Microsoft, VMware, Cisco, Citrix Online)

Zeit: 0.01 ms / 61.61 ms Speicher: 0.000 MB / 4.01 MB Application: beforeRenderModule mod_custom (Herstellerliste Linux, ITSM Group, Comptia, Veeam)

Zeit: 0.03 ms / 61.64 ms Speicher: 0.003 MB / 4.02 MB Application: afterRenderModule mod_custom (Herstellerliste Linux, ITSM Group, Comptia, Veeam)

Zeit: 0.01 ms / 61.65 ms Speicher: 0.000 MB / 4.02 MB Application: beforeRenderModule mod_custom (Herstellerliste Exasol, Kaspersky, Swyx, Trendmicro)

Zeit: 0.02 ms / 61.68 ms Speicher: 0.003 MB / 4.02 MB Application: afterRenderModule mod_custom (Herstellerliste Exasol, Kaspersky, Swyx, Trendmicro)

Zeit: 0.01 ms / 61.69 ms Speicher: 0.000 MB / 4.02 MB Application: beforeRenderModule mod_custom (Herstellerliste Securepoint, SuSe, GFN, Stellar)

Zeit: 0.02 ms / 61.71 ms Speicher: 0.005 MB / 4.02 MB Application: afterRenderModule mod_custom (Herstellerliste Securepoint, SuSe, GFN, Stellar)

Zeit: 0.02 ms / 61.73 ms Speicher: 0.000 MB / 4.02 MB Application: beforeRenderModule mod_custom (Startseite: Unit IT-Consulting)

Zeit: 0.03 ms / 61.75 ms Speicher: 0.003 MB / 4.03 MB Application: afterRenderModule mod_custom (Startseite: Unit IT-Consulting)

Zeit: 0.01 ms / 61.76 ms Speicher: 0.000 MB / 4.02 MB Application: beforeRenderModule mod_custom (Startseite - Unit IT-Training)

Zeit: 0.02 ms / 61.79 ms Speicher: 0.003 MB / 4.03 MB Application: afterRenderModule mod_custom (Startseite - Unit IT-Training)

Zeit: 0.02 ms / 61.81 ms Speicher: 0.001 MB / 4.03 MB Application: beforeRenderModule mod_custom (Startseite - Above The Fold Link)

Zeit: 0.03 ms / 61.83 ms Speicher: 0.003 MB / 4.03 MB Application: afterRenderModule mod_custom (Startseite - Above The Fold Link)

Zeit: 0.02 ms / 61.85 ms Speicher: 0.000 MB / 4.03 MB Application: beforeRenderModule mod_custom (Above The Fold - Startseite - IT Know How.)

Zeit: 0.03 ms / 61.88 ms Speicher: 0.003 MB / 4.03 MB Application: afterRenderModule mod_custom (Above The Fold - Startseite - IT Know How.)

Zeit: 0.01 ms / 61.89 ms Speicher: 0.000 MB / 4.03 MB Application: beforeRenderModule mod_custom (Above The Fold - Startseite - flex)

Zeit: 0.03 ms / 61.91 ms Speicher: 0.003 MB / 4.04 MB Application: afterRenderModule mod_custom (Above The Fold - Startseite - flex)

Zeit: 0.01 ms / 61.92 ms Speicher: 0.000 MB / 4.04 MB Application: beforeRenderModule mod_custom (Above The Fold - Startseite - Blockchain)

Zeit: 0.02 ms / 61.94 ms Speicher: 0.003 MB / 4.04 MB Application: afterRenderModule mod_custom (Above The Fold - Startseite - Blockchain)

Zeit: 0.01 ms / 61.95 ms Speicher: 0.000 MB / 4.04 MB Application: beforeRenderModule mod_custom (Above The Fold - IT-Consulting - Kompetenzleasing)

Zeit: 0.02 ms / 61.98 ms Speicher: 0.003 MB / 4.04 MB Application: afterRenderModule mod_custom (Above The Fold - IT-Consulting - Kompetenzleasing)

Zeit: 0.01 ms / 61.99 ms Speicher: 0.000 MB / 4.04 MB Application: beforeRenderModule mod_custom (Above The Fold - IT-Consulting - enreach)

Zeit: 0.02 ms / 62.01 ms Speicher: 0.003 MB / 4.04 MB Application: afterRenderModule mod_custom (Above The Fold - IT-Consulting - enreach)

Zeit: 0.01 ms / 62.02 ms Speicher: 0.000 MB / 4.04 MB Application: beforeRenderModule mod_custom (Above The Fold - IT-Consulting - Security)

Zeit: 0.02 ms / 62.04 ms Speicher: 0.003 MB / 4.05 MB Application: afterRenderModule mod_custom (Above The Fold - IT-Consulting - Security)

Zeit: 0.01 ms / 62.05 ms Speicher: 0.000 MB / 4.04 MB Application: beforeRenderModule mod_custom (Exasol - beyond the data frontier)

Zeit: 0.02 ms / 62.08 ms Speicher: 0.003 MB / 4.05 MB Application: afterRenderModule mod_custom (Exasol - beyond the data frontier)

Zeit: 0.01 ms / 62.08 ms Speicher: 0.000 MB / 4.05 MB Application: beforeRenderModule mod_custom (Above The Fold - IT-Training - Windows 10 Supportmitarbeiter-Workshop)

Zeit: 0.02 ms / 62.11 ms Speicher: 0.003 MB / 4.05 MB Application: afterRenderModule mod_custom (Above The Fold - IT-Training - Windows 10 Supportmitarbeiter-Workshop)

Zeit: 0.01 ms / 62.12 ms Speicher: 0.000 MB / 4.05 MB Application: beforeRenderModule mod_custom ( Above The Fold - IT-Training - Flex Unit Excel Der Refresher)

Zeit: 0.02 ms / 62.14 ms Speicher: 0.003 MB / 4.05 MB Application: afterRenderModule mod_custom ( Above The Fold - IT-Training - Flex Unit Excel Der Refresher)

Zeit: 0.02 ms / 62.16 ms Speicher: 0.001 MB / 4.05 MB Application: beforeRenderModule mod_menu (Top-Menu)

Zeit: 2.41 ms / 64.58 ms Speicher: 0.403 MB / 4.46 MB Application: afterRenderModule mod_menu (Top-Menu)

Zeit: 2.87 ms / 67.44 ms Speicher: 0.382 MB / 4.84 MB Application: afterRender

Datenbankabfragen gesamt: 37.68 ms

Speichernutzung

Datenbankabfragen

23 ausgeführte Abfragen 37.68 ms

Abfragezeit: 14.04 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 0.659 MB

DELETE 

  FROM `pleger_website_2017_session`

  WHERE `time` < '1679350129'

Explain

„EXPLAIN“ unmöglich für Abfrage: DELETE FROM `pleger_website_2017_session` WHERE `time` < '1679350129'

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.07 ms
Updating	0.08 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	13.71 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:818
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.26 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 0.668 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `pleger_website_2017_session`

  WHERE `session_id` = 'c24q62mcrm1b3ba93hvcj0thh3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pleger_website_2017_session	const	PRIMARY	PRIMARY	766	const	1

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Derselbe Aufruf in der Zeile darunter.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:825
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.29 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 0.681 MB Zeilen zurückgegeben: 0

SELECT `session_id`

  FROM `pleger_website_2017_session`

  WHERE `session_id` = 'c24q62mcrm1b3ba93hvcj0thh3' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pleger_website_2017_session	const	PRIMARY	PRIMARY	766	const	1	Using index

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 3.33 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 0.686 MB

INSERT INTO `pleger_website_2017_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('c24q62mcrm1b3ba93hvcj0thh3', 1, '1679351029', 0, '', 0)

Explain

„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `pleger_website_2017_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('c24q62mcrm1b3ba93hvcj0thh3', 1, '1679351029', 0, '', 0)

Profil (Profile)

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.01 ms
Update	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	3.09 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.56 ms Nach letzter Abfrage: 0.38 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 0.707 MB Zeilen zurückgegeben: 41

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `pleger_website_2017_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pleger_website_2017_extensions	ref	extension	extension	82	const	41	Using index condition

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.21 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.39 ms Nach letzter Abfrage: 0.49 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 0.745 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM pleger_website_2017_usergroups AS a

  LEFT JOIN pleger_website_2017_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

Profil (Profile)

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.28 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 0.749 MB Zeilen zurückgegeben: 5

SELECT id, rules

  FROM `pleger_website_2017_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pleger_website_2017_viewlevels	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	5

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 1.07 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 0.776 MB Zeilen zurückgegeben: 105

SELECT `folder` AS `type`,`element` AS `name`,`params`

  FROM pleger_website_2017_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pleger_website_2017_extensions	ALL	extension	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	293	Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.70 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.29 ms Nach letzter Abfrage: 2.96 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.069 MB Zeilen zurückgegeben: 1

SELECT `enabled`

  FROM `pleger_website_2017_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pleger_website_2017_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:71
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.21 ms Nach letzter Abfrage: 1.95 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.252 MB Zeilen zurückgegeben: 1

SELECT count(*)

  FROM `pleger_website_2017_cwgears_schedule`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pleger_website_2017_cwgears_schedule	index	NULL	PRIMARY	4	NULL	1	Using index

Profil (Profile)

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:96
8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.257 MB Zeilen zurückgegeben: 1

SELECT count(*)

  FROM `pleger_website_2017_cwgears_schedule`

  WHERE time + '86400'<'1679351029'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pleger_website_2017_cwgears_schedule	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	Using where

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:139
8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 2.88 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.481 MB Speichernutzung vor Abfrage: 1.293 MB Zeilen zurückgegeben: 407

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM pleger_website_2017_menu AS m

  LEFT JOIN pleger_website_2017_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	556	Using where; filesort wurde genutzt
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	pcsdb.m.component_id	1	Using where

Profil (Profile)

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	2.56 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
16	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:443
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:548
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1141
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.19 ms Nach letzter Abfrage: 3.21 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 2.898 MB Zeilen zurückgegeben: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `pleger_website_2017_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pleger_website_2017_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Profil (Profile)

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
16	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
14	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
13	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
12	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/cwgears/cwgears.php:195
8	plgSystemCwgears->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 2.36 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 2.890 MB

UPDATE `pleger_website_2017_extensions`

  SET `params` = '{\"mediaversion\":\"1940520e6f22d4d4b18fb9c639afd1ea\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

„EXPLAIN“ unmöglich für Abfrage: UPDATE `pleger_website_2017_extensions` SET `params` = '{\"mediaversion\":\"1940520e6f22d4d4b18fb9c639afd1ea\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil (Profile)

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.03 ms
Updating	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	2.22 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/cwgears/cwgears.php:195
8	plgSystemCwgears->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.14 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.972 MB Zeilen zurückgegeben: 1

SELECT count(*)

  FROM `pleger_website_2017_extensions`

  WHERE `element` = 'cwgears' 
  AND `extension_id` = ''

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil (Profile)

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:1003
9	plgSystemCwgears->updateDownloadKeySub()	JROOT/plugins/system/cwgears/cwgears.php:202
8	plgSystemCwgears->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 2.981 MB Zeilen zurückgegeben: 2

SELECT *

  FROM pleger_website_2017_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pleger_website_2017_languages	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2	Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.992 MB Zeilen zurückgegeben: 2

SELECT id, home, template, s.params

  FROM pleger_website_2017_template_styles as s

  LEFT JOIN pleger_website_2017_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	pcsdb.s.template,const	1	Using index condition; Using where

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.36 ms Nach letzter Abfrage: 1.29 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 3.174 MB Zeilen zurückgegeben: 0

SELECT 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

  FROM pleger_website_2017_fields AS a

  LEFT JOIN `pleger_website_2017_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN pleger_website_2017_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN pleger_website_2017_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN pleger_website_2017_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN pleger_website_2017_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_users.remind' 
  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 DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; filesort wurde genutzt
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	pcsdb.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	pcsdb.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	pcsdb.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	pcsdb.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	pcsdb.a.group_id	1	Using where

Profil (Profile)

Status	Duration
Starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
22	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
21	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
20	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:281
18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:236
17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/legacy/model/form.php:313
14	JModelForm->preprocessForm()	JROOT/components/com_users/models/remind.php:59
13	UsersModelRemind->preprocessForm()	JROOT/libraries/legacy/model/form.php:234
12	JModelForm->loadForm()	JROOT/components/com_users/models/remind.php:34
11	UsersModelRemind->getForm()	JROOT/libraries/legacy/view/legacy.php:422
10	JViewLegacy->get()	JROOT/components/com_users/views/remind/view.html.php:37
9	UsersViewRemind->display()	JROOT/components/com_users/controller.php:133
8	UsersController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_users/users.php:15
6	require_once JROOT/components/com_users/users.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 9.76 ms Nach letzter Abfrage: 3.20 ms Abfragespeichernutzung: 0.086 MB Speichernutzung vor Abfrage: 3.419 MB Zeilen zurückgegeben: 104

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM pleger_website_2017_modules AS m

  LEFT JOIN pleger_website_2017_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN pleger_website_2017_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-03-20 22:23:49') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-20 22:23:49') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 467 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	759	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	pcsdb.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	pcsdb.m.id	1	Using where; Using index

Profil (Profile)

Status	Duration
Starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	9.37 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
8	JDocumentHtml->countModules()	JROOT/templates/pcs/index.php:1766
7	require JROOT/templates/pcs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.23 ms Nach letzter Abfrage: 2.33 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 3.614 MB Zeilen zurückgegeben: 136

SELECT * 
  FROM pleger_website_2017_acymailing_config

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pleger_website_2017_acymailing_config	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	136

Profil (Profile)

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.12 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
15	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
14	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:438
13	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:822
12	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:22
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/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.26 ms Nach letzter Abfrage: 1.62 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 4.023 MB Zeilen zurückgegeben: 4

SELECT * 
  FROM pleger_website_2017_acymailing_list 
  WHERE type = 'list'  
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pleger_website_2017_acymailing_list	ALL	typeorderingindex,typeuseridindex	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	4	Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.12 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
12	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:30
11	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:148
10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.12 ms Nach letzter Abfrage: 3.53 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.439 MB Zeilen zurückgegeben: 0

SELECT uikit

  FROM `pleger_website_2017_cwgears`

  WHERE url = 'https://www.pcs-company.de/component/users/?view=remind&Itemid=467'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pleger_website_2017_cwgears	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	Using where

Profil (Profile)

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:67
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:418
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
9	JApplicationBase->triggerEvent()	JROOT/libraries/joomla/document/renderer/html/head.php:63
8	JDocumentRendererHtmlHead->fetchHead()	JROOT/libraries/joomla/document/renderer/html/head.php:34
7	JDocumentRendererHtmlHead->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.445 MB Zeilen zurückgegeben: 0

SELECT uikit_plus

  FROM `pleger_website_2017_cwgears`

  WHERE url = 'https://www.pcs-company.de/component/users/?view=remind&Itemid=467'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pleger_website_2017_cwgears	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	Using where

Profil (Profile)

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:67
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:427
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
9	JApplicationBase->triggerEvent()	JROOT/libraries/joomla/document/renderer/html/head.php:63
8	JDocumentRendererHtmlHead->fetchHead()	JROOT/libraries/joomla/document/renderer/html/head.php:34
7	JDocumentRendererHtmlHead->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

22 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `pleger_website_2017_extensions`

1 × SELECT `data` 
  FROM `pleger_website_2017_session`

1 × SELECT * 
  FROM pleger_website_2017_languages

1 × SELECT uikit 
  FROM `pleger_website_2017_cwgears`

1 × SELECT * 
  FROM pleger_website_2017_acymailing_list

1 × SELECT * 
  FROM pleger_website_2017_acymailing_confi

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM pleger_website_2017_modules AS m 
  LEFT JOIN pleger_website_2017_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN pleger_website_2017_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT 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 
  FROM pleger_website_2017_fields AS a 
  LEFT JOIN `pleger_website_2017_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN pleger_website_2017_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN pleger_website_2017_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN pleger_website_2017_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN pleger_website_2017_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT id, home, template, s.params 
  FROM pleger_website_2017_template_styles as s 
  LEFT JOIN pleger_website_2017_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM pleger_website_2017_menu AS m 
  LEFT JOIN pleger_website_2017_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT count(*) 
  FROM `pleger_website_2017_extensions`

1 × SELECT `session_id` 
  FROM `pleger_website_2017_session`

1 × SELECT count(*) 
  FROM `pleger_website_2017_cwgears_schedule`

1 × SELECT count(*) 
  FROM `pleger_website_2017_cwgears_schedule

1 × SELECT `enabled` 
  FROM `pleger_website_2017_extensions`

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM pleger_website_2017_extensions

1 × SELECT id, rules 
  FROM `pleger_website_2017_viewlevels

1 × SELECT b.id 
  FROM pleger_website_2017_usergroups AS a 
  LEFT JOIN pleger_website_2017_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT uikit_plus 
  FROM `pleger_website_2017_cwgears`

Andere Tabellen:

1 × DELETE  
  FROM `pleger_website_2017_session`

1 × INSERT INTO `pleger_website_2017_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('c24q62mcrm1b3ba93hvcj0thh3', 1, '1679351029', 0, '', 0

1 × UPDATE `pleger_website_2017_extensions` 
  SET `params` = '{\"mediaversion\":\"1940520e6f22d4d4b18fb9c639afd1ea\"}'

IT Know How.

Blockchain - Baustein in der digitalen Transformation

Technologie der Zukunft

Kompetenz­leasing

für Ihre Unternehmens-IT

enreach Kommunikationslösungen

UNTERSTÜTZUNG VON UNTERNEHMEN:

Security Awareness

Custom bots

Supportmitarbeiter-Workshop

Windows 10

15. – 16. August Hamburg

flex.unitMS-Excel – Der Refresher

79 €

IT-Consulting

Sabine Pleger

IT-Training

Harald Radtke

Skillfactory

Eva Pleger

Webdesign

Uli Himstedt

News & Trends

Aktuelle Artikel:

Neues von uns sofort in Ihre Mailbox!

Unser Standort: HafenCity Hamburg

Unternehmen

Rechtliches

Hier finden Sie uns

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

23 ausgeführte Abfragen 37.68 ms

22 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:

Andere Tabellen:

Kompetenzleasing

15. – 16. August
Hamburg

flex.unit
MS-Excel – Der Refresher

Neues von uns
sofort in Ihre Mailbox!

Unser Standort:
HafenCity Hamburg