Webmaster

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1784741734,
                "last": 1784741734,
                "now": 1784741734
            },
            "token": "Ot4wrdpZQHLJPS1F5bD3yAO47F0PQJL4"
        },
        "registry": {
            "cmobile": {
                "ismobile": false,
                "isdevice": false,
                "device": "{}",
                "detection": {
                    "system": false
                }
            },
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly9zZ2ktZ3J1ZW50YWwtZnJ1dGVuaG9mLmRlL2tvbnRha3Qvd2VibWFzdGVyLmh0bWw%2F"
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 41.16 ms / 41.16 ms Speicher: 0.409 MB / 0.79 MB Application: afterLoad

Zeit: 133.10 ms / 174.26 ms Speicher: 0.925 MB / 1.72 MB Application: afterInitialise

Zeit: 43.28 ms / 217.55 ms Speicher: 0.345 MB / 2.06 MB Application: afterRoute

Zeit: 15.73 ms / 233.28 ms Speicher: 0.207 MB / 2.27 MB Application: beforeRenderComponent com_contact

Zeit: 23.28 ms / 256.55 ms Speicher: 0.229 MB / 2.50 MB Application: Before Access::preloadComponents (all components)

Zeit: 3.51 ms / 260.06 ms Speicher: 0.058 MB / 2.56 MB Application: After Access::preloadComponents (all components)

Zeit: 0.12 ms / 260.19 ms Speicher: -0.002 MB / 2.55 MB Application: Before Access::getAssetRules (id:7 name:com_contact)

Zeit: 1.74 ms / 261.93 ms Speicher: 0.010 MB / 2.56 MB Application: After Access::getAssetRules (id:7 name:com_contact)

Zeit: 216.69 ms / 478.61 ms Speicher: 1.275 MB / 3.84 MB Application: afterRenderComponent com_contact

Zeit: 5.85 ms / 484.46 ms Speicher: 0.006 MB / 3.84 MB Application: afterDispatch

Zeit: 19.95 ms / 504.41 ms Speicher: 0.054 MB / 3.90 MB Application: beforeRenderModule mod_footer (Fußzeile)

Zeit: 3.37 ms / 507.78 ms Speicher: 0.007 MB / 3.91 MB Application: afterRenderModule mod_footer (Fußzeile)

Zeit: 0.06 ms / 507.84 ms Speicher: -0.002 MB / 3.90 MB Application: beforeRenderModule mod_custom (Footer-Menü2)

Zeit: 2.72 ms / 510.56 ms Speicher: 0.006 MB / 3.91 MB Application: afterRenderModule mod_custom (Footer-Menü2)

Zeit: 0.10 ms / 510.66 ms Speicher: -0.001 MB / 3.91 MB Application: beforeRenderModule mod_menu (Hauptmenü)

Zeit: 25.22 ms / 535.89 ms Speicher: 0.161 MB / 4.07 MB Application: afterRenderModule mod_menu (Hauptmenü)

Zeit: 0.11 ms / 536.00 ms Speicher: 0.009 MB / 4.08 MB Application: beforeRenderModule mod_vvisit_counter (Besucherzähler)

Zeit: 109.92 ms / 645.92 ms Speicher: 0.269 MB / 4.35 MB Application: afterRenderModule mod_vvisit_counter (Besucherzähler)

Zeit: 0.08 ms / 646.01 ms Speicher: -0.039 MB / 4.31 MB Application: beforeRenderModule mod_custom (VIP Log-In)

Zeit: 1.70 ms / 647.71 ms Speicher: 0.004 MB / 4.31 MB Application: afterRenderModule mod_custom (VIP Log-In)

Zeit: 0.12 ms / 647.82 ms Speicher: -0.001 MB / 4.31 MB Application: beforeRenderModule mod_search (Suche)

Zeit: 8.86 ms / 656.68 ms Speicher: 0.018 MB / 4.33 MB Application: afterRenderModule mod_search (Suche)

Zeit: 0.11 ms / 656.79 ms Speicher: -0.003 MB / 4.33 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 5.13 ms / 661.92 ms Speicher: 0.026 MB / 4.35 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 0.11 ms / 662.03 ms Speicher: -0.005 MB / 4.35 MB Application: beforeRenderModule mod_menu (Hauptmenü oben)

Zeit: 48.87 ms / 710.91 ms Speicher: 0.056 MB / 4.40 MB Application: afterRenderModule mod_menu (Hauptmenü oben)

Zeit: 0.16 ms / 711.06 ms Speicher: -0.002 MB / 4.40 MB Application: beforeRenderModule mod_jbcookies (JoomBall - Cookies)

Zeit: 11.19 ms / 722.25 ms Speicher: 0.063 MB / 4.46 MB Application: afterRenderModule mod_jbcookies (JoomBall - Cookies)

Zeit: 0.12 ms / 722.36 ms Speicher: -0.013 MB / 4.45 MB Application: beforeRenderModule mod_custom (Header)

Zeit: 7.65 ms / 730.02 ms Speicher: 0.011 MB / 4.46 MB Application: afterRenderModule mod_custom (Header)

Zeit: 7.56 ms / 737.58 ms Speicher: 0.124 MB / 4.59 MB Application: afterRender

Datenbankabfragen gesamt: 189.20 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	y3wtq_session	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

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

#	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:298

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

Profil (Profile)

Status	Duration
starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
update	0.17 ms
end	0.03 ms
query end	0.04 ms
closing tables	0.04 ms
freeing items	0.15 ms
cleaning up	0.11 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:298

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

Abfragezeit: 2.83 ms Nach letzter Abfrage: 8.72 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 1.123 MB Zeilen zurückgegeben: 40

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

  FROM `y3wtq_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	y3wtq_extensions	ref	extension	extension	82	const	42	100.00	Using index condition; Using where

Profil (Profile)

Status	Duration
starting	0.10 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.09 ms
statistics	0.12 ms
preparing	0.06 ms
executing	0.03 ms
Sending data	1.05 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.05 ms
cleaning up	0.06 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Derselbe Aufruf in der Zeile darunter.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:301

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

Abfragezeit: 1.59 ms Nach letzter Abfrage: 5.93 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.161 MB Zeilen zurückgegeben: 3

SELECT id, rules

  FROM `y3wtq_viewlevels`

Explain

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

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
Opening tables	0.09 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.03 ms
Sending data	0.17 ms
end	0.06 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.15 ms
cleaning up	0.04 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:301

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

Abfragezeit: 1.27 ms Nach letzter Abfrage: 0.38 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.172 MB Zeilen zurückgegeben: 1

SELECT b.id

  FROM y3wtq_usergroups AS a

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

  WHERE a.id = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	8	25.00	Using where; Using index

Profil (Profile)

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.04 ms
optimizing	0.04 ms
statistics	0.12 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.05 ms
freeing items	0.10 ms
cleaning up	0.04 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:301

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

Abfragezeit: 2.49 ms Nach letzter Abfrage: 0.98 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.193 MB Zeilen zurückgegeben: 100

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

  FROM y3wtq_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	y3wtq_extensions	ref	extension	extension	82	const	147	100.00	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.05 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	0.03 ms
Creating sort index	1.05 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Derselbe Aufruf in der Zeile darunter.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
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:301

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

Abfragezeit: 3.53 ms Nach letzter Abfrage: 70.92 ms Abfragespeichernutzung: 0.072 MB Speichernutzung vor Abfrage: 1.744 MB Zeilen zurückgegeben: 41

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

  FROM y3wtq_menu AS m

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	50	100.00	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	DB33290.m.component_id	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.22 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.23 ms
preparing	0.13 ms
Sorting result	0.03 ms
executing	0.03 ms
Sending data	0.06 ms
Creating sort index	1.34 ms
end	0.10 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.12 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Derselbe Aufruf in der Zeile darunter.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
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:301

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

Abfragezeit: 1.31 ms Nach letzter Abfrage: 34.26 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.080 MB Zeilen zurückgegeben: 1

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

  FROM `y3wtq_extensions`

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

Explain

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

Profil (Profile)

Status	Duration
starting	0.11 ms
checking permissions	0.05 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.08 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.15 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Derselbe Aufruf in der Zeile darunter.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:301

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

Abfragezeit: 1.31 ms Nach letzter Abfrage: 0.46 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.071 MB

UPDATE `y3wtq_extensions`

  SET `params` = '{\"mediaversion\":\"d900bb654ccdfb2a99395d41eef1ce55\"}'

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	y3wtq_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.12 ms
updating	0.21 ms
end	0.03 ms
query end	0.06 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:301

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

Abfragezeit: 1.39 ms Nach letzter Abfrage: 3.96 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.102 MB Zeilen zurückgegeben: 1

SELECT *

  FROM y3wtq_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.05 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	0.11 ms
Creating sort index	0.10 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:301

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

Abfragezeit: 1.44 ms Nach letzter Abfrage: 0.69 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.120 MB Zeilen zurückgegeben: 2

SELECT id, home, template, s.params

  FROM y3wtq_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	2	100.00	NULL
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	DB33290.s.template,const	1	100.00	Using index condition; Using where

Profil (Profile)

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.12 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	0.12 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.16 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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:301

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

Abfragezeit: 2.98 ms Nach letzter Abfrage: 27.47 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 2.501 MB Zeilen zurückgegeben: 40

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

  FROM `y3wtq_assets`

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

Explain

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

Profil (Profile)

Status	Duration
starting	0.15 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
init	0.12 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.27 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	1.20 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.16 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_contact/models/category.php:296
13	ContactModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_contact/views/category/view.html.php:54
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:301

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

Abfragezeit: 3.14 ms Nach letzter Abfrage: 6.95 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.562 MB Zeilen zurückgegeben: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)

  FROM `y3wtq_contact_details` AS `i`

  WHERE i.`catid` = c.id 
  AND i.published = 1) AS numitems

  FROM `y3wtq_categories` AS `s`

  INNER JOIN `y3wtq_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_contact' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 24

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	filesort wurde genutzt
1	PRIMARY	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	6	100.00	Using index condition; Using where
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	DB33290.c.id	3	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.34 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.12 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.23 ms
preparing	0.06 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	0.05 ms
Creating sort index	0.23 ms
optimizing	0.04 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.06 ms
executing	0.02 ms
Sending data	0.08 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.12 ms
cleaning up	0.04 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_contact/models/category.php:335
13	ContactModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_contact/views/category/view.html.php:54
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:301

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

Abfragezeit: 5.89 ms Nach letzter Abfrage: 1.36 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 2.575 MB Zeilen zurückgegeben: 2

SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM `y3wtq_contact_details` AS a

  LEFT JOIN y3wtq_categories AS c 
  ON c.id = a.catid

  LEFT JOIN y3wtq_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN y3wtq_users AS uam 
  ON uam.id = a.modified_by

  WHERE a.access IN (1,1) 
  AND a.catid = 24 
  AND c.access IN (1,1) 
  AND a.published = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-07-22 17:35:34') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-22 17:35:34')

  ORDER BY ordering ASC 
  LIMIT 20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; filesort wurde genutzt
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	2	100.00	Using where
1	SIMPLE	ua	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	DB33290.a.modified_by	1	100.00	Using where; Using index

Profil (Profile)

Status	Duration
starting	0.33 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
init	0.13 ms
System lock	0.03 ms
optimizing	0.07 ms
statistics	0.24 ms
preparing	0.13 ms
Creating tmp table	0.12 ms
Sorting result	0.02 ms
executing	0.08 ms
Sending data	2.71 ms
Creating sort index	0.14 ms
end	0.03 ms
removing tmp table	0.80 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.12 ms
cleaning up	0.04 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_contact/models/category.php:91
13	ContactModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_contact/views/category/view.html.php:54
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:301

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

Abfragezeit: 9.52 ms Nach letzter Abfrage: 2.54 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.602 MB Zeilen zurückgegeben: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `y3wtq_contentitem_tag_map` AS m 

  INNER JOIN `y3wtq_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_contact.contact' 
  AND `m`.`content_item_id` = 18 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	DB33290.m.tag_id	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.09 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.07 ms
System lock	0.10 ms
optimizing	0.05 ms
statistics	0.11 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	0.07 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_contact/models/category.php:107
13	ContactModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_contact/views/category/view.html.php:54
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:301

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

Abfragezeit: 3.27 ms Nach letzter Abfrage: 0.37 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 2.615 MB Zeilen zurückgegeben: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `y3wtq_contentitem_tag_map` AS m 

  INNER JOIN `y3wtq_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_contact.contact' 
  AND `m`.`content_item_id` = 1 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	DB33290.m.tag_id	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.12 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.10 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	0.09 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_contact/models/category.php:107
13	ContactModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_contact/views/category/view.html.php:54
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:301

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

Abfragezeit: 2.30 ms Nach letzter Abfrage: 2.25 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 2.630 MB Zeilen zurückgegeben: 1

SELECT COUNT(*)

  FROM `y3wtq_contact_details` AS a

  LEFT JOIN y3wtq_categories AS c 
  ON c.id = a.catid

  LEFT JOIN y3wtq_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN y3wtq_users AS uam 
  ON uam.id = a.modified_by

  WHERE a.access IN (1,1) 
  AND a.catid = 24 
  AND c.access IN (1,1) 
  AND a.published = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-07-22 17:35:34') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-22 17:35:34')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	2	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	DB33290.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	DB33290.a.modified_by	1	100.00	Using where; Using index

Profil (Profile)

Status	Duration
starting	0.17 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Opening tables	0.08 ms
init	0.14 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.48 ms
preparing	0.14 ms
executing	0.02 ms
Sending data	0.09 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.07 ms
freeing items	0.14 ms
cleaning up	0.04 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
14	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
13	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:145
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_contact/views/category/view.html.php:54
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:301

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

Abfragezeit: 2.39 ms Nach letzter Abfrage: 17.74 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 2.806 MB Zeilen zurückgegeben: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `y3wtq_categories` AS `s`

  INNER JOIN `y3wtq_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_contact' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 24

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	filesort wurde genutzt
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	6	100.00	Using index condition; Using where

Profil (Profile)

Status	Duration
starting	0.22 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.15 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.36 ms
preparing	0.10 ms
Sorting result	0.08 ms
executing	0.02 ms
Sending data	0.05 ms
Creating sort index	0.22 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.12 ms
cleaning up	0.04 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/View/CategoryView.php:179
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_contact/views/category/view.html.php:54
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:301

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

Abfragezeit: 5.46 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.823 MB Zeilen zurückgegeben: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM y3wtq_fields AS a

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

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

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

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

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

  LEFT JOIN `y3wtq_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_contact.contact' 
  AND (fc.category_id IS NULL OR fc.category_id IN (24,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profil (Profile)

Status	Duration
starting	0.21 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.11 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.26 ms
preparing	0.08 ms
Creating tmp table	0.10 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	2.69 ms
Creating sort index	0.07 ms
end	0.02 ms
removing tmp table	0.77 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.12 ms
cleaning up	0.04 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/View/CategoryView.php:179
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_contact/views/category/view.html.php:54
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:301

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

Abfragezeit: 1.64 ms Nach letzter Abfrage: 79.04 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.891 MB Zeilen zurückgegeben: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `y3wtq_contentitem_tag_map` AS m 

  INNER JOIN `y3wtq_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_contact.category' 
  AND `m`.`content_item_id` = 24 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	DB33290.m.tag_id	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.07 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.12 ms
preparing	0.05 ms
executing	0.03 ms
Sending data	0.18 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_contact/views/category/view.html.php:54
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:301

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

Abfragezeit: 5.29 ms Nach letzter Abfrage: 25.86 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 3.830 MB Zeilen zurückgegeben: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM y3wtq_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_contact.categories' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profil (Profile)

Status	Duration
starting	0.23 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.10 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.21 ms
preparing	0.07 ms
Creating tmp table	0.10 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	2.53 ms
Creating sort index	0.08 ms
end	0.02 ms
removing tmp table	0.72 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.11 ms
cleaning up	0.05 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
23	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
22	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
21	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
20	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:25
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
16	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_contact/views/category/tmpl/default.php:13
14	include JROOT/components/com_contact/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_contact/views/category/view.html.php:83
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:301

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

Abfragezeit: 5.04 ms Nach letzter Abfrage: 1.52 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 3.845 MB Zeilen zurückgegeben: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM y3wtq_fields AS a

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

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

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

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

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

  LEFT JOIN `y3wtq_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_contact.categories' 
  AND (fc.category_id IS NULL OR fc.category_id IN (24,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profil (Profile)

Status	Duration
starting	0.18 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.10 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.24 ms
preparing	0.11 ms
Creating tmp table	0.12 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	2.24 ms
Creating sort index	0.07 ms
end	0.02 ms
removing tmp table	0.65 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.49 ms
cleaning up	0.09 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
24	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
21	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:324
20	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:28
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
16	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_contact/views/category/tmpl/default.php:13
14	include JROOT/components/com_contact/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_contact/views/category/view.html.php:83
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:301

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

Abfragezeit: 5.48 ms Nach letzter Abfrage: 12.62 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 3.868 MB Zeilen zurückgegeben: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM y3wtq_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_contact.category.title' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profil (Profile)

Status	Duration
starting	0.17 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.10 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.10 ms
System lock	0.04 ms
optimizing	0.05 ms
statistics	0.27 ms
preparing	0.09 ms
Creating tmp table	0.11 ms
Sorting result	0.06 ms
executing	0.02 ms
Sending data	2.34 ms
Creating sort index	0.14 ms
end	0.03 ms
removing tmp table	0.84 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.14 ms
cleaning up	0.04 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
28	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
27	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
26	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
25	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
24	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
21	JHtmlContent::prepare()	Derselbe Aufruf in der Zeile darunter.
20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/layouts/joomla/content/category_default.php:57
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
16	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_contact/views/category/tmpl/default.php:13
14	include JROOT/components/com_contact/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_contact/views/category/view.html.php:83
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:301

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

Abfragezeit: 5.88 ms Nach letzter Abfrage: 3.52 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 3.883 MB Zeilen zurückgegeben: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM y3wtq_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_contact.category.description' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profil (Profile)

Status	Duration
starting	0.17 ms
checking permissions	0.02 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.11 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.25 ms
preparing	0.09 ms
Creating tmp table	0.16 ms
Sorting result	0.02 ms
executing	0.09 ms
Sending data	2.92 ms
Creating sort index	0.07 ms
end	0.02 ms
removing tmp table	0.77 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.11 ms
cleaning up	0.04 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
28	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
27	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
26	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
25	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
24	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
21	JHtmlContent::prepare()	Derselbe Aufruf in der Zeile darunter.
20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/layouts/joomla/content/category_default.php:73
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
16	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_contact/views/category/tmpl/default.php:13
14	include JROOT/components/com_contact/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_contact/views/category/view.html.php:83
10	ContactViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:301

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

Abfragezeit: 2.57 ms Nach letzter Abfrage: 21.80 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 3.886 MB Zeilen zurückgegeben: 10

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

  FROM y3wtq_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-07-22 17:35:34') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-22 17:35:34') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 220 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profil (Profile)

Status	Duration
starting	0.16 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.09 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.18 ms
preparing	0.07 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.88 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Derselbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/lessallrounder/index.php:57
7	require JROOT/templates/lessallrounder/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:301

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

Abfragezeit: 1.06 ms Nach letzter Abfrage: 50.72 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.257 MB Zeilen zurückgegeben: 1

SELECT count( * ) AS records, MAX( id ) AS max 
  FROM y3wtq_vvisitcounter

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	Select tables optimized away

Profil (Profile)

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.04 ms
executing	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.07 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
14	JDatabaseDriver->loadRow()	JROOT/modules/mod_vvisit_counter/helper.php:1417
13	modVisitCounterHelper->init()	JROOT/modules/mod_vvisit_counter/helper.php:482
12	modVisitCounterHelper->__construct()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:301

[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.26 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 4.265 MB

CREATE TABLE IF NOT EXISTS y3wtq_mod_vvisit_counter_memo (counter varchar(240) NOT NULL, lastMaxPerDay DATE NULL DEFAULT NULL ,  valMaxVisits INT NULL DEFAULT NULL, valMaxVisitsDay int NULL DEFAULT NULL, lastMaxVisits DATETIME NULL , PRIMARY KEY (counter) ) ENGINE=MEMORY

Explain

„EXPLAIN“ unmöglich für Abfrage: CREATE TABLE IF NOT EXISTS y3wtq_mod_vvisit_counter_memo (counter varchar(240) NOT NULL, lastMaxPerDay DATE NULL DEFAULT NULL , valMaxVisits INT NULL DEFAULT NULL, valMaxVisitsDay int NULL DEFAULT NULL, lastMaxVisits DATETIME NULL , PRIMARY KEY (counter) ) ENGINE=MEMORY

Profil (Profile)

Status	Duration
starting	0.11 ms
checking permissions	0.03 ms
Opening tables	0.12 ms
After create	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
14	JDatabase->query()	JROOT/modules/mod_vvisit_counter/helper.php:1449
13	modVisitCounterHelper->init()	JROOT/modules/mod_vvisit_counter/helper.php:482
12	modVisitCounterHelper->__construct()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:301

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

Abfragezeit: 0.97 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 4.272 MB

INSERT INTO y3wtq_mod_vvisit_counter_memo ( counter ) 
  values ( 'vvisitcounter' ) 
  ON DUPLICATE KEY UPDATE counter='vvisitcounter'

Explain

„EXPLAIN“ unmöglich für Abfrage: INSERT INTO y3wtq_mod_vvisit_counter_memo ( counter ) values ( 'vvisitcounter' ) ON DUPLICATE KEY UPDATE counter='vvisitcounter'

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
update	0.04 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
14	JDatabase->query()	JROOT/modules/mod_vvisit_counter/helper.php:1467
13	modVisitCounterHelper->init()	JROOT/modules/mod_vvisit_counter/helper.php:482
12	modVisitCounterHelper->__construct()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:301

[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.19 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.280 MB Zeilen zurückgegeben: 1

select lastMaxPerDay, DATEDIFF( curdate(), lastMaxPerDay ) as ddiff 
  FROM y3wtq_mod_vvisit_counter_memo 
  where counter = 'vvisitcounter'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	y3wtq_mod_vvisit_counter_memo	system	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	NULL

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.06 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/modules/mod_vvisit_counter/helper.php:1480
13	modVisitCounterHelper->init()	JROOT/modules/mod_vvisit_counter/helper.php:482
12	modVisitCounterHelper->__construct()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:301

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

Abfragezeit: 0.95 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 4.287 MB

UPDATE y3wtq_mod_vvisit_counter_memo 
  set lastMaxPerDay = CURDATE() 
  WHERE counter = 'vvisitcounter'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	y3wtq_mod_vvisit_counter_memo	range	PRIMARY	PRIMARY	767	const	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.07 ms
updating	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.06 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
14	JDatabase->query()	JROOT/modules/mod_vvisit_counter/helper.php:1504
13	modVisitCounterHelper->init()	JROOT/modules/mod_vvisit_counter/helper.php:482
12	modVisitCounterHelper->__construct()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:301

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

Abfragezeit: 75.66 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 4.295 MB

DELETE 
  FROM y3wtq_vvisitcounter 
  WHERE DATE(from_unixtime(tm)) <=	( SELECT toDEL 
  FROM (   SELECT DATE_SUB(     MAX( DISTINCT DATE( from_unixtime(tm) ) ) ,      INTERVAL 51 DAY ) AS toDel    
  FROM y3wtq_vvisitcounter AS theCore ) AS workAround)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	y3wtq_vvisitcounter	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	25548	100.00	Using where
2	SUBQUERY	<derived3>	system	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	NULL
3	DERIVED	theCore	index	NULL	tm	4	NULL	25548	100.00	Using index

Profil (Profile)

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
init	0.04 ms
System lock	0.08 ms
updating	0.12 ms
optimizing	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	38.60 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	35.48 ms
end	0.05 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.08 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
14	JDatabase->query()	JROOT/modules/mod_vvisit_counter/helper.php:1528
13	modVisitCounterHelper->init()	JROOT/modules/mod_vvisit_counter/helper.php:482
12	modVisitCounterHelper->__construct()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:301

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

Abfragezeit: 1.39 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 4.309 MB Zeilen zurückgegeben: 1

SELECT COUNT(*) 
  FROM y3wtq_vvisitcounter 
  WHERE ip=UNHEX(SHA1('216.73.216.116')) 
  AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '30' )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	y3wtq_vvisitcounter	ref	ip,iptm	iptm	20	const	11	100.00	Using where; Using index

Profil (Profile)

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.07 ms
executing	0.02 ms
Sending data	0.08 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/modules/mod_vvisit_counter/helper.php:1612
13	modVisitCounterHelper->init()	JROOT/modules/mod_vvisit_counter/helper.php:482
12	modVisitCounterHelper->__construct()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:301

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

Abfragezeit: 2.38 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.317 MB Zeilen zurückgegeben: 1

SELECT COUNT(*) 
  FROM y3wtq_session 
  WHERE guest = 1 
  and client_id = 0 
  and (UNIX_TIMESTAMP(now()) - time ) <= 300

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	y3wtq_session	ref	client_id_guest	client_id_guest	4	const,const	321	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.03 ms
Sending data	1.11 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.05 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/modules/mod_vvisit_counter/helper.php:2149
14	modVisitCounterHelper->sql_guestsCount()	JROOT/modules/mod_vvisit_counter/helper.php:1825
13	modVisitCounterHelper->init()	JROOT/modules/mod_vvisit_counter/helper.php:482
12	modVisitCounterHelper->__construct()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:301

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

Abfragezeit: 1.51 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.326 MB Zeilen zurückgegeben: 1

SELECT COUNT(*) 
  FROM y3wtq_vvisitcounter 
  WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW())) 
  AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	y3wtq_vvisitcounter	range	tm	tm	4	NULL	420	100.00	Using where; Using index

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.32 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.14 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/modules/mod_vvisit_counter/helper.php:1920
13	modVisitCounterHelper->sql_today_visitors()	JROOT/modules/mod_vvisit_counter/helper.php:763
12	modVisitCounterHelper->renderPeopleTable()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:26
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:301

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

Abfragezeit: 1.51 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.334 MB Zeilen zurückgegeben: 1

SELECT COUNT(*) 
  FROM y3wtq_vvisitcounter 
  WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY)) 
  AND UNIX_TIMESTAMP(DATE(NOW()))

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	y3wtq_vvisitcounter	range	tm	tm	4	NULL	378	100.00	Using where; Using index

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.44 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.06 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/modules/mod_vvisit_counter/helper.php:1935
13	modVisitCounterHelper->sql_yesterday_visitors()	JROOT/modules/mod_vvisit_counter/helper.php:774
12	modVisitCounterHelper->renderPeopleTable()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:26
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:301

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

Abfragezeit: 1.95 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.342 MB Zeilen zurückgegeben: 1

SELECT COUNT(*) 
  FROM y3wtq_vvisitcounter 
  WHERE tm BETWEEN 1784505600 
  AND 1785110400

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	y3wtq_vvisitcounter	range	tm	tm	4	NULL	1297	100.00	Using where; Using index

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.89 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/modules/mod_vvisit_counter/helper.php:1979
13	modVisitCounterHelper->sql_week_visitors()	JROOT/modules/mod_vvisit_counter/helper.php:784
12	modVisitCounterHelper->renderPeopleTable()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:26
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:301

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

Abfragezeit: 8.93 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.350 MB Zeilen zurückgegeben: 1

SELECT COUNT(*) 
  FROM y3wtq_vvisitcounter 
  WHERE tm BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01")) 
  AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01") + INTERVAL 1 MONTH)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	y3wtq_vvisitcounter	range	tm	tm	4	NULL	12373	100.00	Using where; Using index

Profil (Profile)

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	7.68 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.05 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/modules/mod_vvisit_counter/helper.php:1994
13	modVisitCounterHelper->sql_month_visitors()	JROOT/modules/mod_vvisit_counter/helper.php:808
12	modVisitCounterHelper->renderPeopleTable()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:26
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:301

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

Abfragezeit: 1.36 ms Nach letzter Abfrage: 70.76 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.478 MB Zeilen zurückgegeben: 1

SELECT a.id, a.alias, a.catid,c.alias AS category_alias,parent.id as parent_id, parent.alias as parent_alias

  FROM y3wtq_content AS a

  LEFT JOIN y3wtq_categories AS c 
  on c.id = a.catid

  LEFT JOIN y3wtq_categories as parent 
  ON parent.id = c.parent_id

  WHERE a.id = 116

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil (Profile)

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.06 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/modules/mod_jbcookies/mod_jbcookies.php:146
10	include JROOT/modules/mod_jbcookies/mod_jbcookies.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:301

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

Abfragezeit: 2.05 ms Nach letzter Abfrage: 1.23 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 4.494 MB Zeilen zurückgegeben: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `y3wtq_categories` AS `s`

  INNER JOIN `y3wtq_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 16

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	filesort wurde genutzt
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	60	40.00	Using where

Profil (Profile)

Status	Duration
starting	0.17 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.09 ms
System lock	0.03 ms
optimizing	0.07 ms
statistics	0.19 ms
preparing	0.06 ms
Sorting result	0.02 ms
executing	0.03 ms
Sending data	0.07 ms
Creating sort index	0.35 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.04 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
22	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
21	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
20	ContentRouter->getCategorySegment()	Derselbe Aufruf in der Zeile darunter.
19	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
18	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
17	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
16	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
15	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_jbcookies/mod_jbcookies.php:161
10	include JROOT/modules/mod_jbcookies/mod_jbcookies.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:301

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

Abfragezeit: 4.99 ms Nach letzter Abfrage: 3.22 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 4.469 MB Zeilen zurückgegeben: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM y3wtq_fields AS a

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

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

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

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

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

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profil (Profile)

Status	Duration
starting	0.17 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.10 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.20 ms
preparing	0.07 ms
Creating tmp table	0.10 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	2.43 ms
Creating sort index	0.07 ms
end	0.02 ms
removing tmp table	0.71 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.05 ms
freeing items	0.11 ms
cleaning up	0.04 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Derselbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:301

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

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

SELECT-Tabellen:

5 × SELECT COUNT(*) 
  FROM y3wtq_vvisitcounter

4 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM y3wtq_fields AS a 
  LEFT JOIN `y3wtq_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN y3wtq_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN y3wtq_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN y3wtq_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN y3wtq_fields_groups AS g 
  ON g.id = a.group_id

3 × SELECT `m`.`tag_id`,`t`.* 
  FROM `y3wtq_contentitem_tag_map` AS m  
  INNER JOIN `y3wtq_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM y3wtq_fields AS a 
  LEFT JOIN `y3wtq_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN y3wtq_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN y3wtq_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN y3wtq_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN y3wtq_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `y3wtq_fields_categories` AS fc 
  ON fc.field_id = a.id

2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `y3wtq_categories` AS `s` 
  INNER JOIN `y3wtq_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT `data` 
  FROM `y3wtq_session`

1 × SELECT COUNT(*) 
  FROM y3wtq_session

1 × select lastMaxPerDay, DATEDIFF( curdate(), lastMaxPerDay ) as ddiff 
  FROM y3wtq_mod_vvisit_counter_memo

1 × SELECT count( * ) AS records, MAX( id ) AS max 
  FROM y3wtq_vvisitcounte

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

1 × SELECT COUNT(*) 
  FROM `y3wtq_contact_details` AS a 
  LEFT JOIN y3wtq_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN y3wtq_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN y3wtq_users AS uam 
  ON uam.id = a.modified_by

1 × SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email 
  FROM `y3wtq_contact_details` AS a 
  LEFT JOIN y3wtq_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN y3wtq_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN y3wtq_users AS uam 
  ON uam.id = a.modified_by

1 × SELECT `session_id` 
  FROM `y3wtq_session`

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`) 
  FROM `y3wtq_contact_details` AS `i`

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `y3wtq_assets`

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

```
1 × SELECT * 
  FROM y3wtq_languages
```

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM y3wtq_extensions

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

1 × SELECT id, rules 
  FROM `y3wtq_viewlevels

1 × SELECT a.id, a.alias, a.catid,c.alias AS category_alias,parent.id as parent_id, parent.alias as parent_alias 
  FROM y3wtq_content AS a 
  LEFT JOIN y3wtq_categories AS c 
  on c.id = a.catid 
  LEFT JOIN y3wtq_categories as parent 
  ON parent.id = c.parent_id

Andere Tabellen:

1 × INSERT INTO `y3wtq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'616a6a32666e33707668346f6d7237726376766474746a6d6c36', 1, 1784741734, 0, '', 0

1 × UPDATE `y3wtq_extensions` 
  SET `params` = '{\"mediaversion\":\"d900bb654ccdfb2a99395d41eef1ce55\"}'

1 × CREATE TABLE IF NOT EXISTS y3wtq_mod_vvisit_counter_memo (counter varchar(240) NOT NULL, lastMaxPerDay DATE NULL DEFAULT NULL ,  valMaxVisits INT NULL DEFAULT NULL, valMaxVisitsDay int NULL DEFAULT NULL, lastMaxVisits DATETIME NULL , PRIMARY KEY (counter) ) ENGINE=MEMOR

1 × INSERT INTO y3wtq_mod_vvisit_counter_memo ( counter ) 
  values ( 'vvisitcounter' ) 
  ON DUPLICATE KEY UPDATE counter='vvisitcounter

1 × UPDATE y3wtq_mod_vvisit_counter_memo 
  set lastMaxPerDay = CURDATE()

1 × DELETE 
  FROM y3wtq_vvisitcounter

	Heute	450
	Gestern	483
	diese Woche	1571
	diesen Monat	14307
	Gesamt	970839

Hauptmenü

Besucherzähler

VIP Log-In

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

41 ausgeführte Abfragen 189.20 ms

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

SELECT-Tabellen:

Andere Tabellen: