Musikverein Ettenkirch - MVE Festschrift 2008

MVE Festschrift 2008

This is the HTML version of MVE Festschrift 2008 Page 1
To view this content in Flash, you must have version 8 or greater and Javascript must be enabled. To download the last Flash player click here

Joomla gallery extension. Powered by FlippingBook.

Blasmusikverband Badenwürttemberg

News aus dem Landkreis

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713998757,
                "last": 1713998757,
                "now": 1713998757
            },
            "token": "8S0OmpiKtgBjfeAc5E92X7XtSnXuo6fX"
        },
        "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
        }
    },
    "__easycalccheckplus": {
        "redirectUrl": null,
        "eccLoaded": null
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 13.14 ms / 13.14 ms Speicher: 2.016 MB / 2.38 MB Application: afterLoad

Zeit: 62.35 ms / 75.49 ms Speicher: 5.206 MB / 7.59 MB Application: afterInitialise

Zeit: 19.28 ms / 94.77 ms Speicher: 1.288 MB / 8.88 MB Application: afterRoute

Zeit: 6.62 ms / 101.39 ms Speicher: 0.309 MB / 9.19 MB Application: beforeRenderComponent com_flippingbook

Zeit: 44.81 ms / 146.20 ms Speicher: 0.930 MB / 10.12 MB Application: afterRenderComponent com_flippingbook

Zeit: 14.61 ms / 160.81 ms Speicher: 0.929 MB / 11.05 MB Application: afterDispatch

Zeit: 6.29 ms / 167.10 ms Speicher: 0.157 MB / 11.20 MB Application: beforeRenderModule mod_light_rss (Blasmusikverband Badenwürttemberg)

Zeit: 1173.19 ms / 1340.29 ms Speicher: 1.623 MB / 12.83 MB Application: afterRenderModule mod_light_rss (Blasmusikverband Badenwürttemberg)

Zeit: 0.05 ms / 1340.35 ms Speicher: -0.004 MB / 12.82 MB Application: beforeRenderModule mod_light_rss (News aus dem Landkreis)

Zeit: 10.32 ms / 1350.67 ms Speicher: 0.665 MB / 13.49 MB Application: afterRenderModule mod_light_rss (News aus dem Landkreis)

Zeit: 0.10 ms / 1350.77 ms Speicher: -0.004 MB / 13.48 MB Application: beforeRenderModule mod_menu (Musikkapelle)

Zeit: 14.91 ms / 1365.67 ms Speicher: 0.824 MB / 14.31 MB Application: afterRenderModule mod_menu (Musikkapelle)

Zeit: 0.06 ms / 1365.74 ms Speicher: -0.001 MB / 14.31 MB Application: beforeRenderModule mod_visitorcounter (Besucherzähler)

Zeit: 169.51 ms / 1535.25 ms Speicher: 0.107 MB / 14.41 MB Application: afterRenderModule mod_visitorcounter (Besucherzähler)

Zeit: 0.11 ms / 1535.36 ms Speicher: -0.008 MB / 14.41 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 1.28 ms / 1536.64 ms Speicher: 0.024 MB / 14.43 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 0.11 ms / 1536.74 ms Speicher: -0.001 MB / 14.43 MB Application: beforeRenderModule mod_ariimageslider (Musikkapelle Header Image Slider)

Zeit: 6.59 ms / 1543.33 ms Speicher: 0.430 MB / 14.86 MB Application: afterRenderModule mod_ariimageslider (Musikkapelle Header Image Slider)

Zeit: 0.10 ms / 1543.43 ms Speicher: -0.019 MB / 14.84 MB Application: beforeRenderModule mod_menu (Oben Kapelle)

Zeit: 0.99 ms / 1544.42 ms Speicher: 0.009 MB / 14.85 MB Application: afterRenderModule mod_menu (Oben Kapelle)

Zeit: 0.08 ms / 1544.49 ms Speicher: -0.002 MB / 14.85 MB Application: beforeRenderModule mod_menu (Top_Kapelle)

Zeit: 1.00 ms / 1545.49 ms Speicher: 0.018 MB / 14.87 MB Application: afterRenderModule mod_menu (Top_Kapelle)

Zeit: 0.04 ms / 1545.53 ms Speicher: -0.002 MB / 14.86 MB Application: beforeRenderModule mod_sr_menu (Mobile_Musikkapelle)

Zeit: 6.18 ms / 1551.72 ms Speicher: 0.076 MB / 14.94 MB Application: afterRenderModule mod_sr_menu (Mobile_Musikkapelle)

Zeit: 0.05 ms / 1551.77 ms Speicher: -0.000 MB / 14.94 MB Application: beforeRenderModule mod_smefacebooklikeboxsidebar (SME Facebook Like Box Sidebar)

Zeit: 0.31 ms / 1552.08 ms Speicher: 0.014 MB / 14.95 MB Application: afterRenderModule mod_smefacebooklikeboxsidebar (SME Facebook Like Box Sidebar)

Zeit: 16.37 ms / 1568.45 ms Speicher: 0.427 MB / 15.38 MB Application: afterRender

Datenbankabfragen gesamt: 197.06 ms

Speichernutzung

Datenbankabfragen

25 ausgeführte Abfragen 197.06 ms

2 Duplikate gefunden!

2 Duplikate: #16 #19

Abfragezeit: 0.70 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.155 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `mve3stable_session`

  WHERE `session_id` = X'6535626331623030366661626263663639333262396361623236623663336230'

Explain

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

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 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

Call Stack

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

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

Abfragezeit: 0.29 ms Nach letzter Abfrage: 1.03 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.250 MB Zeilen zurückgegeben: 0

SELECT `session_id`

  FROM `mve3stable_session`

  WHERE `session_id` = X'6535626331623030366661626263663639333262396361623236623663336230' 
  LIMIT 1

Explain

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

Profil (Profile)

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

Call Stack

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

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

Abfragezeit: 2.44 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.255 MB

INSERT INTO `mve3stable_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6535626331623030366661626263663639333262396361623236623663336230', 1, 1713998757, 0, '', 0)

Explain

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

Profil (Profile)

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.11 ms
end	0.01 ms
query end	2.07 ms
closing tables	0.02 ms
freeing items	0.02 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: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: 0.84 ms Nach letzter Abfrage: 1.90 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 4.444 MB Zeilen zurückgegeben: 43

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

  FROM `mve3stable_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mve3stable_extensions	NULL	ref	extension	extension	82	const	45	1.00	Using where

Profil (Profile)

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

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

Abfragezeit: 0.54 ms Nach letzter Abfrage: 1.92 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.713 MB Zeilen zurückgegeben: 13

SELECT id, rules

  FROM `mve3stable_viewlevels`

Explain

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

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
Sending data	0.06 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

Call Stack

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

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

Abfragezeit: 0.46 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.729 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM mve3stable_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profil (Profile)

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 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.03 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: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.68 ms Nach letzter Abfrage: 0.59 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.797 MB Zeilen zurückgegeben: 101

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

  FROM mve3stable_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mve3stable_extensions	NULL	ref	extension	extension	82	const	149	0.60	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	1.15 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

Call Stack

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

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

Abfragezeit: 3.63 ms Nach letzter Abfrage: 27.24 ms Abfragespeichernutzung: 0.096 MB Speichernutzung vor Abfrage: 7.840 MB Zeilen zurückgegeben: 69

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

  LEFT JOIN mve3stable_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	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	87	10.00	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	db478489175.m.component_id	1	100.00	Using where

Profil (Profile)

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

Call Stack

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

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

Abfragezeit: 1.05 ms Nach letzter Abfrage: 14.26 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 8.912 MB Zeilen zurückgegeben: 1

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

  FROM `mve3stable_extensions`

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

Explain

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

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.03 ms
statistics	0.16 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.04 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Call Stack

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

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

Abfragezeit: 0.70 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 8.903 MB

UPDATE `mve3stable_extensions`

  SET `params` = '{\"mediaversion\":\"90207779b5f6e0b37738db1c3ec42e31\"}'

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

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.67 ms Nach letzter Abfrage: 1.68 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 9.076 MB Zeilen zurückgegeben: 2

SELECT *

  FROM mve3stable_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

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.01 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.03 ms
Creating sort index	0.10 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

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

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

Abfragezeit: 0.92 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 9.087 MB Zeilen zurückgegeben: 5

SELECT id, home, template, s.params

  FROM mve3stable_template_styles as s

  LEFT JOIN mve3stable_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	7	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	db478489175.e.element	1	71.43	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.05 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.05 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.06 ms
cleaning up	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php: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: 25.57 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 9.738 MB Zeilen zurückgegeben: 1

SELECT * 
  FROM mve3stable_flippingbook_books 
  WHERE id = 2

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_flippingbook/models/book.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:11
15	FlippingBookModelBook->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
14	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flippingbook/views/book/view.html.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:7
13	FlippingBookViewBook->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
12	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flippingbook/controller.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:9
11	FlippingBookController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:5
9	eval()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code(1) : eval()'d code:1
8	eval()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code:1
7	eval()	JROOT/components/com_flippingbook/flippingbook.php:1
6	require_once JROOT/components/com_flippingbook/flippingbook.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.00 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.757 MB Zeilen zurückgegeben: 1

SELECT title 
  FROM mve3stable_flippingbook_categories 
  WHERE id = 1

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_flippingbook/models/book.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:16
15	FlippingBookModelBook->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
14	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flippingbook/views/book/view.html.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:7
13	FlippingBookViewBook->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
12	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flippingbook/controller.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:9
11	FlippingBookController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:5
9	eval()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code(1) : eval()'d code:1
8	eval()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code:1
7	eval()	JROOT/components/com_flippingbook/flippingbook.php:1
6	require_once JROOT/components/com_flippingbook/flippingbook.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.97 ms Nach letzter Abfrage: 2.50 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 10.011 MB Zeilen zurückgegeben: 1

SELECT * 
  FROM mve3stable_flippingbook_books 
  WHERE id=2

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_flippingbook/views/book/tmpl/default.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:24
19	eval()	JROOT/components/com_flippingbook/views/book/tmpl/default.php(1) : eval()'d code(1) : eval()'d code:1
18	eval()	JROOT/components/com_flippingbook/views/book/tmpl/default.php(1) : eval()'d code:1
17	eval()	JROOT/components/com_flippingbook/views/book/tmpl/default.php:1
16	include JROOT/components/com_flippingbook/views/book/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_flippingbook/views/book/view.html.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:14
13	FlippingBookViewBook->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
12	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flippingbook/controller.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:9
11	FlippingBookController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:5
9	eval()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code(1) : eval()'d code:1
8	eval()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code:1
7	eval()	JROOT/components/com_flippingbook/flippingbook.php:1
6	require_once JROOT/components/com_flippingbook/flippingbook.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.25 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.074 MB Speichernutzung vor Abfrage: 10.031 MB Zeilen zurückgegeben: 104

Doppelte Abfragen: #19

SELECT * 
  FROM mve3stable_flippingbook_pages 
  WHERE book_id = 2 
  AND state = 1 
  ORDER BY ordering

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_flippingbook/views/book/tmpl/default.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:27
19	eval()	JROOT/components/com_flippingbook/views/book/tmpl/default.php(1) : eval()'d code(1) : eval()'d code:1
18	eval()	JROOT/components/com_flippingbook/views/book/tmpl/default.php(1) : eval()'d code:1
17	eval()	JROOT/components/com_flippingbook/views/book/tmpl/default.php:1
16	include JROOT/components/com_flippingbook/views/book/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_flippingbook/views/book/view.html.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:14
13	FlippingBookViewBook->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
12	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flippingbook/controller.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:9
11	FlippingBookController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:5
9	eval()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code(1) : eval()'d code:1
8	eval()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code:1
7	eval()	JROOT/components/com_flippingbook/flippingbook.php:1
6	require_once JROOT/components/com_flippingbook/flippingbook.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.12 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 10.238 MB Zeilen zurückgegeben: 15

SELECT name, value 
  FROM mve3stable_flippingbook_config

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_flippingbook/views/book/tmpl/default.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:50
19	eval()	JROOT/components/com_flippingbook/views/book/tmpl/default.php(1) : eval()'d code(1) : eval()'d code:1
18	eval()	JROOT/components/com_flippingbook/views/book/tmpl/default.php(1) : eval()'d code:1
17	eval()	JROOT/components/com_flippingbook/views/book/tmpl/default.php:1
16	include JROOT/components/com_flippingbook/views/book/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_flippingbook/views/book/view.html.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:14
13	FlippingBookViewBook->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
12	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flippingbook/controller.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:9
11	FlippingBookController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:5
9	eval()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code(1) : eval()'d code:1
8	eval()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code:1
7	eval()	JROOT/components/com_flippingbook/flippingbook.php:1
6	require_once JROOT/components/com_flippingbook/flippingbook.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.19 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 10.257 MB

UPDATE mve3stable_flippingbook_books 
  SET hits=(hits+1) 
  WHERE id=2

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	mve3stable_flippingbook_books	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.04 ms
System lock	0.11 ms
updating	0.21 ms
end	0.02 ms
query end	3.49 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
20	JDatabase->query()	JROOT/components/com_flippingbook/views/book/tmpl/default.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:65
19	eval()	JROOT/components/com_flippingbook/views/book/tmpl/default.php(1) : eval()'d code(1) : eval()'d code:1
18	eval()	JROOT/components/com_flippingbook/views/book/tmpl/default.php(1) : eval()'d code:1
17	eval()	JROOT/components/com_flippingbook/views/book/tmpl/default.php:1
16	include JROOT/components/com_flippingbook/views/book/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_flippingbook/views/book/view.html.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:14
13	FlippingBookViewBook->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
12	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flippingbook/controller.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:9
11	FlippingBookController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:5
9	eval()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code(1) : eval()'d code:1
8	eval()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code:1
7	eval()	JROOT/components/com_flippingbook/flippingbook.php:1
6	require_once JROOT/components/com_flippingbook/flippingbook.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.29 ms Nach letzter Abfrage: 3.46 ms Abfragespeichernutzung: 0.074 MB Speichernutzung vor Abfrage: 10.413 MB Zeilen zurückgegeben: 104

Doppelte Abfragen: #16

SELECT * 
  FROM mve3stable_flippingbook_pages 
  WHERE book_id = 2 
  AND state = 1 
  ORDER BY ordering

Explain

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

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.01 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.02 ms
Creating sort index	0.74 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_flippingbook/views/book/tmpl/default.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:348
19	eval()	JROOT/components/com_flippingbook/views/book/tmpl/default.php(1) : eval()'d code(1) : eval()'d code:1
18	eval()	JROOT/components/com_flippingbook/views/book/tmpl/default.php(1) : eval()'d code:1
17	eval()	JROOT/components/com_flippingbook/views/book/tmpl/default.php:1
16	include JROOT/components/com_flippingbook/views/book/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_flippingbook/views/book/view.html.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:14
13	FlippingBookViewBook->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
12	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flippingbook/controller.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:9
11	FlippingBookController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code:5
9	eval()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code(1) : eval()'d code:1
8	eval()	JROOT/components/com_flippingbook/flippingbook.php(1) : eval()'d code:1
7	eval()	JROOT/components/com_flippingbook/flippingbook.php:1
6	require_once JROOT/components/com_flippingbook/flippingbook.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.93 ms Nach letzter Abfrage: 15.96 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 11.127 MB Zeilen zurückgegeben: 13

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

  FROM mve3stable_modules AS m

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

  LEFT JOIN mve3stable_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-24 22:45:57') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-24 22:45:57') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 139 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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	44	1.60	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	db478489175.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	db478489175.m.id	12	40.00	Using where; Using index

Profil (Profile)

Status	Duration
starting	0.26 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.10 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.22 ms
preparing	0.09 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	2.38 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.17 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Derselbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/a4joomla-autumn3r/index.php:5
7	require JROOT/templates/a4joomla-autumn3r/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: 32.27 ms Nach letzter Abfrage: 1201.83 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 14.401 MB Zeilen zurückgegeben: 1

SELECT count(*) 
  FROM `mve3stable_vcnt` 
  WHERE `ip` = '3.142.35.75' 
  AND (`tm` + '3600') > '1713998759'

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_visitorcounter/helper.php:105
11	ModVisitorcounterHelper->countRequest()	JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:32
10	include JROOT/modules/mod_visitorcounter/mod_visitorcounter.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]

Abfragezeit: 2.90 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 14.408 MB

INSERT INTO `mve3stable_vcnt` (`tm`, `ip`) 
  VALUES ('1713998759', '3.142.35.75')

Explain

„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `mve3stable_vcnt` (`tm`, `ip`) VALUES ('1713998759', '3.142.35.75')

Profil (Profile)

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.08 ms
end	0.00 ms
query end	2.54 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/modules/mod_visitorcounter/helper.php:111
11	ModVisitorcounterHelper->countRequest()	JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:32
10	include JROOT/modules/mod_visitorcounter/mod_visitorcounter.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]

Abfragezeit: 21.20 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 14.414 MB Zeilen zurückgegeben: 1

SELECT count(*) 
  FROM `mve3stable_vcnt` 
  WHERE `tm` < '1711238400'

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_visitorcounter/helper.php:220
11	ModVisitorcounterHelper->cleanDatabase()	JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:37
10	include JROOT/modules/mod_visitorcounter/mod_visitorcounter.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]

Abfragezeit: 1.20 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.041 MB Speichernutzung vor Abfrage: 14.420 MB Zeilen zurückgegeben: 256

SELECT `guest`, `client_id` , `username`, `userid` 
  FROM `mve3stable_session` 
  WHERE `client_id` = 0 
  AND `time` > '1713998159'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mve3stable_session	NULL	ref	time,client_id_guest	client_id_guest	2	const	397	72.60	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.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.73 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 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/modules/mod_visitorcounter/helper.php:250
11	ModVisitorcounterHelper->whoIsOnline()	JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:45
10	include JROOT/modules/mod_visitorcounter/mod_visitorcounter.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]

Abfragezeit: 108.97 ms Nach letzter Abfrage: 0.48 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 14.429 MB Zeilen zurückgegeben: 6

SELECT count(*) 
  FROM `mve3stable_vcnt` UNION ALL SELECT count(*) 
  FROM `mve3stable_vcnt` 
  WHERE `tm` > '1713916800' UNION ALL SELECT count(*) 
  FROM `mve3stable_vcnt` 
  WHERE `tm` > '1713830400' && `tm` < '1713916800' UNION ALL SELECT count(*) 
  FROM `mve3stable_vcnt` 
  WHERE `tm` >= '1713744000' UNION ALL SELECT count(*) 
  FROM `mve3stable_vcnt` 
  WHERE `tm` >= '1711929600' UNION ALL SELECT `cnt` 
  FROM `mve3stable_vcnt_pc`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	mve3stable_vcnt	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	47409	100.00	NULL
2	UNION	mve3stable_vcnt	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	47409	33.33	Using where
3	UNION	mve3stable_vcnt	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	47409	11.11	Using where
4	UNION	mve3stable_vcnt	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	47409	33.33	Using where
5	UNION	mve3stable_vcnt	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	47409	33.33	Using where
6	UNION	mve3stable_vcnt_pc	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	NULL

Profil (Profile)

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.01 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	20.05 ms
executing	0.02 ms
Sending data	21.63 ms
executing	0.02 ms
Sending data	23.80 ms
executing	0.02 ms
Sending data	21.30 ms
executing	0.01 ms
Sending data	21.61 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
12	JDatabaseDriver->loadRowList()	JROOT/modules/mod_visitorcounter/helper.php:181
11	ModVisitorcounterHelper->getData()	JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:71
10	include JROOT/modules/mod_visitorcounter/mod_visitorcounter.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]

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

SELECT-Tabellen:

2 × SELECT * 
  FROM mve3stable_flippingbook_books

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

2 × SELECT count(*) 
  FROM `mve3stable_vcnt`

2 × SELECT * 
  FROM mve3stable_flippingbook_pages

1 × SELECT `data` 
  FROM `mve3stable_session`

1 × SELECT `guest`, `client_id` , `username`, `userid` 
  FROM `mve3stable_session`

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

1 × SELECT name, value 
  FROM mve3stable_flippingbook_confi

1 × SELECT title 
  FROM mve3stable_flippingbook_categories

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

1 × SELECT `session_id` 
  FROM `mve3stable_session`

1 × SELECT * 
  FROM mve3stable_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 mve3stable_menu AS m 
  LEFT JOIN mve3stable_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 mve3stable_extensions

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

1 × SELECT id, rules 
  FROM `mve3stable_viewlevels

1 × SELECT count(*) 
  FROM `mve3stable_vcnt` UNION ALL SELECT count(*) 
  FROM `mve3stable_vcnt`

Andere Tabellen:

1 × INSERT INTO `mve3stable_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6535626331623030366661626263663639333262396361623236623663336230', 1, 1713998757, 0, '', 0

1 × UPDATE `mve3stable_extensions` 
  SET `params` = '{\"mediaversion\":\"90207779b5f6e0b37738db1c3ec42e31\"}'

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

1 × INSERT INTO `mve3stable_vcnt` (`tm`, `ip`) 
  VALUES ('1713998759', '3.142.35.75'