Left-Content-Right

Assign modules on offcanvas module position to make them visible in the sidebar.

Main Menu

Top1-2

Suffix: color1-ms

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris in augue mollis, semper est ac, aliquet turpis. Vestibulum ut dapibus dolor. Vestibulum commodo, ligula non iaculis tristique, erat sem luctus sapien, sed auctor felis nisi sed mauris.

Suffix: color-box1-ms

Suffix: color-box2-ms

Suffix: color-box3-ms

Top1-3

Suffix: color2-ms

Suffix: color-box4-ms

Top3-1

Top3-2

Top3-3

Top3-4

Content-Top

Details: Geschrieben von Super User

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris in augue mollis, semper est ac, aliquet turpis. Vestibulum ut dapibus dolor.

Vestibulum commodo, ligula non iaculis tristique, erat sem luctus sapien, sed auctor felis nisi sed mauris. Maecenas eu iaculis tortor, ac volutpat ipsum. In eget lacus erat.

Nullam nec magna tellus. Vestibulum rutrum velit et nulla tristique, ac sodales risus tempor. Mauris in augue mollis, semper est ac, aliquet turpis. Vestibulum ut dapibus dolor.

Phasellus sed nisi ut nibh accumsan commodo sed a libero. In ut semper felis, a vestibulum mi. Ut et lacus lectus.

Content-Bottom

Left-Column

Bottom1-1

Bottom1-2

Bottom1-3

Bottom1-4

Bottom2-1

Bottom2-2

Bottom2-3

Bottom2-4

Footer-mod-1

Footer-mod-4

Cookies erleichtern die Bereitstellung unserer Dienste. Mit der Nutzung unserer Dienste erklären Sie sich damit einverstanden, dass wir Cookies verwenden.

Weitere Informationen Ok

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1714244769,
                "last": 1714244769,
                "now": 1714244769
            },
            "token": "vCuh4YTT8GL0J4InnUzE5ZXc0GjkXPVW"
        },
        "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: 74.67 ms / 74.67 ms Speicher: 1.921 MB / 2.25 MB Application: afterLoad

Zeit: 248.53 ms / 323.19 ms Speicher: 5.241 MB / 7.49 MB Application: afterInitialise

Zeit: 97.80 ms / 421.00 ms Speicher: 2.008 MB / 9.50 MB Application: afterRoute

Zeit: 3.03 ms / 424.02 ms Speicher: 0.026 MB / 9.53 MB Application: beforeRenderComponent com_content

Zeit: 22.55 ms / 446.57 ms Speicher: 0.445 MB / 9.97 MB Application: Before Access::preloadComponents (all components)

Zeit: 2.77 ms / 449.34 ms Speicher: 0.065 MB / 10.04 MB Application: After Access::preloadComponents (all components)

Zeit: 0.07 ms / 449.41 ms Speicher: -0.004 MB / 10.03 MB Application: Before Access::preloadPermissions (com_content)

Zeit: 3.25 ms / 452.66 ms Speicher: 0.362 MB / 10.39 MB Application: After Access::preloadPermissions (com_content)

Zeit: 0.07 ms / 452.72 ms Speicher: -0.019 MB / 10.37 MB Application: Before Access::getAssetRules (id:182 name:com_content.article.73)

Zeit: 1.82 ms / 454.54 ms Speicher: 0.026 MB / 10.40 MB Application: After Access::getAssetRules (id:182 name:com_content.article.73)

Zeit: 137.82 ms / 592.37 ms Speicher: 2.335 MB / 12.74 MB Application: afterRenderComponent com_content

Zeit: 9.09 ms / 601.45 ms Speicher: 0.156 MB / 12.89 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Zeit: 0.07 ms / 601.52 ms Speicher: 0.007 MB / 12.90 MB Application: After Access::getAssetRules (id:1 name:root.1)

Zeit: 44.25 ms / 645.77 ms Speicher: 0.059 MB / 12.96 MB Application: afterDispatch

Zeit: 123.78 ms / 769.55 ms Speicher: 1.174 MB / 14.13 MB Application: beforeRenderModule mod_custom (Top1-2)

Zeit: 6.83 ms / 776.39 ms Speicher: 0.034 MB / 14.16 MB Application: afterRenderModule mod_custom (Top1-2)

Zeit: 1.20 ms / 777.59 ms Speicher: -0.001 MB / 14.16 MB Application: beforeRenderModule mod_custom (Top2-1)

Zeit: 1.11 ms / 778.69 ms Speicher: 0.004 MB / 14.17 MB Application: afterRenderModule mod_custom (Top2-1)

Zeit: 0.24 ms / 778.93 ms Speicher: -0.001 MB / 14.17 MB Application: beforeRenderModule mod_custom (Top2-2)

Zeit: 0.87 ms / 779.80 ms Speicher: 0.003 MB / 14.17 MB Application: afterRenderModule mod_custom (Top2-2)

Zeit: 0.22 ms / 780.02 ms Speicher: -0.000 MB / 14.17 MB Application: beforeRenderModule mod_custom (Top2-3)

Zeit: 0.79 ms / 780.81 ms Speicher: 0.003 MB / 14.17 MB Application: afterRenderModule mod_custom (Top2-3)

Zeit: 0.09 ms / 780.90 ms Speicher: -0.000 MB / 14.17 MB Application: beforeRenderModule mod_custom (Top1-3)

Zeit: 0.77 ms / 781.67 ms Speicher: 0.003 MB / 14.18 MB Application: afterRenderModule mod_custom (Top1-3)

Zeit: 0.20 ms / 781.87 ms Speicher: -0.001 MB / 14.17 MB Application: beforeRenderModule mod_custom (Top2-4)

Zeit: 0.78 ms / 782.65 ms Speicher: 0.003 MB / 14.18 MB Application: afterRenderModule mod_custom (Top2-4)

Zeit: 1.08 ms / 783.73 ms Speicher: -0.003 MB / 14.17 MB Application: beforeRenderModule mod_custom (Top3-1)

Zeit: 0.80 ms / 784.53 ms Speicher: 0.003 MB / 14.18 MB Application: afterRenderModule mod_custom (Top3-1)

Zeit: 0.16 ms / 784.69 ms Speicher: -0.001 MB / 14.18 MB Application: beforeRenderModule mod_custom (Top3-2)

Zeit: 0.81 ms / 785.50 ms Speicher: 0.003 MB / 14.18 MB Application: afterRenderModule mod_custom (Top3-2)

Zeit: 0.16 ms / 785.66 ms Speicher: -0.000 MB / 14.18 MB Application: beforeRenderModule mod_custom (Top3-3)

Zeit: 0.85 ms / 786.51 ms Speicher: 0.003 MB / 14.18 MB Application: afterRenderModule mod_custom (Top3-3)

Zeit: 0.20 ms / 786.71 ms Speicher: -0.000 MB / 14.18 MB Application: beforeRenderModule mod_custom (Top3-4)

Zeit: 0.89 ms / 787.60 ms Speicher: 0.006 MB / 14.19 MB Application: afterRenderModule mod_custom (Top3-4)

Zeit: 1.57 ms / 789.17 ms Speicher: 0.005 MB / 14.19 MB Application: beforeRenderModule mod_custom (Content-Top)

Zeit: 0.80 ms / 789.97 ms Speicher: 0.003 MB / 14.20 MB Application: afterRenderModule mod_custom (Content-Top)

Zeit: 0.20 ms / 790.16 ms Speicher: -0.001 MB / 14.20 MB Application: beforeRenderModule mod_custom (Content-Bottom)

Zeit: 4.88 ms / 795.04 ms Speicher: 0.003 MB / 14.20 MB Application: afterRenderModule mod_custom (Content-Bottom)

Zeit: 0.33 ms / 795.36 ms Speicher: -0.001 MB / 14.20 MB Application: beforeRenderModule mod_custom (Left-Column)

Zeit: 2.19 ms / 797.56 ms Speicher: 0.003 MB / 14.20 MB Application: afterRenderModule mod_custom (Left-Column)

Zeit: 0.15 ms / 797.70 ms Speicher: -0.000 MB / 14.20 MB Application: beforeRenderModule mod_custom (Left-Column)

Zeit: 0.93 ms / 798.64 ms Speicher: 0.003 MB / 14.20 MB Application: afterRenderModule mod_custom (Left-Column)

Zeit: 0.10 ms / 798.74 ms Speicher: -0.001 MB / 14.20 MB Application: beforeRenderModule mod_custom (Left-Column)

Zeit: 1.19 ms / 799.93 ms Speicher: 0.003 MB / 14.21 MB Application: afterRenderModule mod_custom (Left-Column)

Zeit: 1.90 ms / 801.83 ms Speicher: -0.009 MB / 14.20 MB Application: beforeRenderModule mod_custom (Bottom1-1)

Zeit: 1.03 ms / 802.86 ms Speicher: 0.003 MB / 14.20 MB Application: afterRenderModule mod_custom (Bottom1-1)

Zeit: 0.21 ms / 803.07 ms Speicher: -0.001 MB / 14.20 MB Application: beforeRenderModule mod_custom (Bottom1-2)

Zeit: 1.40 ms / 804.47 ms Speicher: 0.003 MB / 14.20 MB Application: afterRenderModule mod_custom (Bottom1-2)

Zeit: 0.19 ms / 804.66 ms Speicher: -0.000 MB / 14.20 MB Application: beforeRenderModule mod_custom (Bottom1-3)

Zeit: 0.85 ms / 805.52 ms Speicher: 0.003 MB / 14.21 MB Application: afterRenderModule mod_custom (Bottom1-3)

Zeit: 0.19 ms / 805.70 ms Speicher: -0.000 MB / 14.21 MB Application: beforeRenderModule mod_custom (Bottom1-4)

Zeit: 0.86 ms / 806.57 ms Speicher: 0.003 MB / 14.21 MB Application: afterRenderModule mod_custom (Bottom1-4)

Zeit: 1.12 ms / 807.68 ms Speicher: 0.012 MB / 14.22 MB Application: beforeRenderModule mod_custom (Bottom2-1)

Zeit: 0.97 ms / 808.65 ms Speicher: 0.003 MB / 14.23 MB Application: afterRenderModule mod_custom (Bottom2-1)

Zeit: 0.21 ms / 808.86 ms Speicher: -0.001 MB / 14.23 MB Application: beforeRenderModule mod_custom (Bottom2-2)

Zeit: 0.83 ms / 809.68 ms Speicher: 0.003 MB / 14.23 MB Application: afterRenderModule mod_custom (Bottom2-2)

Zeit: 0.20 ms / 809.89 ms Speicher: -0.000 MB / 14.23 MB Application: beforeRenderModule mod_custom (Bottom2-3)

Zeit: 0.86 ms / 810.75 ms Speicher: 0.003 MB / 14.23 MB Application: afterRenderModule mod_custom (Bottom2-3)

Zeit: 0.14 ms / 810.89 ms Speicher: -0.000 MB / 14.23 MB Application: beforeRenderModule mod_custom (Bottom2-4)

Zeit: 0.80 ms / 811.69 ms Speicher: 0.003 MB / 14.24 MB Application: afterRenderModule mod_custom (Bottom2-4)

Zeit: 1.11 ms / 812.79 ms Speicher: -0.004 MB / 14.23 MB Application: beforeRenderModule mod_custom (Footer-mod-1)

Zeit: 0.84 ms / 813.63 ms Speicher: 0.003 MB / 14.24 MB Application: afterRenderModule mod_custom (Footer-mod-1)

Zeit: 0.21 ms / 813.84 ms Speicher: -0.000 MB / 14.24 MB Application: beforeRenderModule mod_custom (Footer-mod-4)

Zeit: 0.83 ms / 814.67 ms Speicher: 0.003 MB / 14.24 MB Application: afterRenderModule mod_custom (Footer-mod-4)

Zeit: 7.70 ms / 822.37 ms Speicher: 0.369 MB / 14.61 MB Application: beforeRenderModule mod_custom (Copyrights)

Zeit: 0.90 ms / 823.27 ms Speicher: 0.014 MB / 14.62 MB Application: afterRenderModule mod_custom (Copyrights)

Zeit: 0.10 ms / 823.37 ms Speicher: 0.000 MB / 14.62 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 9.95 ms / 833.32 ms Speicher: 0.085 MB / 14.71 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 0.34 ms / 833.66 ms Speicher: -0.003 MB / 14.70 MB Application: beforeRenderModule mod_custom (Header)

Zeit: 1.28 ms / 834.94 ms Speicher: 0.003 MB / 14.71 MB Application: afterRenderModule mod_custom (Header)

Zeit: 0.11 ms / 835.06 ms Speicher: -0.000 MB / 14.71 MB Application: beforeRenderModule mod_custom (Header-bg)

Zeit: 0.87 ms / 835.92 ms Speicher: 0.003 MB / 14.71 MB Application: afterRenderModule mod_custom (Header-bg)

Zeit: 0.10 ms / 836.02 ms Speicher: -0.001 MB / 14.71 MB Application: beforeRenderModule mod_custom (Offcanvas Button)

Zeit: 1.08 ms / 837.11 ms Speicher: 0.003 MB / 14.71 MB Application: afterRenderModule mod_custom (Offcanvas Button)

Zeit: 0.07 ms / 837.18 ms Speicher: 0.010 MB / 14.72 MB Application: beforeRenderModule mod_djmegamenu (DJ-MegaMenu)

Zeit: 13.92 ms / 851.09 ms Speicher: 0.223 MB / 14.95 MB Application: beforeRenderModule mod_custom (Offcanvas Info)

Zeit: 0.89 ms / 851.99 ms Speicher: 0.003 MB / 14.95 MB Application: afterRenderModule mod_custom (Offcanvas Info)

Zeit: 23.38 ms / 875.37 ms Speicher: -0.032 MB / 14.92 MB Application: afterRenderModule mod_djmegamenu (DJ-MegaMenu)

Zeit: 0.16 ms / 875.52 ms Speicher: -0.021 MB / 14.90 MB Application: beforeRenderModule mod_custom (Offcanvas Info)

Zeit: 1.02 ms / 876.55 ms Speicher: 0.003 MB / 14.90 MB Application: afterRenderModule mod_custom (Offcanvas Info)

Zeit: 0.10 ms / 876.64 ms Speicher: 0.000 MB / 14.90 MB Application: beforeRenderModule mod_menu (Main Menu)

Zeit: 13.07 ms / 889.71 ms Speicher: 0.039 MB / 14.94 MB Application: afterRenderModule mod_menu (Main Menu)

Zeit: 0.07 ms / 889.79 ms Speicher: -0.005 MB / 14.93 MB Application: beforeRenderModule mod_tags_popular (Tags)

Zeit: 28.46 ms / 918.25 ms Speicher: 0.100 MB / 15.03 MB Application: afterRenderModule mod_tags_popular (Tags)

Zeit: 35.91 ms / 954.16 ms Speicher: 0.147 MB / 15.18 MB Application: afterRender

Datenbankabfragen gesamt: 82.32 ms

Speichernutzung

Datenbankabfragen

28 ausgeführte Abfragen 82.32 ms

Abfragezeit: 1.57 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 3.826 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `nusa6_session`

  WHERE `session_id` = X'6562666638343539373939356237666162316237666337393039303066633734'

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 1.17 ms Nach letzter Abfrage: 3.92 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.928 MB Zeilen zurückgegeben: 0

SELECT `session_id`

  FROM `nusa6_session`

  WHERE `session_id` = X'6562666638343539373939356237666162316237666337393039303066633734' 
  LIMIT 1

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Abfragezeit: 6.57 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.933 MB

INSERT INTO `nusa6_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6562666638343539373939356237666162316237666337393039303066633734', 1, 1714244769, 0, '', 0)

Erklären

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

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
update	0.75 ms
end	0.02 ms
query end	4.78 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 2.56 ms Nach letzter Abfrage: 8.97 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 4.119 MB Zeilen zurückgegeben: 39

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

  FROM `nusa6_extensions`

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

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nusa6_extensions	NULL	ref	extension	extension	62	const	39	1.00	Using where

Profil (Profile)

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

Aufrufstapel (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}()	Der selbe Aufruf in der Zeile darunter.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php: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: 9.51 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.380 MB Zeilen zurückgegeben: 5

SELECT id, rules

  FROM `nusa6_viewlevels`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 1.14 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.392 MB Zeilen zurückgegeben: 0

SELECT b.id

  FROM nusa6_usergroups AS a

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

  WHERE a.id = 13

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	no matching row in const table

Profil (Profile)

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

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 2.20 ms Nach letzter Abfrage: 1.58 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.457 MB Zeilen zurückgegeben: 196

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

  FROM nusa6_extensions

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

  ORDER BY ordering

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nusa6_extensions	NULL	ref	extension	extension	62	const	218	0.40	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.97 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Der selbe Aufruf in der Zeile darunter.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 4.82 ms Nach letzter Abfrage: 55.52 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 5.962 MB Zeilen zurückgegeben: 388

SHOW TABLES

Erklären

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

Profil (Profile)

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
checking permissions	2.39 ms
Sending data	0.75 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.01 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Aufrufstapel (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:505
8	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jasocial_feed/jasocial_feed.php:93
7	plgSystemjasocial_feed->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 2.09 ms Nach letzter Abfrage: 23.65 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 6.476 MB Zeilen zurückgegeben: 0

SELECT extension_id 
  FROM nusa6_extensions 
  WHERE type = "component" 
  AND element = "com_cck_webservices"

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nusa6_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/cms/cck/database.php:132
12	JCckDatabase::loadResult()	JROOT/libraries/cms/cck/database/cache.php:74
11	JCckDatabaseCache::loadResult()	JROOT/libraries/cms/cck/webservice.php:28
10	JCckWebservice::_setConfig()	JROOT/libraries/cms/cck/webservice.php:45
9	JCckWebservice::getConfig()	JROOT/plugins/system/cck/cck.php:776
8	plgSystemCCK->_isRestApi()	JROOT/plugins/system/cck/cck.php:49
7	plgSystemCCK->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 5.56 ms Nach letzter Abfrage: 34.32 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 7.049 MB Zeilen zurückgegeben: 68

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

  LEFT JOIN nusa6_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

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	85	10.00	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	DB2760044.m.component_id	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.20 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.49 ms
init	0.08 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.04 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	2.43 ms
end	0.07 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.03 ms

Aufrufstapel (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}()	Der selbe 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:78
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:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
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:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/cck/cck.php:178
8	plgSystemCCK->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.49 ms Nach letzter Abfrage: 3.54 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 7.383 MB Zeilen zurückgegeben: 0

SELECT extension_id 
  FROM nusa6_extensions 
  WHERE type = "component" 
  AND element = "com_cck_toolbox"

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nusa6_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/libraries/cms/cck/database.php:132
11	JCckDatabase::loadResult()	JROOT/libraries/cms/cck/database/cache.php:74
10	JCckDatabaseCache::loadResult()	JROOT/libraries/cms/cck/toolbox.php:25
9	JCckToolbox::getConfig()	JROOT/plugins/system/cck/cck.php:184
8	plgSystemCCK->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.91 ms Nach letzter Abfrage: 0.52 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 7.389 MB Zeilen zurückgegeben: 3

SELECT type, scriptfile, options 
  FROM nusa6_cck_more_processings 
  WHERE published = 1 
  ORDER BY ordering

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/cck/database.php:172
11	JCckDatabase::loadObjectListArray()	JROOT/libraries/cms/cck/database/cache.php:61
10	JCckDatabaseCache::loadObjectListArray()	JROOT/libraries/cms/cck/toolbox.php:101
9	JCckToolbox::process()	JROOT/plugins/system/cck/cck.php:185
8	plgSystemCCK->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.43 ms Nach letzter Abfrage: 44.21 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 8.099 MB Zeilen zurückgegeben: 1

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

  FROM `nusa6_extensions`

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

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nusa6_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	NULL

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Der selbe Aufruf in der Zeile darunter.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/djjquerymonster/djjquerymonster.php:58
8	plgSystemDJjQueryMonster->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 3.95 ms Nach letzter Abfrage: 0.40 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 8.091 MB

UPDATE `nusa6_extensions`

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

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

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	nusa6_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.14 ms
updating	0.16 ms
end	0.03 ms
query end	2.52 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/djjquerymonster/djjquerymonster.php:58
8	plgSystemDJjQueryMonster->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 2.14 ms Nach letzter Abfrage: 7.28 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 8.268 MB Zeilen zurückgegeben: 25

SELECT id, home, template, s.params

  FROM nusa6_template_styles as s

  LEFT JOIN nusa6_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

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	62	const	9	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	152	DB2760044.e.element	3	92.59	Using index condition; Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:836
9	plgSystemEF4_JMFramework->getTemplateName()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:209
8	plgSystemEF4_JMFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.82 ms Nach letzter Abfrage: 42.05 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 9.514 MB Zeilen zurückgegeben: 1

SELECT *

  FROM nusa6_languages

  WHERE published=1

  ORDER BY ordering ASC

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 2.42 ms Nach letzter Abfrage: 23.37 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 9.977 MB Zeilen zurückgegeben: 38

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

  FROM `nusa6_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_cck','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djmediatools','com_fields','com_finder','com_installer','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_rstbox','com_search','com_securitycheckpro','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nusa6_assets	NULL	range	idx_asset_name	idx_asset_name	152	NULL	40	100.00	Using index condition

Profil (Profile)

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.41 ms
init	0.14 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.21 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.54 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Aufrufstapel (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:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 2.30 ms Nach letzter Abfrage: 0.44 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 10.032 MB Zeilen zurückgegeben: 344

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

  FROM `nusa6_assets`

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

Erklären

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

Profil (Profile)

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

Aufrufstapel (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:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 2.63 ms Nach letzter Abfrage: 5.01 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 10.441 MB Zeilen zurückgegeben: 34

SHOW FULL COLUMNS 
  FROM `nusa6_content`

Erklären

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

Profil (Profile)

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.24 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
Opening tables	0.32 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.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.38 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.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.02 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.10 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (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:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 4.14 ms Nach letzter Abfrage: 10.84 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 10.691 MB

UPDATE nusa6_content

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

  WHERE `id` = '73'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	nusa6_content	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.06 ms
updating	0.18 ms
end	0.02 ms
query end	2.55 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 3.12 ms Nach letzter Abfrage: 6.00 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 10.816 MB Zeilen zurückgegeben: 1

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

  FROM nusa6_content AS a

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

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

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

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

  WHERE a.id = 73 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-27 19:06:09') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-27 19:06:09') 
  AND (a.state = 1 OR a.state =2)

Erklären

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

Profil (Profile)

Status	Duration
starting	0.25 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
Opening tables	1.14 ms
init	0.20 ms
System lock	0.05 ms
optimizing	0.03 ms
statistics	0.25 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.03 ms

Aufrufstapel (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:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 2.11 ms Nach letzter Abfrage: 6.65 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 11.008 MB Zeilen zurückgegeben: 0

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

  FROM `nusa6_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 73 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Erklären

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

Profil (Profile)

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

Aufrufstapel (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:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 2.05 ms Nach letzter Abfrage: 48.49 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 11.875 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 `nusa6_categories` AS `s`

  INNER JOIN `nusa6_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 = 78

  ORDER BY c.lft

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	2	56.52	Using index condition; Using where

Profil (Profile)

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

Aufrufstapel (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:140
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
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:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 4.70 ms Nach letzter Abfrage: 1.86 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 11.983 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 nusa6_fields AS a

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

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

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

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

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

  LEFT JOIN `nusa6_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 (78,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

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	l	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	DB2760044.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	DB2760044.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	DB2760044.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	DB2760044.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	DB2760044.a.id	1	100.00	Using where; Using index; Distinct

Profil (Profile)

Status	Duration
starting	0.24 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.05 ms
checking permissions	0.01 ms
Opening tables	1.59 ms
init	0.17 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.33 ms
preparing	0.13 ms
Creating tmp table	0.15 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.55 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.02 ms
removing tmp table	0.19 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Aufrufstapel (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:322
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:194
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:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 3.82 ms Nach letzter Abfrage: 52.13 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 12.898 MB Zeilen zurückgegeben: 0

select b.* 
  from nusa6_rstbox b 
  where b.published = 1  
  AND b.testmode=0

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rstbox/helpers/helper.php:283
8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
7	PlgSystemRstBox->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.31 ms Nach letzter Abfrage: 60.58 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 13.158 MB Zeilen zurückgegeben: 27

SELECT id 
  FROM nusa6_template_styles 
  ORDER BY id

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nusa6_template_styles	NULL	index	NULL	PRIMARY	4	NULL	27	100.00	Using index

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:297
9	JMFTemplate->setup()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:121
8	JMFTemplate->__construct()	JROOT/templates/jm-animals/index.php:18
7	require JROOT/templates/jm-animals/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 7.06 ms Nach letzter Abfrage: 60.46 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 14.046 MB Zeilen zurückgegeben: 46

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

  FROM nusa6_modules AS m

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

  LEFT JOIN nusa6_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 <= '2024-04-27 19:06:09') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-27 19:06:09') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 520 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	84	1.60	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	DB2760044.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	DB2760044.m.id	4	40.00	Using where; Using index

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	Der selbe Aufruf in der Zeile darunter.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:444
11	JMFTemplate->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:437
10	JMFTemplate->checkModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1644
9	JMFTemplate->getAllColumnsClasses()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:174
8	JMFTemplate->__construct()	JROOT/templates/jm-animals/index.php:18
7	require JROOT/templates/jm-animals/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 5.00 ms Nach letzter Abfrage: 164.38 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.010 MB Zeilen zurückgegeben: 6

SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params

  FROM `nusa6_contentitem_tag_map` AS `m`

  INNER JOIN `nusa6_tags` AS `t` 
  ON `tag_id` = t.id

  INNER JOIN `nusa6_ucm_content` AS `c` 
  ON `m`.`core_content_id` = `c`.`core_content_id`

  WHERE `t`.`access` IN (1,1) 
  AND `t`.`published` = 1  
  AND `m`.`type_alias` = `c`.`core_type_alias` 
  AND `c`.`core_state` = 1 
  AND (`c`.`core_access` IN (1,1) OR `c`.`core_access` = 0) 
  AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2024-04-27 19:06:09') 
  AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR  `c`.`core_publish_down` >= '2024-04-27 19:06:09')

  GROUP BY `tag_id`,`title`,`access`,`alias`

  ORDER BY `count` DESC 
  LIMIT 6

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	range	PRIMARY,tag_idx,idx_access,idx_content_type	tag_idx	5	NULL	10	16.00	Using index condition; Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	m	NULL	ref	idx_tag_type,idx_core_content_id	idx_core_content_id	4	DB2760044.c.core_content_id	3	10.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	DB2760044.m.tag_id	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.28 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.94 ms
init	0.22 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.36 ms
preparing	0.12 ms
Creating tmp table	0.10 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	1.36 ms
Creating sort index	0.14 ms
end	0.02 ms
query end	0.03 ms
removing tmp table	0.17 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tags_popular/helper.php:134
14	ModTagsPopularHelper::getList()	Der selbe 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:600
11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_tags_popular/mod_tags_popular.php:22
10	include JROOT/modules/mod_tags_popular/mod_tags_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT-Tabellen:

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

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

2 × SELECT extension_id 
  FROM nusa6_extensions

1 × SELECT `data` 
  FROM `nusa6_session`

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

1 × SELECT id 
  FROM nusa6_template_styles

```
1 × select b.* 
  from nusa6_rstbox b
```

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 nusa6_fields AS a 
  LEFT JOIN `nusa6_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN nusa6_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN nusa6_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN nusa6_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN nusa6_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `nusa6_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 `nusa6_categories` AS `s` 
  INNER JOIN `nusa6_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 `m`.`tag_id`,`t`.* 
  FROM `nusa6_contentitem_tag_map` AS m  
  INNER JOIN `nusa6_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

```
1 × SELECT * 
  FROM nusa6_languages
```

1 × SELECT `session_id` 
  FROM `nusa6_session`

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

1 × SELECT type, scriptfile, options 
  FROM nusa6_cck_more_processings

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 nusa6_menu AS m 
  LEFT JOIN nusa6_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 nusa6_extensions

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

1 × SELECT id, rules 
  FROM `nusa6_viewlevels

1 × SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params 
  FROM `nusa6_contentitem_tag_map` AS `m` 
  INNER JOIN `nusa6_tags` AS `t` 
  ON `tag_id` = t.id 
  INNER JOIN `nusa6_ucm_content` AS `c` 
  ON `m`.`core_content_id` = `c`.`core_content_id`

Andere Tabellen:

1 × INSERT INTO `nusa6_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6562666638343539373939356237666162316237666337393039303066633734', 1, 1714244769, 0, '', 0

```
1 × SHOW TABLE
```

1 × UPDATE `nusa6_extensions` 
  SET `params` = '{\"mediaversion\":\"e672aed8fae618bf7d1312e7c3f100a9\"}'

1 × SHOW FULL COLUMNS 
  FROM `nusa6_content

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

Main Menu

Tags

Top1-2

Top1-3

Top3-1

Top3-2

Top3-3

Top3-4

Content-Top

Subpage

Content-Bottom

Bottom1-1

Bottom1-2

Bottom1-3

Bottom1-4

Bottom2-1

Bottom2-2

Bottom2-3

Bottom2-4

Footer-mod-1

Footer-mod-4

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

28 ausgeführte Abfragen 82.32 ms

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

SELECT-Tabellen:

Andere Tabellen: