{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701623941,
                "last": 1701623941,
                "now": 1701623941
            },
            "token": "bpAHAN9HiX80bOIXQ08ACsN2L1yB6fpc"
        },
        "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
        }
    }
}

Zeit

Speicher

4 ausgeführte Abfragen 1.38 ms

1. Abfragezeit: 0.75 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 13.112 MB

   Update
                           kyhul_contentbuilder_articles As articles,
                           kyhul_content As content, 
                           kyhul_contentbuilder_forms As forms,
                           kyhul_contentbuilder_registered_users As cbusers,
                           kyhul_users As users
                       
     Set 
                           content.state = 0
                       
     Where 
                           articles.article_id = content.id
                       
     And
                           content.state = 1
                       
     And
                           articles.form_id = forms.id
                       
     And
                           forms.act_as_registration = 1
                       
     And
                           forms.id = cbusers.form_id
                       
     And
                           content.created_by = cbusers.user_id
                       
     And
                         (
                           (
                               users.id = cbusers.user_id
                             
     And
                               users.block = 1
                           )
                         )

   Erklären

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

   Profil (Profile)

   Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   12	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   11	JFalangDatabase->execute()	JROOT/plugins/system/falangdriver/falang_database.php:124
   10	JFalangDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:417
   9	plgSystemContentbuilder_system->onAfterInitialize()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362
   8	plgSystemContentbuilder_system->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]

   ---

2. Abfragezeit: 0.53 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 13.120 MB

   Update 
                           kyhul_contentbuilder_articles As articles,
                           kyhul_content As content, 
                           kyhul_contentbuilder_forms As forms,
                           kyhul_contentbuilder_records As records,
                           kyhul_contentbuilder_registered_users As cbusers,
                           kyhul_users As users
                       
     Set 
                           content.state = forms.auto_publish
                       
     Where 
                           articles.article_id = content.id
                       
     And
                           content.state = 0
                       
     And
                           articles.form_id = forms.id
                       
     And
                           forms.act_as_registration = 1
                       
     And
                           forms.id = cbusers.form_id
                       
     And
                           content.created_by = cbusers.user_id
                       
     And
                           users.id = cbusers.user_id
                       
     And
                           records.record_id = cbusers.record_id
                       
     And
                           records.`type` = forms.`type`
                       
     And
                           users.block = 0

   Erklären

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

   Profil (Profile)

   Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   12	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   11	JFalangDatabase->execute()	JROOT/plugins/system/falangdriver/falang_database.php:124
   10	JFalangDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:450
   9	plgSystemContentbuilder_system->onAfterInitialize()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362
   8	plgSystemContentbuilder_system->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]

   ---

3. Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.88 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 14.026 MB Zeilen zurückgegeben: 0

   Select 
                       form.id As form_id,
                       form.act_as_registration,
                       form.default_category,
                       form.registration_name_field, 
                       form.registration_username_field, 
                       form.registration_email_field, 
                       form.registration_email_repeat_field, 
                       form.`last_update`,
                       article.`article_id`,
                       form.`title_field`,
                       form.`create_articles`,
                       form.`name`,
                       form.`use_view_name_as_title`,
                       form.`protect_upload_directory`,
                       form.`reference_id`,
                       records.`record_id`,
                       form.`type`,
                       form.`published_only`,
                       form.`own_only`,
                       form.`own_only_fe`,
                       records.`last_update` As record_last_update,
                       article.`last_update` As article_last_update
                   
     From
                       kyhul_contentbuilder_records As records
                       
     Left Join kyhul_contentbuilder_forms As form 
     On ( form.`type` = records.`type` 
     And form.reference_id = records.reference_id )
                       
     Left Join kyhul_contentbuilder_articles As article 
     On ( form.`type` = records.`type` 
     And form.reference_id = records.reference_id 
     And article.form_id = form.id 
     And article.record_id = records.record_id )
                       
     Left Join kyhul_content As content 
     On ( form.`type` = records.`type` 
     And form.reference_id = records.reference_id 
     And article.article_id = content.id 
     And article.form_id = form.id 
     And article.record_id = records.record_id )
                   
     Where 
                       form.`published` = 1
                   
     And
                       form.create_articles = 1
                   
     And
                       form.`type` = records.`type`
                   
     And 
                       form.reference_id = records.reference_id
                   
     And
                      (
                        (
                           article.form_id = form.id 
                         
     And 
                           article.record_id = records.record_id
                         
     And 
                           article.article_id = content.id 
                         
     And 
                           ( content.state = 1 Or content.state = 0 )
                         
     And
                         (
                           form.`last_update` > article.`last_update`   
                          Or
                           records.`last_update` > article.`last_update`
                         )
                        )
                        Or
                        (
                           form.id Is Not Null 
     And records.id Is Not Null 
     And content.id Is Null 
     And article.id Is Null
                        )
                      )
                   
     Limit 50

   Erklären

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	form	NULL	ALL	PRIMARY,reference_id	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	6	16.67	Using where
   1	SIMPLE	records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6	reference_id	4	db139985_7.form.reference_id	3276	49.98	Using where
   1	SIMPLE	article	NULL	ref	record_id,record_id_2	record_id	12	db139985_7.records.record_id,db139985_7.form.id	1	60.00	Using where
   1	SIMPLE	content	NULL	eq_ref	PRIMARY	PRIMARY	4	db139985_7.article.article_id	1	100.00	Using where

   Profil (Profile)

   Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
   12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
   11	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
   10	JFalangDatabase->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:516
   9	plgSystemContentbuilder_system->onAfterInitialize()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362
   8	plgSystemContentbuilder_system->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]

   ---

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

SELECT-Tabellen:

1. 1 × Select                      form.id As form_id,                     form.act_as_registration,                     form.default_category,                     form.registration_name_field,                      form.registration_username_field,                      form.registration_email_field,                      form.registration_email_repeat_field,                      form.`last_update`,                     article.`article_id`,                     form.`title_field`,                     form.`create_articles`,                     form.`name`,                     form.`use_view_name_as_title`,                     form.`protect_upload_directory`,                     form.`reference_id`,                     records.`record_id`,                     form.`type`,                     form.`published_only`,                     form.`own_only`,                     form.`own_only_fe`,                     records.`last_update` As record_last_update,                     article.`last_update` As article_last_update                 
     From                     kyhul_contentbuilder_records As records                     
     Left Join kyhul_contentbuilder_forms As form 
     On ( form.`type` = records.`type` 
     And form.reference_id = records.reference_id )                     
     Left Join kyhul_contentbuilder_articles As article 
     On ( form.`type` = records.`type` 
     And form.reference_id = records.reference_id 
     And article.form_id = form.id 
     And article.record_id = records.record_id )                     
     Left Join kyhul_content As content 
     On ( form.`type` = records.`type` 
     And form.reference_id = records.reference_id 
     And article.article_id = content.id 
     And article.form_id = form.id 
     And article.record_id = records.record_id )

Andere Tabellen:

1. 1 × Update                         kyhul_contentbuilder_articles As articles,                         kyhul_content As content,                          kyhul_contentbuilder_forms As forms,                         kyhul_contentbuilder_registered_users As cbusers,                         kyhul_users As users                     
     Set                          content.state = 0

2. 1 × Update                          kyhul_contentbuilder_articles As articles,                         kyhul_content As content,                          kyhul_contentbuilder_forms As forms,                         kyhul_contentbuilder_records As records,                         kyhul_contentbuilder_registered_users As cbusers,                         kyhul_users As users                     
     Set                          content.state = forms.auto_publish