Entwicklung von Lösungen

view rawproduct.js hoste

Wir lieben es neues zu schaffen. Deine Idee, deine Erfahrungen, unsere Fähigkeiten, unserer Erfahrungen. Beste Voraussetzungen unser gemeinsames Projekt anzugehen. — Anton

Wir lieben es neues zu schaffen!

Deine Idee, deine Erfahrungen, unsere Fähigkeiten, unserer Erfahrungen. Beste Voraussetzungen unser gemeinsames Projekt anzugehen.

Manchmal reicht Standard, keine Frage. Doch manchmal muss etwas Neues her, denn deine Idee ist zu innovativ als dass wir das mit einer Standardlösung abdecken könnten. Und wir lieben es Herausforderungen anzugehen, innovative Ideen und neu gedachte Konzepte technisch umzusetzen, wir lieben es Neues zu schaffen. Hierfür sind wir dank unserer weitreichenden Erfahrungen, Fähigkeiten, aber vor allem echter Abenteuerlust, bereit, mit dir eine neue Geschichte zu schreiben.

Lösung für deine E-Commerce-Geschäftsidee

Du hast eine Idee für ein neues Geschäft im Internet? Du hast ein Konzept für ein E-Commerce-Projekt entwickelt? Sehr gut! Der erste Schritt ist getan. Nun brauchst du einen kompetenten Partner für die Umsetzung! Optimal, der zweite Schritt aus auch getan. Und jetzt sollten wir uns dringend treffen und gemeinsam das Konzept final ausarbeiten, und ein geiles Projekt starten!

Anbindung und Datenaustausch

Neben innovativen neuen Projekten ist die Optimierung von Datenhaltung, Verknüpfung von Systemen oder Automatisierung von Prozesses ein extrem wichtiges Thema in der E-Commerce-Welt. Datenschupsen lieben wir. Systeme zu analysieren um zu schauen, wie wir sie verheiraten können, ist unsere Leidenschaft. Prozesse zu beschleunigen oder sogar zu automatisieren, ist immer wieder eine mächtige Aufgabe und oft ein spannendes Abenteuer auf das wir uns gemeinsam mit dir stürzen wollen.

Egal was - red bitte mit uns drüber

Egal an welcher Idee du baust, welche Problemstellung du zu lösen suchst: Lass uns drüber reden. Wir lieben das Internet, den E-Commerce, die Herausforderungen, und die Vielfalt die unser Job mit sich bringt. Wie du hoffentlich gemerkt hast – wir brennen für unseren Job und daher melde dich einfach immer mit jeder noch so abgefahrenen Idee die du hast und wir reden darüber und schauen, ob wir gemeinsam etwas draus machen können.

SELECT a.*
FROM #__zoo_item AS a
WHERE (a.id IN (38,52,139,43,42,44,51,48,46,50,45,47,53,49,41,54))
AND a.access IN (1,5)
AND (a.publish_up = '0000-00-00 00:00:00'
OR a.publish_up <= '2023-09-29 00:53:44')
AND (a.publish_down = '0000-00-00 00:00:00'
OR a.publish_down >= '2023-09-29 00:53:44')

ORDER BY R
AND()

Total Items: 16

Fragen und Antworten

Du suchst ein spezielles Thema

Wähle und erfahre mehr.

Kontakt

Direkt deinen Berater Marc kontaktieren:

Ich bin für dich da.

Anrufen Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1695949224,
                "last": 1695949224,
                "now": 1695949224
            },
            "token": "Yfd6HCmAtYZ7dAj7ydhmZjmONKSxHksz"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_zoo": {
            "zootrack": {
                "items": {
                    "current": "49"
                },
                "categories": {
                    "current": null
                }
            }
        }
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 2.10 ms / 2.10 ms Speicher: 0.418 MB / 0.74 MB Application: afterLoad

Zeit: 68.08 ms / 70.17 ms Speicher: 1.786 MB / 2.53 MB Application: afterInitialise

Zeit: 4.57 ms / 74.74 ms Speicher: 0.364 MB / 2.89 MB Application: Before Access::preloadComponents (all components)

Zeit: 1.22 ms / 75.97 ms Speicher: 0.067 MB / 2.96 MB Application: After Access::preloadComponents (all components)

Zeit: 0.04 ms / 76.01 ms Speicher: -0.002 MB / 2.96 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Zeit: 0.26 ms / 76.26 ms Speicher: 0.017 MB / 2.97 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Zeit: 10.85 ms / 87.12 ms Speicher: 0.722 MB / 3.70 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Zeit: 0.06 ms / 87.18 ms Speicher: 0.007 MB / 3.70 MB Application: After Access::getAssetRules (id:1 name:root.1)

Zeit: 6.08 ms / 93.25 ms Speicher: 0.225 MB / 3.93 MB Application: afterRoute

Zeit: 0.26 ms / 93.52 ms Speicher: 0.012 MB / 3.94 MB Application: beforeRenderComponent com_zoo

Zeit: 3.39 ms / 96.91 ms Speicher: 0.191 MB / 4.13 MB Application: Before Access::preloadPermissions (com_zoo)

Zeit: 0.94 ms / 97.85 ms Speicher: 0.034 MB / 4.16 MB Application: After Access::preloadPermissions (com_zoo)

Zeit: 2.07 ms / 99.92 ms Speicher: 0.055 MB / 4.22 MB Application: Before Access::getAssetRules (id:58 name:com_zoo)

Zeit: 0.02 ms / 99.94 ms Speicher: 0.002 MB / 4.22 MB Application: After Access::getAssetRules (id:58 name:com_zoo)

Zeit: 6.38 ms / 106.32 ms Speicher: 0.384 MB / 4.60 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Zeit: 0.03 ms / 106.35 ms Speicher: 0.002 MB / 4.61 MB Application: After Access::getAssetRules (id:1 name:root.1)

Zeit: 30.28 ms / 136.63 ms Speicher: 0.336 MB / 4.94 MB Application: afterRenderComponent com_zoo

Zeit: 0.99 ms / 137.62 ms Speicher: 0.010 MB / 4.95 MB Application: afterDispatch

Zeit: 37.24 ms / 174.86 ms Speicher: 1.561 MB / 6.51 MB Application: afterRender

Datenbankabfragen gesamt: 52.62 ms

Speichernutzung

Datenbankabfragen

34 ausgeführte Abfragen 52.62 ms

13 Duplikate gefunden!

2 Duplikate: #14 #15

8 Duplikate: #16 #24 #26 #28 #29 #30 #31 #33

3 Duplikate: #25 #27 #32

Abfragezeit: 0.66 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.029 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `aqyx1_session`

  WHERE `session_id` = X'3863343861616436616166616535393031623966643938343865643435613635'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aqyx1_session	const	PRIMARY	PRIMARY	194	const	1

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Derselbe Aufruf in der Zeile darunter.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Abfragezeit: 0.47 ms Nach letzter Abfrage: 0.93 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.043 MB Zeilen zurückgegeben: 0

SELECT `session_id`

  FROM `aqyx1_session`

  WHERE `session_id` = X'3863343861616436616166616535393031623966643938343865643435613635' 
  LIMIT 1

Explain

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

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.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 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.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

#	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

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

Abfragezeit: 20.80 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 1.048 MB

INSERT INTO `aqyx1_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3863343861616436616166616535393031623966643938343865643435613635', 1, 1695949224, 0, '', 0)

Explain

„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `aqyx1_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3863343861616436616166616535393031623966643938343865643435613635', 1, 1695949224, 0, '', 0)

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init for update	0.03 ms
Update	0.08 ms
Waiting for query cache lock	0.01 ms
Update	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	20.17 ms
closing tables	0.05 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.15 ms
Reset for next command	0.01 ms

Call Stack

#	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

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

Abfragezeit: 5.21 ms Nach letzter Abfrage: 2.27 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.188 MB Zeilen zurückgegeben: 5

SELECT id, rules

  FROM `aqyx1_viewlevels`

Explain

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

Profil (Profile)

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

Call Stack

#	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

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

Abfragezeit: 0.89 ms Nach letzter Abfrage: 0.44 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.200 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM aqyx1_usergroups AS a

  LEFT JOIN aqyx1_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	2	Using where; Using index

Profil (Profile)

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

Call Stack

#	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

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

Abfragezeit: 1.04 ms Nach letzter Abfrage: 26.80 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.443 MB Zeilen zurückgegeben: 1

SELECT id,template 
  FROM aqyx1_template_styles 
  WHERE client_id=0 
  AND home=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aqyx1_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	3	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
16	plgSystemWidgetkit_zoo->{closure}()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240
15	YOOtheme\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
14	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Derselbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
12	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149
11	YOOtheme\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:91
10	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
9	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit_zoo/widgetkit_zoo.php:9
8	plgSystemWidgetkit_zoo->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

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

Abfragezeit: 0.99 ms Nach letzter Abfrage: 4.39 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.874 MB Zeilen zurückgegeben: 1

SELECT id 
  FROM aqyx1_zoo_item 
  WHERE alias = 'entwicklung-von-loesungen' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aqyx1_zoo_item	const	ALIAS_INDEX	ALIAS_INDEX	767	const	1

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:89
14	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/helpers/alias.php:121
13	AppAlias->translateAliasToID()	JROOT/plugins/system/zooseo/zooseo.php:430
12	plgSystemZooSeo->sefParseRoute()	JROOT/administrator/components/com_zoo/framework/classes/event.php:279
11	AppEventDispatcher->notify()	JROOT/components/com_zoo/router.php:382
10	ZooParseRoute()	JROOT/components/com_zoo/router.php:35
9	ZooRouter->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

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

Abfragezeit: 0.33 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.885 MB Zeilen zurückgegeben: 0

SELECT id 
  FROM aqyx1_zoo_category 
  WHERE alias = 'entwicklung-von-loesungen' 
  LIMIT 1

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.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:89
14	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/helpers/alias.php:121
13	AppAlias->translateAliasToID()	JROOT/plugins/system/zooseo/zooseo.php:431
12	plgSystemZooSeo->sefParseRoute()	JROOT/administrator/components/com_zoo/framework/classes/event.php:279
11	AppEventDispatcher->notify()	JROOT/components/com_zoo/router.php:382
10	ZooParseRoute()	JROOT/components/com_zoo/router.php:35
9	ZooRouter->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

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

Abfragezeit: 0.98 ms Nach letzter Abfrage: 0.51 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 2.900 MB Zeilen zurückgegeben: 42

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `aqyx1_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_flexforms','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_regularlabsmanager','com_search','com_tags','com_templates','com_users','com_widgetkit','com_wrapper','com_zoo')

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:95
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:192
8	RegularLabs\Library\SystemPlugin->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

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

Abfragezeit: 4.16 ms Nach letzter Abfrage: 1.51 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 3.044 MB

UPDATE `aqyx1_extensions`

  SET `params` = '{\"mediaversion\":\"3c0260a9a644a2b4556228a60fad57a5\"}'

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

Explain

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

Profil (Profile)

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.14 ms
Updating	0.09 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	3.59 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/zooseo/zooseo.php:545
9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:96
8	plgSystemZooSeo->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

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

Abfragezeit: 0.42 ms Nach letzter Abfrage: 14.57 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 4.088 MB

UPDATE aqyx1_zoo_item 
  SET hits = (hits + 1) 
  WHERE id = 49

Explain

„EXPLAIN“ unmöglich für Abfrage: UPDATE aqyx1_zoo_item SET hits = (hits + 1) WHERE id = 49

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:66
13	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:178
12	ItemTable->hit()	JROOT/administrator/components/com_zoo/classes/item.php:684
11	Item->hit()	JROOT/components/com_zoo/controllers/default.php:177
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 0.81 ms Nach letzter Abfrage: 0.47 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 4.133 MB Zeilen zurückgegeben: 27

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `aqyx1_assets`

  WHERE `name` LIKE 'com_zoo.%' OR `name` = 'com_zoo' OR `parent_id` = 0

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
22	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
21	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
20	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
19	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
18	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:461
17	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:363
16	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:293
15	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:260
14	Item->canEdit()	JROOT/media/zoo/applications/blog/templates/service/item.php:17
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 1.11 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 4.194 MB Zeilen zurückgegeben: 8

SHOW FULL COLUMNS 
  FROM `aqyx1_assets`

Explain

„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `aqyx1_assets`

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
24	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
23	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
22	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
21	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
20	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
19	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
18	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:461
17	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:363
16	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:293
15	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:260
14	Item->canEdit()	JROOT/media/zoo/applications/blog/templates/service/item.php:17
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

[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: 0.24 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 4.219 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #15

SELECT *

  FROM aqyx1_assets

  WHERE `name` = 'com_zoo.application.2.service'

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.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init for update	0.06 ms
Updating	0.11 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.00 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.01 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
22	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
21	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
20	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
19	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
18	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:461
17	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:363
16	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:293
15	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:260
14	Item->canEdit()	JROOT/media/zoo/applications/blog/templates/service/item.php:17
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 0.34 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 4.232 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #14

SELECT *

  FROM aqyx1_assets

  WHERE `name` = 'com_zoo.application.2.service'

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.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.11 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.24 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.03 ms
closing tables	0.01 ms
Starting cleanup	0.05 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	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/administrator/components/com_zoo/framework/helpers/user.php:461
16	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:293
15	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:260
14	Item->canEdit()	JROOT/media/zoo/applications/blog/templates/service/item.php:17
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 0.34 ms Nach letzter Abfrage: 2.04 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 4.475 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #24 #26 #28 #29 #30 #31 #33

SELECT *

  FROM aqyx1_usergroups

  WHERE id = 0

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.03 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.49 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
checking permissions	0.10 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.15 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
28	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/UserGroupsHelper.php:233
27	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:137
26	Joomla\CMS\Helper\UserGroupsHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:494
25	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:297
24	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:273
23	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:223
22	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
21	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:253
20	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
19	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:41
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 0.34 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.489 MB Zeilen zurückgegeben: 1

SELECT id 
  FROM aqyx1_users 
  WHERE id = 488

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
28	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:89
27	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:47
26	UserAppHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:497
25	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:297
24	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:273
23	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:223
22	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
21	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:253
20	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
19	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:41
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 1.00 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 4.508 MB Zeilen zurückgegeben: 17

SHOW FULL COLUMNS 
  FROM `aqyx1_users`

Explain

„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `aqyx1_users`

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
38	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
37	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
36	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
35	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
34	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
33	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
32	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
31	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
30	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
29	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
28	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
27	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
26	UserAppHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:497
25	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:297
24	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:273
23	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:223
22	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
21	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:253
20	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
19	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:41
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 0.41 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 4.555 MB Zeilen zurückgegeben: 1

SELECT *

  FROM `aqyx1_users`

  WHERE `id` = 488

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aqyx1_users	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
33	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
32	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
31	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
30	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
29	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
28	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
27	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
26	UserAppHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:497
25	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:297
24	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:273
23	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:223
22	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
21	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:253
20	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
19	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:41
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 0.44 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 4.574 MB Zeilen zurückgegeben: 1

SELECT `g`.`id`,`g`.`title`

  FROM `aqyx1_usergroups` AS g

  INNER JOIN `aqyx1_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 488

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	dediviygs_db5.m.group_id	1

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
32	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
31	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
30	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
29	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
28	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
27	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
26	UserAppHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:497
25	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:297
24	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:273
23	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:223
22	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
21	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:253
20	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
19	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:41
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 0.51 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.590 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM aqyx1_user_usergroup_map AS map

  LEFT JOIN aqyx1_usergroups AS a 
  ON a.id = map.group_id

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

  WHERE map.user_id = 488

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	map	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	dediviygs_db5.map.group_id	1
1	SIMPLE	b	ALL	idx_usergroup_nested_set_lookup	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	9	Range checked for each record (index map: 0x10)

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
30	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/User/User.php:480
29	Joomla\CMS\User\User->getAuthorisedGroups()	JROOT/libraries/src/User/User.php:386
28	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:225
27	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:57
26	UserAppHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:497
25	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:297
24	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:273
23	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:223
22	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
21	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:253
20	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
19	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:41
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 0.34 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 4.605 MB Zeilen zurückgegeben: 1

SELECT *

  FROM aqyx1_usergroups

  WHERE id = 8

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aqyx1_usergroups	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
28	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/UserGroupsHelper.php:233
27	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:137
26	Joomla\CMS\Helper\UserGroupsHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:506
25	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:297
24	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:273
23	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:223
22	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
21	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:253
20	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
19	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:41
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

[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.12 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.621 MB Zeilen zurückgegeben: 1

SELECT *

  FROM aqyx1_usergroups

  WHERE id = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aqyx1_usergroups	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
30	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/UserGroupsHelper.php:233
29	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:314
28	Joomla\CMS\Helper\UserGroupsHelper->populateGroupData()	JROOT/libraries/src/Helper/UserGroupsHelper.php:240
27	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:137
26	Joomla\CMS\Helper\UserGroupsHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:506
25	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:297
24	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:273
23	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:223
22	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
21	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:253
20	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
19	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:41
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

[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: 0.66 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 4.638 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #16 #26 #28 #29 #30 #31 #33

SELECT *

  FROM aqyx1_usergroups

  WHERE id = 0

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.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.04 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.30 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
29	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/UserGroupsHelper.php:233
28	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:137
27	Joomla\CMS\Helper\UserGroupsHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:494
26	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:297
25	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:273
24	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:259
23	ElementFilesPro->getFiles()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:133
22	ElementImagePro->_render()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
21	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:253
20	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
19	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:41
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 0.89 ms Nach letzter Abfrage: 5.12 ms Abfragespeichernutzung: 0.155 MB Speichernutzung vor Abfrage: 4.811 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #27 #32

SELECT *

  FROM aqyx1_erecht24api_data

  WHERE `extension_id` = '10204' 
  AND `data_key` = 'legaltext_params'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aqyx1_erecht24api_data	ref	extension_id_data_key	extension_id_data_key	771	const,const	1	Using index condition

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
31	JDatabaseDriver->loadObject()	JROOT/libraries/erecht24/Api/Erecht24Api.php:109
30	Erecht24\Api\Erecht24Api->getApiDataSet()	JROOT/plugins/system/erecht24ids/helpers/helper.php:177
29	Erecht24idsHelper->getParamsFromApiData()	JROOT/plugins/system/erecht24ids/erecht24ids.php:154
28	PlgSystemErecht24ids->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
27	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
26	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
25	JHtmlContent::prepare()	Derselbe Aufruf in der Zeile darunter.
24	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
23	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
22	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_zoo/helpers/html.php:69
21	HTMLHelper->_()	JROOT/administrator/components/com_zoo/helpers/zoo.php:191
20	ZooHelper->triggerContentPlugins()	JROOT/media/zoolanders/elements/textareapro/textareapro.php:117
19	ElementTextareaPro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:55
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 0.99 ms Nach letzter Abfrage: 4.59 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 4.836 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #16 #24 #28 #29 #30 #31 #33

SELECT *

  FROM aqyx1_usergroups

  WHERE id = 0

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.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.02 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.05 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.04 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
28	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/UserGroupsHelper.php:233
27	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:137
26	Joomla\CMS\Helper\UserGroupsHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:494
25	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:297
24	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:273
23	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:223
22	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
21	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:253
20	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
19	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:95
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 1.00 ms Nach letzter Abfrage: 2.20 ms Abfragespeichernutzung: 0.155 MB Speichernutzung vor Abfrage: 4.859 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #25 #32

SELECT *

  FROM aqyx1_erecht24api_data

  WHERE `extension_id` = '10204' 
  AND `data_key` = 'legaltext_params'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aqyx1_erecht24api_data	ref	extension_id_data_key	extension_id_data_key	771	const,const	1	Using index condition

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.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 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.01 ms
Updating status	0.07 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
31	JDatabaseDriver->loadObject()	JROOT/libraries/erecht24/Api/Erecht24Api.php:109
30	Erecht24\Api\Erecht24Api->getApiDataSet()	JROOT/plugins/system/erecht24ids/helpers/helper.php:177
29	Erecht24idsHelper->getParamsFromApiData()	JROOT/plugins/system/erecht24ids/erecht24ids.php:154
28	PlgSystemErecht24ids->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
27	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
26	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
25	JHtmlContent::prepare()	Derselbe Aufruf in der Zeile darunter.
24	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
23	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
22	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_zoo/helpers/html.php:69
21	HTMLHelper->_()	JROOT/administrator/components/com_zoo/helpers/zoo.php:191
20	ZooHelper->triggerContentPlugins()	JROOT/media/zoolanders/elements/textareapro/textareapro.php:117
19	ElementTextareaPro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:105
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 0.53 ms Nach letzter Abfrage: 1.10 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 4.869 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #16 #24 #26 #29 #30 #31 #33

SELECT *

  FROM aqyx1_usergroups

  WHERE id = 0

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.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.40 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
28	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/UserGroupsHelper.php:233
27	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:137
26	Joomla\CMS\Helper\UserGroupsHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:494
25	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:297
24	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:273
23	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:223
22	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
21	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:253
20	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
19	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:110
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

[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: 1.64 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 4.889 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #16 #24 #26 #28 #30 #31 #33

SELECT *

  FROM aqyx1_usergroups

  WHERE id = 0

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.26 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.01 ms
Executing	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.09 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.10 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
28	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/UserGroupsHelper.php:233
27	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:137
26	Joomla\CMS\Helper\UserGroupsHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:494
25	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:297
24	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:273
23	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:223
22	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
21	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:253
20	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
19	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:123
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 0.82 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 4.903 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #16 #24 #26 #28 #29 #31 #33

SELECT *

  FROM aqyx1_usergroups

  WHERE id = 0

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.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.36 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.06 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
28	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/UserGroupsHelper.php:233
27	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:137
26	Joomla\CMS\Helper\UserGroupsHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:494
25	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:297
24	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:273
23	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:223
22	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
21	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:253
20	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
19	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:129
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 0.61 ms Nach letzter Abfrage: 2.55 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 4.927 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #16 #24 #26 #28 #29 #30 #33

SELECT *

  FROM aqyx1_usergroups

  WHERE id = 0

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.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.04 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
28	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/UserGroupsHelper.php:233
27	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:137
26	Joomla\CMS\Helper\UserGroupsHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:494
25	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:297
24	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:273
23	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:223
22	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
21	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:253
20	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
19	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:151
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 1.24 ms Nach letzter Abfrage: 2.07 ms Abfragespeichernutzung: 0.155 MB Speichernutzung vor Abfrage: 4.951 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #25 #27

SELECT *

  FROM aqyx1_erecht24api_data

  WHERE `extension_id` = '10204' 
  AND `data_key` = 'legaltext_params'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aqyx1_erecht24api_data	ref	extension_id_data_key	extension_id_data_key	771	const,const	1	Using index condition

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
31	JDatabaseDriver->loadObject()	JROOT/libraries/erecht24/Api/Erecht24Api.php:109
30	Erecht24\Api\Erecht24Api->getApiDataSet()	JROOT/plugins/system/erecht24ids/helpers/helper.php:177
29	Erecht24idsHelper->getParamsFromApiData()	JROOT/plugins/system/erecht24ids/erecht24ids.php:154
28	PlgSystemErecht24ids->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
27	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
26	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
25	JHtmlContent::prepare()	Derselbe Aufruf in der Zeile darunter.
24	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
23	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
22	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_zoo/helpers/html.php:69
21	HTMLHelper->_()	JROOT/administrator/components/com_zoo/helpers/zoo.php:191
20	ZooHelper->triggerContentPlugins()	JROOT/media/zoolanders/elements/textareapro/textareapro.php:117
19	ElementTextareaPro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:161
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 0.67 ms Nach letzter Abfrage: 1.09 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.968 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #16 #24 #26 #28 #29 #30 #31

SELECT *

  FROM aqyx1_usergroups

  WHERE id = 0

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.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.01 ms
Executing	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.07 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.10 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
28	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/UserGroupsHelper.php:233
27	Joomla\CMS\Helper\UserGroupsHelper->load()	JROOT/libraries/src/Helper/UserGroupsHelper.php:137
26	Joomla\CMS\Helper\UserGroupsHelper->get()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:494
25	ElementFilesPro->replaceVars()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:297
24	ElementFilesPro->getDefaultSource()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:273
23	ElementFilesPro->getValidResources()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:223
22	ElementFilesPro->_hasValue()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:221
21	ElementRepeatablePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:253
20	ElementFilesPro->getRenderedValues()	JROOT/media/zoolanders/elements/imagepro/imagepro.php:84
19	ElementImagePro->getRenderedValues()	JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:85
18	ElementRepeatablePro->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php:166
16	include JROOT/media/zoo/applications/blog/templates/service/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:157
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/service/item.php:28
13	include JROOT/media/zoo/applications/blog/templates/service/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:210
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:266
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:298
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:35
6	require_once JROOT/components/com_zoo/zoo.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

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

Abfragezeit: 2.68 ms Nach letzter Abfrage: 3.92 ms Abfragespeichernutzung: 0.128 MB Speichernutzung vor Abfrage: 5.199 MB Zeilen zurückgegeben: 25

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM aqyx1_modules AS m

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

  LEFT JOIN aqyx1_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1,5) 
  AND m.client_id = 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	published,newsfeeds	published	1	const	28	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	dediviygs_db5.m.id	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	dediviygs_db5.m.module,const	1	Using index condition; Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:318
18	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
17	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yoo_master2/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/yoo_master2/styles/wirduzen/layouts/theme.config.php:26
10	include JROOT/templates/yoo_master2/styles/wirduzen/layouts/theme.config.php	JROOT/templates/yoo_master2/styles/wirduzen/layouts/theme.php:10
9	include JROOT/templates/yoo_master2/styles/wirduzen/layouts/theme.php	JROOT/templates/yoo_master2/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_master2/index.php:16
7	require JROOT/templates/yoo_master2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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

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

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

SELECT-Tabellen:

10 × SELECT * 
  FROM aqyx1_usergroups

3 × SELECT * 
  FROM aqyx1_erecht24api_data

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `aqyx1_assets`

```
2 × SELECT * 
  FROM aqyx1_assets
```

1 × SELECT `data` 
  FROM `aqyx1_session`

1 × SELECT `session_id` 
  FROM `aqyx1_session`

1 × SELECT id, rules 
  FROM `aqyx1_viewlevels

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

1 × SELECT id,template 
  FROM aqyx1_template_styles

```
1 × SELECT id 
  FROM aqyx1_zoo_item
```

1 × SELECT id 
  FROM aqyx1_zoo_category

```
1 × SELECT id 
  FROM aqyx1_users
```
```
1 × SELECT * 
  FROM `aqyx1_users`
```

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `aqyx1_usergroups` AS g 
  INNER JOIN `aqyx1_user_usergroup_map` AS m 
  ON m.group_id = g.id

1 × SELECT b.id 
  FROM aqyx1_user_usergroup_map AS map 
  LEFT JOIN aqyx1_usergroups AS a 
  ON a.id = map.group_id 
  LEFT JOIN aqyx1_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
  FROM aqyx1_modules AS m 
  LEFT JOIN aqyx1_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN aqyx1_advancedmodules as am 
  ON am.moduleid = m.id

Andere Tabellen:

1 × INSERT INTO `aqyx1_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3863343861616436616166616535393031623966643938343865643435613635', 1, 1695949224, 0, '', 0

1 × UPDATE `aqyx1_extensions` 
  SET `params` = '{\"mediaversion\":\"3c0260a9a644a2b4556228a60fad57a5\"}'

1 × UPDATE aqyx1_zoo_item 
  SET hits = (hits + 1)

1 × SHOW FULL COLUMNS 
  FROM `aqyx1_assets

1 × SHOW FULL COLUMNS 
  FROM `aqyx1_users