CDU Rheinhessen-Pfalz

Impressum

Drucken

Dienstanbieter dieser Seiten ist

CDU Bezirksverband Rheinhessen-Pfalz

Hohenzollernstraße 18
67433 Neustadt/Wstr.

Telefon: 06321 35958

Telefax: 06321 483291

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

vertreten durch den Vorsitzenden

Christian Baldauf MdL

Carl-Theodor-Straße 8
67227 Frankenthal

Inhaltlich verantwortlich gemäß § 10 (3) TMG ist

Christof Kühn

Am Rupertsberg 9a
55411 Bingen am Rhein

Telefon: 0172 4799715

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

weitere Informationen

Aktionen der CDU

Mitglied werden!

Diese Seite teilen

Wir sind für Sie da

CDU Rheinhessen-Pfalz
Bezirksgeschäftsstelle

Hohenzollernstraße 18
67433 Neustadt/Weinstr.

Tel: +49 6321 35958

Fax: +49 6321 483291

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

zum Kontaktformular

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1600692379,
                "last": 1600692379,
                "now": 1600692379
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 11.03 ms / 11.03 ms Speicher: 1.662 MB / 2.03 MB Application: afterLoad

Zeit: 61.62 ms / 72.65 ms Speicher: 4.574 MB / 6.60 MB Application: afterInitialise

Zeit: 12.46 ms / 85.11 ms Speicher: 0.904 MB / 7.51 MB Application: afterRoute

Zeit: 12.67 ms / 97.79 ms Speicher: 0.231 MB / 7.74 MB Application: beforeRenderComponent com_content

Zeit: 5.31 ms / 103.09 ms Speicher: 0.445 MB / 8.18 MB Application: Before Access::preloadComponents (all components)

Zeit: 1.52 ms / 104.61 ms Speicher: 0.056 MB / 8.24 MB Application: After Access::preloadComponents (all components)

Zeit: 0.03 ms / 104.65 ms Speicher: 0.000 MB / 8.24 MB Application: Before Access::preloadPermissions (com_content)

Zeit: 1.28 ms / 105.93 ms Speicher: 0.214 MB / 8.45 MB Application: After Access::preloadPermissions (com_content)

Zeit: 0.03 ms / 105.96 ms Speicher: 0.000 MB / 8.44 MB Application: Before Access::getAssetRules (id:39 name:com_content.article.1)

Zeit: 0.37 ms / 106.32 ms Speicher: 0.027 MB / 8.47 MB Application: After Access::getAssetRules (id:39 name:com_content.article.1)

Zeit: 119.75 ms / 226.07 ms Speicher: 10.674 MB / 19.14 MB Application: afterRenderComponent com_content

Zeit: 3.14 ms / 229.21 ms Speicher: 0.269 MB / 19.41 MB Application: afterDispatch

Zeit: 3.55 ms / 232.76 ms Speicher: 0.149 MB / 19.56 MB Application: beforeRenderModule mod_menu (Menü Recht)

Zeit: 2.55 ms / 235.31 ms Speicher: 0.138 MB / 19.70 MB Application: afterRenderModule mod_menu (Menü Recht)

Zeit: 0.09 ms / 235.40 ms Speicher: 0.000 MB / 19.69 MB Application: beforeRenderModule mod_banners (Mitglied werden!)

Zeit: 15.42 ms / 250.81 ms Speicher: 0.118 MB / 19.81 MB Application: afterRenderModule mod_banners (Mitglied werden!)

Zeit: 0.06 ms / 250.88 ms Speicher: 0.000 MB / 19.81 MB Application: beforeRenderModule mod_custom (Diese Seite teilen)

Zeit: 4.15 ms / 255.03 ms Speicher: 0.057 MB / 19.87 MB Application: afterRenderModule mod_custom (Diese Seite teilen)

Zeit: 0.05 ms / 255.08 ms Speicher: 0.000 MB / 19.86 MB Application: beforeRenderModule mod_custom (Wir sind für Sie da)

Zeit: 1.33 ms / 256.40 ms Speicher: 0.017 MB / 19.88 MB Application: afterRenderModule mod_custom (Wir sind für Sie da)

Zeit: 0.09 ms / 256.50 ms Speicher: 0.002 MB / 19.88 MB Application: beforeRenderModule mod_cdu_image (Aktionen der CDU)

Zeit: 108.26 ms / 364.76 ms Speicher: 0.018 MB / 19.90 MB Application: afterRenderModule mod_cdu_image (Aktionen der CDU)

Zeit: 0.12 ms / 364.88 ms Speicher: 0.000 MB / 19.89 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 1.16 ms / 366.04 ms Speicher: 0.024 MB / 19.91 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 0.09 ms / 366.14 ms Speicher: 0.000 MB / 19.91 MB Application: beforeRenderModule mod_menu (Main Menu)

Zeit: 6.41 ms / 372.55 ms Speicher: 0.289 MB / 20.20 MB Application: afterRenderModule mod_menu (Main Menu)

Zeit: 4.20 ms / 376.75 ms Speicher: 0.098 MB / 20.30 MB Application: afterRender

Datenbankabfragen gesamt: 70.95 ms

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cdurhpf_session	const	PRIMARY	PRIMARY	194	const	1	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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
update	0.06 ms
end	0.01 ms
query end	11.12 ms
closing tables	0.03 ms
freeing items	0.04 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Abfragezeit: 0.81 ms Nach letzter Abfrage: 2.60 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 4.194 MB Zeilen zurückgegeben: 39

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

  FROM `cdurhpf_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cdurhpf_extensions	ref	extension	extension	82	const	39	Using where

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
System lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.20 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.07 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.44 ms Nach letzter Abfrage: 2.13 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.398 MB Zeilen zurückgegeben: 4

SELECT id, rules

  FROM `cdurhpf_viewlevels`

Explain

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

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
System lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.47 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.410 MB Zeilen zurückgegeben: 1

SELECT b.id

  FROM cdurhpf_usergroups AS a

  LEFT JOIN cdurhpf_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	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	8	Using index

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.86 ms Nach letzter Abfrage: 0.64 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.479 MB Zeilen zurückgegeben: 87

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

  FROM cdurhpf_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	Extra
1	SIMPLE	cdurhpf_extensions	ref	extension	extension	82	const	118	Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sorting result	0.32 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 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:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Derselbe Aufruf in der Zeile darunter.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.20 ms Nach letzter Abfrage: 16.57 ms Abfragespeichernutzung: 0.077 MB Speichernutzung vor Abfrage: 6.320 MB Zeilen zurückgegeben: 55

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 cdurhpf_menu AS m

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	59	Using where; filesort wurde genutzt
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	db431420704.m.component_id	1

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.19 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.22 ms
Sending data	0.36 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
logging slow query	0.72 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Derselbe Aufruf in der Zeile darunter.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/communitybuilder/communitybuilder.php:300
8	plgSystemCommunityBuilder->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.85 ms Nach letzter Abfrage: 12.35 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 7.503 MB Zeilen zurückgegeben: 209

Doppelte Abfragen: #52

SHOW TABLES

Explain

„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
checking permissions	1.20 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:220
8	plgSystemjdownloads->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.35 ms Nach letzter Abfrage: 0.79 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.545 MB Zeilen zurückgegeben: 1

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

  FROM `cdurhpf_extensions`

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

Explain

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

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 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:1130
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 7.45 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 7.536 MB

UPDATE `cdurhpf_extensions`

  SET `params` = '{\"mediaversion\":\"69663a22b10612de18660be0c2d1d43b\"}'

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

Explain

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

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.05 ms
Updating	0.06 ms
end	0.02 ms
query end	7.09 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.00 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:1130
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.48 ms Nach letzter Abfrage: 2.30 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 7.721 MB Zeilen zurückgegeben: 2

SELECT *

  FROM cdurhpf_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sorting result	0.03 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.00 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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.61 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 7.732 MB Zeilen zurückgegeben: 8

SELECT id, home, template, s.params

  FROM cdurhpf_template_styles as s

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

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

Explain

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

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.00 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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.26 ms Nach letzter Abfrage: 5.96 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 8.187 MB Zeilen zurückgegeben: 39

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

  FROM `cdurhpf_assets`

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

Explain

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

Profil (Profile)

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.61 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.83 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.059 MB Speichernutzung vor Abfrage: 8.236 MB Zeilen zurückgegeben: 231

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

  FROM `cdurhpf_assets`

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

Explain

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

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.47 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.14 ms Nach letzter Abfrage: 1.27 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 8.506 MB Zeilen zurückgegeben: 31

SHOW FULL COLUMNS 
  FROM `cdurhpf_content`

Explain

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

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.16 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.04 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.07 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 7.00 ms Nach letzter Abfrage: 3.06 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 8.740 MB

UPDATE cdurhpf_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '1'

Explain

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

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.03 ms
Updating	0.07 ms
end	0.02 ms
query end	6.62 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.32 ms Nach letzter Abfrage: 1.85 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 8.864 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #34 #49 #51

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM cdurhpf_content AS a

  INNER JOIN cdurhpf_categories AS c 
  on c.id = a.catid

  LEFT JOIN cdurhpf_users AS u 
  on u.id = a.created_by

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

  LEFT JOIN cdurhpf_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 1 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-09-21 12:46:19') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-09-21 12:46:19') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found

Profil (Profile)

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.44 ms
System lock	0.01 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.30 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.11 ms Nach letzter Abfrage: 1.78 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 9.038 MB Zeilen zurückgegeben: 0

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

  FROM `cdurhpf_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  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	Extra
1	SIMPLE	m	ALL	idx_tag_type	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db431420704.m.tag_id	1	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.59 ms Nach letzter Abfrage: 12.05 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.151 MB Zeilen zurückgegeben: 0

SELECT id, link 
  from cdurhpf_menu 
  WHERE link LIKE 'index.php?option=com_jdownloads&view=category%' 
  AND published = 1

Explain

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

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/plugins/content/jdownloads/jdownloads.php:57
13	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.35 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.160 MB Zeilen zurückgegeben: 0

SELECT id, link, published, access, language 
  FROM cdurhpf_menu 
  WHERE (link LIKE 'index.php?option=com_jdownloads%') 
  AND published = 1 
  AND client_id = 0 
  AND language = 'de-de' 
  AND access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cdurhpf_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_language	28	const	1	Using where

Profil (Profile)

Status	Duration
starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/helpers/jdownloads.php:232
14	JDHelper::getMenuItemids()	JROOT/plugins/content/jdownloads/jdownloads.php:66
13	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.41 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.168 MB Zeilen zurückgegeben: 0

SELECT id, link, published, access, language 
  FROM cdurhpf_menu 
  WHERE (link LIKE 'index.php?option=com_jdownloads%') 
  AND published = 1 
  AND client_id = 0 
  AND access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cdurhpf_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	60	Using where

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/helpers/jdownloads.php:237
14	JDHelper::getMenuItemids()	JROOT/plugins/content/jdownloads/jdownloads.php:66
13	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.28 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.176 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #27

SELECT id 
  FROM cdurhpf_menu 
  WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories'  ) 
  AND published = 1 
  AND client_id = 0 
  AND language = 'de-de' 
  AND access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cdurhpf_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_language	28	const	1	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloads.php:290
14	JDHelper::getMenuItemids()	JROOT/plugins/content/jdownloads/jdownloads.php:66
13	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.42 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.183 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #28

SELECT id 
  FROM cdurhpf_menu 
  WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories'  ) 
  AND published = 1 
  AND client_id = 0 
  AND access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cdurhpf_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	60	Using where

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloads.php:294
14	JDHelper::getMenuItemids()	JROOT/plugins/content/jdownloads/jdownloads.php:66
13	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.34 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.191 MB Zeilen zurückgegeben: 0

SELECT id 
  FROM cdurhpf_menu 
  WHERE (link = 'index.php?option=com_jdownloads&view=downloads') 
  AND published = 1 
  AND client_id = 0 
  AND client_id = 0 
  AND access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cdurhpf_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	60	Using where

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloads.php:326
14	JDHelper::getMenuItemids()	JROOT/plugins/content/jdownloads/jdownloads.php:66
13	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.31 ms Nach letzter Abfrage: 0.02 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.199 MB Zeilen zurückgegeben: 0

SELECT id 
  FROM cdurhpf_menu 
  WHERE (link = 'index.php?option=com_jdownloads&view=downloads&type=uncategorised') 
  AND published = 1 
  AND client_id = 0 
  AND access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cdurhpf_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	60	Using where

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloads.php:333
14	JDHelper::getMenuItemids()	JROOT/plugins/content/jdownloads/jdownloads.php:66
13	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.206 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #23

SELECT id 
  FROM cdurhpf_menu 
  WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories'  ) 
  AND published = 1 
  AND client_id = 0 
  AND language = 'de-de' 
  AND access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cdurhpf_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_language	28	const	1	Using where

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloads.php:344
14	JDHelper::getMenuItemids()	JROOT/plugins/content/jdownloads/jdownloads.php:66
13	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.38 ms Nach letzter Abfrage: 0.02 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.214 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #24

SELECT id 
  FROM cdurhpf_menu 
  WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories'  ) 
  AND published = 1 
  AND client_id = 0 
  AND access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cdurhpf_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	60	Using where

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloads.php:348
14	JDHelper::getMenuItemids()	JROOT/plugins/content/jdownloads/jdownloads.php:66
13	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.29 ms Nach letzter Abfrage: 0.02 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.222 MB Zeilen zurückgegeben: 0

SELECT id 
  FROM cdurhpf_menu 
  WHERE link = 'index.php?option=com_jdownloads&view=search' 
  AND published = 1 
  AND client_id = 0 
  AND access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cdurhpf_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	60	Using where

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloads.php:361
14	JDHelper::getMenuItemids()	JROOT/plugins/content/jdownloads/jdownloads.php:66
13	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.27 ms Nach letzter Abfrage: 0.02 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.229 MB Zeilen zurückgegeben: 0

SELECT id 
  FROM cdurhpf_menu 
  WHERE link = 'index.php?option=com_jdownloads&view=form&layout=edit' 
  AND published = 1 
  AND client_id = 0 
  AND access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cdurhpf_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	60	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloads.php:366
14	JDHelper::getMenuItemids()	JROOT/plugins/content/jdownloads/jdownloads.php:66
13	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.36 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.236 MB Zeilen zurückgegeben: 0

SELECT id, link 
  from cdurhpf_menu 
  WHERE link LIKE 'index.php?option=com_jdownloads&view=category&catid%' 
  AND published = 1 
  AND access IN (1,1)

Explain

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

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/components/com_jdownloads/helpers/jdownloads.php:399
14	JDHelper::getAllJDCategoryMenuIDs()	JROOT/plugins/content/jdownloads/jdownloads.php:70
13	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.64 ms Nach letzter Abfrage: 5.91 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 10.741 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 `cdurhpf_categories` AS `s`

  INNER JOIN `cdurhpf_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 = 2

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	2	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.37 ms Nach letzter Abfrage: 0.51 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 10.791 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 cdurhpf_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (2,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	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	db431420704.a.language	1
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	db431420704.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	db431420704.a.access	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	db431420704.a.created_user_id	1
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	db431420704.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	db431420704.a.id	1	Using where; Using index; Distinct

Profil (Profile)

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.38 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
Creating tmp table	0.30 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Sorting result	0.03 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.04 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.63 ms Nach letzter Abfrage: 2.90 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 11.095 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #18 #49 #51

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM cdurhpf_content AS a

  INNER JOIN cdurhpf_categories AS c 
  on c.id = a.catid

  LEFT JOIN cdurhpf_users AS u 
  on u.id = a.created_by

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

  LEFT JOIN cdurhpf_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 1 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-09-21 12:46:19') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-09-21 12:46:19') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
15	ContentModelArticle->getItem()	JROOT/plugins/content/myshariff/myshariff.php:249
14	plgContentMyShariff->excludeAREA()	JROOT/plugins/content/myshariff/myshariff.php:399
13	plgContentMyShariff->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.53 ms Nach letzter Abfrage: 22.07 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 14.218 MB Zeilen zurückgegeben: 1

SELECT `params`
 
  FROM `cdurhpf_comprofiler_plugin`
 
  WHERE `id` = 1

Explain

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

Profil (Profile)

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
30	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345
29	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:43
28	CB\Application\CBConfig::getConfig()	JROOT/libraries/CBLib/CB/Application/CBApplication.php:45
27	CB\Application\CBApplication::CB\Application\{closure}()	Derselbe Aufruf in der Zeile darunter.
26	call_user_func_array()	JROOT/libraries/CBLib/CBLib/Application/Config.php:38
25	CBLib\Application\Config::setMainConfig()	JROOT/libraries/CBLib/CBLib/Core/CBLib.php:70
24	CBLib\Core\CBLib::CBLib\Core\{closure}()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:605
23	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496
22	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/Application/Application.php:179
21	CBLib\Application\Application::__callStatic()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:77
20	CB\Application\CBConfig::loadLegacyCBueConfig()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:109
19	CB\Legacy\LegacyFoundationFunctions->__construct()	Derselbe Aufruf in der Zeile darunter.
18	ReflectionClass->newInstanceArgs()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:643
17	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496
16	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:132
15	CBLib\DependencyInjection\Container->get()	JROOT/administrator/components/com_comprofiler/plugin.foundation.php:33
14	include_once JROOT/administrator/components/com_comprofiler/plugin.foundation.php	JROOT/plugins/content/cbauthorbot/cbauthorbot.php:29
13	plgContentcbauthorbot->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.94 ms Nach letzter Abfrage: 12.29 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 15.644 MB Zeilen zurückgegeben: 16

SHOW FULL COLUMNS 
  FROM `cdurhpf_users`

Explain

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

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.21 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.10 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.07 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
21	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
20	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
19	Joomla\CMS\User\User::getTable()	JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:180
18	CB\Database\Table\UserTable->_reinitNonComprofileVars()	JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:120
17	CB\Database\Table\UserTable->__construct()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:209
16	CBuser->load()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:153
15	CBuser::_getOrSetInstance()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:84
14	CBuser::getInstance()	JROOT/plugins/content/cbauthorbot/cbauthorbot.php:33
13	plgContentcbauthorbot->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.73 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 15.678 MB Zeilen zurückgegeben: 1

SELECT c.*, u.*
 
  FROM cdurhpf_users AS u
 
  LEFT JOIN cdurhpf_comprofiler AS c 
  ON c.id = u.id
 
  WHERE u.`id` = 42

Explain

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

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:381
18	CBLib\Database\Driver\CmsDatabaseDriver->loadAssoc()	JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:264
17	CB\Database\Table\UserTable->load()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:210
16	CBuser->load()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:153
15	CBuser::_getOrSetInstance()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:84
14	CBuser::getInstance()	JROOT/plugins/content/cbauthorbot/cbauthorbot.php:33
13	plgContentcbauthorbot->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.38 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 15.709 MB Zeilen zurückgegeben: 1

SELECT a.id

  FROM cdurhpf_user_usergroup_map AS map

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

  WHERE map.user_id = 42

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	map	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	db431420704.map.group_id	1	Using index

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
21	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
20	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:335
19	CB\Database\Table\UserTable->afterBindFromDatabase()	JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:325
18	CB\Database\Table\UserTable->bindThisUserFromDbArray()	JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:282
17	CB\Database\Table\UserTable->load()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:210
16	CBuser->load()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:153
15	CBuser::_getOrSetInstance()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:84
14	CBuser::getInstance()	JROOT/plugins/content/cbauthorbot/cbauthorbot.php:33
13	plgContentcbauthorbot->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.83 ms Nach letzter Abfrage: 3.27 ms Abfragespeichernutzung: 0.073 MB Speichernutzung vor Abfrage: 16.034 MB Zeilen zurückgegeben: 74

SELECT f.* 
  FROM cdurhpf_comprofiler_fields f
 
  INNER JOIN cdurhpf_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)
 
  WHERE ( f.published = 1 OR f.name = 'name' )
 
  ORDER BY t.position, t.ordering, f.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	index	PRIMARY	enabled_position_ordering	772	NULL	18	Using index; Using temporary; filesort wurde genutzt
1	SIMPLE	f	ref	tabid_pub_prof_order	tabid_pub_prof_order	5	db431420704.t.tabid	3	Using where

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.17 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Creating tmp table	0.18 ms
executing	0.01 ms
Copying to tmp table	0.39 ms
Sorting result	0.22 ms
Sending data	0.38 ms
end	0.01 ms
removing tmp table	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394
17	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446
16	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:971
15	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:332
14	CBuser->getField()	JROOT/plugins/content/cbauthorbot/cbauthorbot.php:36
13	plgContentcbauthorbot->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.42 ms Nach letzter Abfrage: 0.83 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 16.194 MB Zeilen zurückgegeben: 6

SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
 
  FROM `cdurhpf_comprofiler_plugin`
 
  WHERE `published` = 1
 
  AND `viewaccesslevel` IN (1)
 
  AND `type` = 'user'
 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cdurhpf_comprofiler_plugin	ref	type_pub_order,idx_folder	type_pub_order	304	const,const	6	Using where

Profil (Profile)

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sorting result	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394
18	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446
17	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181
16	cbPluginHandler->loadPluginGroup()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1017
15	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:332
14	CBuser->getField()	JROOT/plugins/content/cbauthorbot/cbauthorbot.php:36
13	plgContentcbauthorbot->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.60 ms Nach letzter Abfrage: 24.35 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 18.900 MB Zeilen zurückgegeben: 1

SELECT `id`
 
  FROM `cdurhpf_menu`
 
  WHERE ( `link` = 'index.php?option=com_comprofiler&view=userprofile' OR `link` = 'index.php?option=com_comprofiler&task=userprofile' OR `link` = 'index.php?option=com_comprofiler' )
 
  AND `published` = 1
 
  AND `access` IN ( 1 )
 
  AND `language` IN ( 'de-DE', '*', '' )
 
  AND `client_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cdurhpf_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	60	Using where

Profil (Profile)

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345
22	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:242
21	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:1006
20	CBframework->viewUrl()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:865
19	CBframework->userProfileUrl()	JROOT/components/com_comprofiler/plugin/user/plug_cbcore/cb.core.php:5158
18	CBfield_formatname->getField()	JROOT/libraries/CBLib/CB/Legacy/cbFieldHandler.php:101
17	cbFieldHandler->getFieldRow()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:885
16	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1081
15	cbPluginHandler->callField()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:351
14	CBuser->getField()	JROOT/plugins/content/cbauthorbot/cbauthorbot.php:36
13	plgContentcbauthorbot->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.27 ms Nach letzter Abfrage: 8.87 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 19.538 MB Zeilen zurückgegeben: 9

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

  FROM cdurhpf_modules AS m

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

  LEFT JOIN cdurhpf_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 <= '2020-09-21 12:46:19') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-09-21 12:46:19') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 125 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.24 ms
Sending data	0.22 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.09 ms
freeing items	0.04 ms
logging slow query	0.01 ms
cleaning up	0.01 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:432
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
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:591
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/ubg_cduci2010_j17/index.php:25
7	require JROOT/templates/ubg_cduci2010_j17/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.86 ms Nach letzter Abfrage: 4.61 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.741 MB Zeilen zurückgegeben: 0

SELECT *

  FROM cdurhpf_banners

  WHERE '2020-09-21 12:46:19' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

Explain

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

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.27 ms
closing tables	0.09 ms
freeing items	0.04 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
10	include JROOT/modules/mod_banners/mod_banners.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.78 ms Nach letzter Abfrage: 0.73 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 19.800 MB Zeilen zurückgegeben: 1

SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions

  FROM cdurhpf_banners as a

  LEFT JOIN cdurhpf_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-09-21 12:46:19') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-09-21 12:46:19') 
  AND (a.imptotal = 0 OR a.impmade < a.imptotal) 
  AND a.cid = 1 
  AND cl.state = 1 
  AND a.catid IN (39)

  ORDER BY a.sticky DESC,a.ordering 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cl	const	PRIMARY	PRIMARY	4	const	1	filesort wurde genutzt
1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_state	1	const	1	Using where

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.23 ms
preparing	0.03 ms
executing	0.02 ms
Sorting result	0.05 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 5.51 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 19.812 MB

UPDATE cdurhpf_banners

  SET impmade = (impmade + 1)

  WHERE id IN (1)

Explain

„EXPLAIN“ unmöglich für Abfrage: UPDATE cdurhpf_banners SET impmade = (impmade + 1) WHERE id IN (1)

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.03 ms
Updating	0.07 ms
end	0.01 ms
query end	5.18 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:266
12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.46 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 19.818 MB

UPDATE cdurhpf_banner_tracks

  SET `count` = (`count` + 1)

  WHERE track_type=1 
  AND banner_id=1 
  AND track_date='2020-09-21 12:46:19'

Explain

„EXPLAIN“ unmöglich für Abfrage: UPDATE cdurhpf_banner_tracks SET `count` = (`count` + 1) WHERE track_type=1 AND banner_id=1 AND track_date='2020-09-21 12:46:19'

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
System lock	0.01 ms
init	0.10 ms
Updating	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:304
12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 5.24 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 19.825 MB

INSERT INTO cdurhpf_banner_tracks
(`count`,`track_type`,`banner_id`,`track_date`) 
  VALUES 
(1, 1, 1, '2020-09-21 12:46:19')

Explain

„EXPLAIN“ unmöglich für Abfrage: INSERT INTO cdurhpf_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`) VALUES (1, 1, 1, '2020-09-21 12:46:19')

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
update	0.06 ms
end	0.01 ms
query end	4.94 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:329
12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.06 ms Nach letzter Abfrage: 1.57 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 19.840 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 cdurhpf_fields AS a

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

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

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

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

  LEFT JOIN cdurhpf_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	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	db431420704.a.language	1
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	db431420704.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	db431420704.a.access	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	db431420704.a.created_user_id	1
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	db431420704.a.group_id	1	Using where

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.04 ms
Creating tmp table	0.31 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Sorting result	0.02 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
logging slow query	0.01 ms
cleaning up	0.01 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:308
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:187
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:146
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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.60 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 19.859 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #18 #34 #51

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM cdurhpf_content AS a

  INNER JOIN cdurhpf_categories AS c 
  on c.id = a.catid

  LEFT JOIN cdurhpf_users AS u 
  on u.id = a.created_by

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

  LEFT JOIN cdurhpf_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 1 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-09-21 12:46:19') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-09-21 12:46:19') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
19	ContentModelArticle->getItem()	JROOT/plugins/content/myshariff/myshariff.php:249
18	plgContentMyShariff->excludeAREA()	JROOT/plugins/content/myshariff/myshariff.php:399
17	plgContentMyShariff->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:146
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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.27 ms Nach letzter Abfrage: 0.74 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 19.871 MB Zeilen zurückgegeben: 0

SELECT `alias`

  FROM `cdurhpf_content`

  WHERE id = ''

Explain

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

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
30	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
29	ContentRouter->getArticleSegment()	Derselbe Aufruf in der Zeile darunter.
28	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
27	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
26	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
25	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
21	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
20	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/myshariff/myshariff.php:148
19	plgContentMyShariff->getShariffHTML()	JROOT/plugins/content/myshariff/myshariff.php:227
18	plgContentMyShariff->getShariffTag()	JROOT/plugins/content/myshariff/myshariff.php:451
17	plgContentMyShariff->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:146
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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.56 ms Nach letzter Abfrage: 0.78 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 19.893 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #18 #34 #49

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM cdurhpf_content AS a

  INNER JOIN cdurhpf_categories AS c 
  on c.id = a.catid

  LEFT JOIN cdurhpf_users AS u 
  on u.id = a.created_by

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

  LEFT JOIN cdurhpf_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 1 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-09-21 12:46:19') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-09-21 12:46:19') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
19	ContentModelArticle->getItem()	JROOT/plugins/content/myshariff/myshariff.php:249
18	plgContentMyShariff->excludeAREA()	JROOT/plugins/content/myshariff/myshariff.php:399
17	plgContentMyShariff->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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.69 ms Nach letzter Abfrage: 118.00 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 20.256 MB Zeilen zurückgegeben: 209

Doppelte Abfragen: #9

SHOW TABLES

Explain

„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES

Profil (Profile)

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
checking permissions	1.01 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
8	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:116
7	plgSystemjdownloads->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT-Tabellen:

```
8 × SELECT id 
  FROM cdurhpf_menu
```

4 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM cdurhpf_content AS a 
  INNER JOIN cdurhpf_categories AS c 
  on c.id = a.catid 
  LEFT JOIN cdurhpf_users AS u 
  on u.id = a.created_by 
  LEFT JOIN cdurhpf_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN cdurhpf_content_rating AS v 
  ON a.id = v.content_id

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

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

2 × SELECT id, link 
  from cdurhpf_menu

2 × SELECT id, link, published, access, language 
  FROM cdurhpf_menu

1 × SELECT `params`  
  FROM `cdurhpf_comprofiler_plugin`

1 × 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 cdurhpf_fields AS a 
  LEFT JOIN `cdurhpf_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN cdurhpf_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN cdurhpf_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN cdurhpf_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN cdurhpf_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions 
  FROM cdurhpf_banners as a 
  LEFT JOIN cdurhpf_banner_clients AS cl 
  ON cl.id = a.cid

```
1 × SELECT * 
  FROM cdurhpf_banners
```

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

1 × SELECT `id`  
  FROM `cdurhpf_menu`

1 × SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup  
  FROM `cdurhpf_comprofiler_plugin`

1 × SELECT f.* 
  FROM cdurhpf_comprofiler_fields f  
  INNER JOIN cdurhpf_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)

1 × SELECT a.id 
  FROM cdurhpf_user_usergroup_map AS map 
  LEFT JOIN cdurhpf_usergroups AS a 
  ON a.id = map.group_id

1 × SELECT c.*, u.*  
  FROM cdurhpf_users AS u  
  LEFT JOIN cdurhpf_comprofiler AS c 
  ON c.id = u.id

1 × SELECT `data` 
  FROM `cdurhpf_session`

1 × 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 cdurhpf_fields AS a 
  LEFT JOIN `cdurhpf_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN cdurhpf_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN cdurhpf_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN cdurhpf_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN cdurhpf_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `cdurhpf_fields_categories` AS fc 
  ON fc.field_id = a.id

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 
  FROM `cdurhpf_categories` AS `s` 
  INNER JOIN `cdurhpf_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 `session_id` 
  FROM `cdurhpf_session`

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `cdurhpf_contentitem_tag_map` AS m  
  INNER JOIN `cdurhpf_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

1 × SELECT * 
  FROM cdurhpf_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 cdurhpf_menu AS m 
  LEFT JOIN cdurhpf_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 cdurhpf_extensions

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

1 × SELECT id, rules 
  FROM `cdurhpf_viewlevels

1 × SELECT `alias` 
  FROM `cdurhpf_content`

Andere Tabellen:

```
2 × SHOW TABLE
```

1 × INSERT INTO `cdurhpf_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3863633233386566316563356639336663363038393131393462633539613639', 1, 1600692379, 0, '', 0

1 × UPDATE `cdurhpf_extensions` 
  SET `params` = '{\"mediaversion\":\"69663a22b10612de18660be0c2d1d43b\"}'

1 × SHOW FULL COLUMNS 
  FROM `cdurhpf_content

1 × UPDATE cdurhpf_content 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `cdurhpf_users

1 × UPDATE cdurhpf_banners 
  SET impmade = (impmade + 1)

1 × UPDATE cdurhpf_banner_tracks 
  SET `count` = (`count` + 1)

1 × INSERT INTO cdurhpf_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`) 
  VALUES  (1, 1, 1, '2020-09-21 12:46:19'

CDU Rheinhessen-Pfalz

Impressum

Dienstanbieter dieser Seiten ist

vertreten durch den Vorsitzenden

Inhaltlich verantwortlich gemäß § 10 (3) TMG ist

weitere Informationen

Aktionen der CDU

Mitglied werden!

Diese Seite teilen

Wir sind für Sie da

CDU Rheinhessen-Pfalz
Bezirksgeschäftsstelle

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

52 ausgeführte Abfragen 70.95 ms

10 Duplikate gefunden!

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

SELECT-Tabellen:

Andere Tabellen:

CDU Rheinhessen-Pfalz

Impressum

Dienstanbieter dieser Seiten ist

vertreten durch den Vorsitzenden

Inhaltlich verantwortlich gemäß § 10 (3) TMG ist

weitere Informationen

Aktionen der CDU

Mitglied werden!

Diese Seite teilen

Wir sind für Sie da

CDU Rheinhessen-PfalzBezirksgeschäftsstelle

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

52 ausgeführte Abfragen 70.95 ms

10 Duplikate gefunden!

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

SELECT-Tabellen:

Andere Tabellen:

CDU Rheinhessen-Pfalz
Bezirksgeschäftsstelle