Sprecheragentur

Als Sprecheragentur für Profisprecher und Synchronsprecher arbeiten wir seit über 15 Jahren für nationale und internationale Unternehmen. Unsere Kundenliste umfasst Marken wie Ferrero, Daimler AG, VW oder Disney, aber auch kleinere Produktions- und Synchronfirmen.

In unserer Sprecheragentur werden unsere Profisprecher von uns nach strengen Kriterien ausgesucht. Alle Native Speaker sind Muttersprachler ohne Akzent und haben jahrelange Sprech-Erfahrung. Durch die Vernetzung mit Tonstudios weltweit können wir Ihnen auch seltene Sprachen anbieten. Unsere fünf Studios in Berlin sind dazu mit der neuesten Übertragungstechnik wie Source-Connect Pro, APT IP oder SessionLink Pro ausgestattet, sodass wir Profisprecher von jedem Ort der Welt live aufnehmen können. So realisieren wir Ihre mehrsprachigen Projekte schnell und unkompliziert. Dabei steht immer die beste Lösung für Ihr Projekt im Vordergrund – ob es sich um Synchronaufnahmen, E-Learnings, Werbespots, Imagefilme oder Präsentationen handelt.

Kontaktieren Sie unsere Sprecheragentur oder verschaffen Sie sich einen Einblick in unser Projekt-Portfolio. Dazu können Sie entweder im Feld „Suche“ Ihren Suchbegriff eingeben oder in der darunter stehenden Auswahl Ihre Suche eingrenzen. Es erscheinen dann Vorschläge mit Hörbeispielen.

Suche

Geschlecht

Sprache

Stimmen Alter

BIld	Name	Geschlecht	Sprache	Kategorien	Stimmenlage	Wohnort
	Alma Maja Ernst	Frau	Deutsch	Werbung,Funk TV,Imagefilm/Doku,Trick/synchron,elearning	Mittel	Berlin
	Karim Cherif	Mann	Französisch	Werbung,Funk TV,Imagefilm/Doku,Trick/synchron,elearning	Mittel	Berlin
	Karim Cherif	Mann	Deutsch	Werbung,Funk TV,Imagefilm/Doku,Trick/synchron,elearning	Mittel	Berlin
	Chris Burnett	Mann	English - Amerikanisch	Werbung,Funk TV,Imagefilm/Doku,Trick/synchron,elearning	Mittel	USA
	Douglas Welbar	Mann	Deutsch	Werbung,Funk TV,Imagefilm/Doku,Trick/synchron,elearning	Tief	Hamburg
Seite 4 von 98 Anzeige von 488 1 2 3 4 ... 6 7 8 9 10

SCROLL TO TOP

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701626702,
                "last": 1701626702,
                "now": 1701626702
            },
            "token": "6S4BRxhSyvnXQdnYA4WzNbZsQ4MbjFfE"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "de-DE"
        },
        "com_contentbuilderformsd_id": 22
    },
    "__com_contentbuilder": {
        "permissions_fe": {
            "published": true,
            "limit_edit": true,
            "limit_add": true,
            "verify_view": true,
            "verify_new": true,
            "verify_edit": true,
            "1": {
                "listaccess": true,
                "view": true
            },
            "2": {
                "listaccess": true,
                "view": true
            },
            "6": {
                "listaccess": true,
                "view": true
            },
            "8": {
                "listaccess": true,
                "view": true,
                "new": true,
                "edit": true,
                "delete": true,
                "state": true,
                "publish": true,
                "fullarticle": true,
                "language": true,
                "rating": true
            },
            "3": {
                "listaccess": true,
                "view": true
            },
            "4": {
                "listaccess": true,
                "view": true
            },
            "5": {
                "listaccess": true,
                "view": true
            },
            "7": {
                "listaccess": true,
                "view": true
            }
        }
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 21.56 ms / 21.56 ms Speicher: 2.445 MB / 2.84 MB Application: afterLoad

Zeit: 209.96 ms / 231.52 ms Speicher: 11.209 MB / 14.04 MB Application: afterInitialise

Zeit: 276.85 ms / 508.37 ms Speicher: 3.626 MB / 17.67 MB Application: afterRoute

Zeit: 0.68 ms / 509.05 ms Speicher: 0.032 MB / 17.70 MB Application: beforeRenderComponent com_contentbuilder

Zeit: 72.86 ms / 581.91 ms Speicher: 4.365 MB / 22.07 MB Application: afterRenderComponent com_contentbuilder

Zeit: 0.87 ms / 582.78 ms Speicher: 0.007 MB / 22.07 MB Application: afterDispatch

Zeit: 5.01 ms / 587.79 ms Speicher: 0.552 MB / 22.63 MB Application: beforeRenderModule mod_menu (Unsere Leistungen)

Zeit: 2.34 ms / 590.12 ms Speicher: 0.089 MB / 22.72 MB Application: afterRenderModule mod_menu (Unsere Leistungen)

Zeit: 0.49 ms / 590.62 ms Speicher: -0.078 MB / 22.64 MB Application: beforeRenderModule mod_custom (Kontakt Media)

Zeit: 3.65 ms / 594.26 ms Speicher: 0.468 MB / 23.11 MB Application: afterRenderModule mod_custom (Kontakt Media)

Zeit: 0.42 ms / 594.69 ms Speicher: 0.000 MB / 23.11 MB Application: beforeRenderModule mod_custom (Kontakt Synchron)

Zeit: 0.69 ms / 595.38 ms Speicher: 0.004 MB / 23.11 MB Application: afterRenderModule mod_custom (Kontakt Synchron)

Zeit: 0.20 ms / 595.57 ms Speicher: -0.019 MB / 23.09 MB Application: beforeRenderModule mod_custom (Sprechersuche Extra Module)

Zeit: 12.01 ms / 607.58 ms Speicher: 0.620 MB / 23.71 MB Application: beforeRenderModule mod_contentbuilder_list_filter (Sprechersuche de)

Zeit: 2.94 ms / 610.52 ms Speicher: 0.076 MB / 23.79 MB Application: afterRenderModule mod_contentbuilder_list_filter (Sprechersuche de)

Zeit: 34.29 ms / 644.82 ms Speicher: 1.092 MB / 24.88 MB Application: afterRenderModule mod_custom (Sprechersuche Extra Module)

Zeit: 0.31 ms / 645.13 ms Speicher: -0.000 MB / 24.88 MB Application: beforeRenderModule mod_falang (FaLang Language Switcher)

Zeit: 10.46 ms / 655.59 ms Speicher: 0.875 MB / 25.75 MB Application: afterRenderModule mod_falang (FaLang Language Switcher)

Zeit: 13.10 ms / 668.70 ms Speicher: 0.197 MB / 25.95 MB Application: afterRender

Datenbankabfragen gesamt: 320.48 ms

Speichernutzung

Datenbankabfragen

81 ausgeführte Abfragen 320.48 ms

12 Duplikate gefunden!

2 Duplikate: #7 #34

2 Duplikate: #8 #35

2 Duplikate: #41 #62

2 Duplikate: #64 #66

4 Duplikate: #70 #72 #74 #76

Abfragezeit: 1.35 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 13.114 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]

Abfragezeit: 0.40 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 13.123 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]

Abfragezeit: 0.14 ms Nach letzter Abfrage: 1.18 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 14.028 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]

Abfragezeit: 0.79 ms Nach letzter Abfrage: 11.98 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 16.442 MB Zeilen zurückgegeben: 2

SHOW FULL COLUMNS 
  FROM `kyhul_komento_configs`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
18	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_komento/tables/parent.php:18
14	KomentoParentTable->__construct()	JROOT/administrator/components/com_komento/tables/configs.php:40
13	KomentoTableConfigs->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_komento/tables/parent.php:49
11	KomentoParentTable::getInstance()	JROOT/components/com_komento/helpers/helper.php:99
10	Komento::getTable()	JROOT/components/com_komento/helpers/helper.php:228
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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: 0.10 ms Nach letzter Abfrage: 0.79 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 16.461 MB Zeilen zurückgegeben: 1

SELECT *

  FROM kyhul_komento_configs

  WHERE `component` = 'com_komento'

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
13	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
12	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
11	JFalangDatabase->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_komento/helpers/helper.php:229
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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: 0.35 ms Nach letzter Abfrage: 11.99 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 17.514 MB Zeilen zurückgegeben: 6

Select `type`, `reference_id` 
  From kyhul_contentbuilder_forms 
  Where published = 1

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
12	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
10	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
9	JFalangDatabase->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:236
8	plgSystemContentbuilder_system->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: 0.15 ms Nach letzter Abfrage: 0.48 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 17.526 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #34

Select * 
  From kyhul_contentbuilder_storages 
  Where id = 4 
  And published = 1 
  Order By `ordering`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
11	JFalangDatabase->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:26
10	contentbuilder_com_contentbuilder->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
9	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:241
8	plgSystemContentbuilder_system->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: 0.10 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 17.533 MB Zeilen zurückgegeben: 12

Doppelte Abfragen: #35

Select * 
  From kyhul_contentbuilder_storage_fields 
  Where storage_id = 4 
  And published = 1 
  Order By `ordering`

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kyhul_contentbuilder_storage_fields	NULL	ref	storage_id	storage_id	4	const	12	10.00	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
11	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:32
10	contentbuilder_com_contentbuilder->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
9	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:241
8	plgSystemContentbuilder_system->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: 0.10 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 17.550 MB Zeilen zurückgegeben: 0

Select r.id
                
                
  From 
                
                kyhul_sprecher_de As r
                
                
  Where r.id Not In (
                    Select record_id 
  From kyhul_contentbuilder_records As cr 
  Where cr.`type` = 'com_contentbuilder' 
  And cr.reference_id = '4' 
  And cr.record_id = r.id
                )

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	r	NULL	index	NULL	PRIMARY	4	NULL	488	100.00	Using where; Using index
2	DEPENDENT SUBQUERY	cr	NULL	ref	record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6	record_id	8	db139985_7.r.id	1	5.00	Using index condition; 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:178
10	JFalangDatabase->loadColumn()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:56
9	contentbuilder_com_contentbuilder->synchRecords()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:243
8	plgSystemContentbuilder_system->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: 0.10 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 17.558 MB Zeilen zurückgegeben: 1

Select * 
  From kyhul_contentbuilder_storages 
  Where id = 5 
  And published = 1 
  Order By `ordering`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
11	JFalangDatabase->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:26
10	contentbuilder_com_contentbuilder->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
9	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:241
8	plgSystemContentbuilder_system->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: 0.09 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 17.565 MB Zeilen zurückgegeben: 12

Select * 
  From kyhul_contentbuilder_storage_fields 
  Where storage_id = 5 
  And published = 1 
  Order By `ordering`

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kyhul_contentbuilder_storage_fields	NULL	ref	storage_id	storage_id	4	const	12	10.00	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
11	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:32
10	contentbuilder_com_contentbuilder->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
9	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:241
8	plgSystemContentbuilder_system->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: 0.08 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 17.571 MB Zeilen zurückgegeben: 0

Select r.id
                
                
  From 
                
                kyhul_sprecher_en As r
                
                
  Where r.id Not In (
                    Select record_id 
  From kyhul_contentbuilder_records As cr 
  Where cr.`type` = 'com_contentbuilder' 
  And cr.reference_id = '5' 
  And cr.record_id = r.id
                )

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	r	NULL	index	NULL	PRIMARY	4	NULL	490	100.00	Using where; Using index
2	DEPENDENT SUBQUERY	cr	NULL	ref	record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6	record_id	8	db139985_7.r.id	1	5.00	Using index condition; 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:178
10	JFalangDatabase->loadColumn()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:56
9	contentbuilder_com_contentbuilder->synchRecords()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:243
8	plgSystemContentbuilder_system->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: 0.09 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 17.577 MB Zeilen zurückgegeben: 1

Select * 
  From kyhul_contentbuilder_storages 
  Where id = 6 
  And published = 1 
  Order By `ordering`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
11	JFalangDatabase->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:26
10	contentbuilder_com_contentbuilder->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
9	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:241
8	plgSystemContentbuilder_system->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: 0.10 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 17.584 MB Zeilen zurückgegeben: 11

Select * 
  From kyhul_contentbuilder_storage_fields 
  Where storage_id = 6 
  And published = 1 
  Order By `ordering`

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kyhul_contentbuilder_storage_fields	NULL	ref	storage_id	storage_id	4	const	10	10.00	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
11	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:32
10	contentbuilder_com_contentbuilder->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
9	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:241
8	plgSystemContentbuilder_system->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: 0.09 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 17.589 MB Zeilen zurückgegeben: 0

Select r.id
                
                
  From 
                
                kyhul_sprecher_fr As r
                
                
  Where r.id Not In (
                    Select record_id 
  From kyhul_contentbuilder_records As cr 
  Where cr.`type` = 'com_contentbuilder' 
  And cr.reference_id = '6' 
  And cr.record_id = r.id
                )

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	NULL	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
2	DEPENDENT SUBQUERY	cr	NULL	index_merge	record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6	reference_id,record_id	4,8	NULL	1	6.77	Using intersect(reference_id,record_id); 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:178
10	JFalangDatabase->loadColumn()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:56
9	contentbuilder_com_contentbuilder->synchRecords()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:243
8	plgSystemContentbuilder_system->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: 0.07 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 17.595 MB Zeilen zurückgegeben: 1

Select * 
  From kyhul_contentbuilder_storages 
  Where id = 7 
  And published = 1 
  Order By `ordering`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
11	JFalangDatabase->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:26
10	contentbuilder_com_contentbuilder->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
9	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:241
8	plgSystemContentbuilder_system->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: 0.08 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 17.604 MB Zeilen zurückgegeben: 11

Select * 
  From kyhul_contentbuilder_storage_fields 
  Where storage_id = 7 
  And published = 1 
  Order By `ordering`

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kyhul_contentbuilder_storage_fields	NULL	ref	storage_id	storage_id	4	const	11	10.00	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
11	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:32
10	contentbuilder_com_contentbuilder->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
9	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:241
8	plgSystemContentbuilder_system->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: 0.09 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 17.611 MB Zeilen zurückgegeben: 0

Select r.id
                
                
  From 
                
                kyhul_sprecher_es As r
                
                
  Where r.id Not In (
                    Select record_id 
  From kyhul_contentbuilder_records As cr 
  Where cr.`type` = 'com_contentbuilder' 
  And cr.reference_id = '7' 
  And cr.record_id = r.id
                )

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	NULL	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
2	DEPENDENT SUBQUERY	cr	NULL	index_merge	record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6	reference_id,record_id	4,8	NULL	1	6.77	Using intersect(reference_id,record_id); 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:178
10	JFalangDatabase->loadColumn()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:56
9	contentbuilder_com_contentbuilder->synchRecords()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:243
8	plgSystemContentbuilder_system->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: 0.09 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 17.617 MB Zeilen zurückgegeben: 1

Select * 
  From kyhul_contentbuilder_storages 
  Where id = 8 
  And published = 1 
  Order By `ordering`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
11	JFalangDatabase->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:26
10	contentbuilder_com_contentbuilder->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
9	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:241
8	plgSystemContentbuilder_system->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: 0.10 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 17.624 MB Zeilen zurückgegeben: 11

Select * 
  From kyhul_contentbuilder_storage_fields 
  Where storage_id = 8 
  And published = 1 
  Order By `ordering`

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kyhul_contentbuilder_storage_fields	NULL	ref	storage_id	storage_id	4	const	11	10.00	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
11	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:32
10	contentbuilder_com_contentbuilder->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
9	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:241
8	plgSystemContentbuilder_system->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: 0.15 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 17.631 MB Zeilen zurückgegeben: 0

Select r.id
                
                
  From 
                
                kyhul_sprecher_it As r
                
                
  Where r.id Not In (
                    Select record_id 
  From kyhul_contentbuilder_records As cr 
  Where cr.`type` = 'com_contentbuilder' 
  And cr.reference_id = '8' 
  And cr.record_id = r.id
                )

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	NULL	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
2	DEPENDENT SUBQUERY	cr	NULL	index_merge	record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6	reference_id,record_id	4,8	NULL	1	6.77	Using intersect(reference_id,record_id); 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:178
10	JFalangDatabase->loadColumn()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:56
9	contentbuilder_com_contentbuilder->synchRecords()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:243
8	plgSystemContentbuilder_system->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: 0.08 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 17.637 MB Zeilen zurückgegeben: 1

Select * 
  From kyhul_contentbuilder_storages 
  Where id = 9 
  And published = 1 
  Order By `ordering`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
11	JFalangDatabase->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:26
10	contentbuilder_com_contentbuilder->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
9	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:241
8	plgSystemContentbuilder_system->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: 0.08 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 17.644 MB Zeilen zurückgegeben: 7

Select * 
  From kyhul_contentbuilder_storage_fields 
  Where storage_id = 9 
  And published = 1 
  Order By `ordering`

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kyhul_contentbuilder_storage_fields	NULL	ref	storage_id	storage_id	4	const	7	10.00	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
11	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:32
10	contentbuilder_com_contentbuilder->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
9	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:241
8	plgSystemContentbuilder_system->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: 0.09 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 17.647 MB Zeilen zurückgegeben: 0

Select r.id
                
                
  From 
                
                kyhul_sprechergame As r
                
                
  Where r.id Not In (
                    Select record_id 
  From kyhul_contentbuilder_records As cr 
  Where cr.`type` = 'com_contentbuilder' 
  And cr.reference_id = '9' 
  And cr.record_id = r.id
                )

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	r	NULL	index	NULL	PRIMARY	4	NULL	36	100.00	Using where; Using index
2	DEPENDENT SUBQUERY	cr	NULL	ref	record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6	record_id	8	db139985_7.r.id	1	5.00	Using index condition; 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:178
10	JFalangDatabase->loadColumn()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:56
9	contentbuilder_com_contentbuilder->synchRecords()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:243
8	plgSystemContentbuilder_system->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: 124.98 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 17.653 MB

Update kyhul_contentbuilder_records 
  Set published = 1 
  Where is_future = 1 
  And publish_up <> '0000-00-00 00:00:00' 
  And publish_up <= '2023-12-03 18:05:02'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	kyhul_contentbuilder_records	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	26220	100.00	Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
10	JFalangDatabase->execute()	JROOT/plugins/system/falangdriver/falang_database.php:124
9	JFalangDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:256
8	plgSystemContentbuilder_system->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: 121.66 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 17.658 MB

Update kyhul_contentbuilder_records 
  Set published = 0 
  Where publish_down <> '0000-00-00 00:00:00' 
  And publish_down <= '2023-12-03 18:05:02'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	kyhul_contentbuilder_records	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	26220	100.00	Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
10	JFalangDatabase->execute()	JROOT/plugins/system/falangdriver/falang_database.php:124
9	JFalangDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:259
8	plgSystemContentbuilder_system->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: 0.36 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 17.665 MB

Update 
                        kyhul_contentbuilder_records As records,
                        kyhul_contentbuilder_forms As forms,
                        kyhul_contentbuilder_registered_users As cbusers,
                        kyhul_users As users
                    
  Set 
                        records.published = 0
                    
  Where
                        records.reference_id = forms.reference_id
                    
  And
                        records.published = 1
                    
  And
                        records.`type` = forms.`type`
                    
  And
                        forms.act_as_registration = 1
                    
  And
                        forms.id = cbusers.form_id
                    
  And
                        records.record_id = cbusers.record_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
11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
10	JFalangDatabase->execute()	JROOT/plugins/system/falangdriver/falang_database.php:124
9	JFalangDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:329
8	plgSystemContentbuilder_system->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: 0.17 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 17.671 MB

Update 
                        kyhul_contentbuilder_records As records,
                        kyhul_contentbuilder_forms As forms,
                        kyhul_contentbuilder_registered_users As cbusers,
                        kyhul_users As users
                    
  Set 
                        records.published = forms.auto_publish
                    
  Where
                        records.reference_id = forms.reference_id
                    
  And
                        records.published = 0
                    
  And
                        records.`type` = forms.`type`
                    
  And
                        forms.act_as_registration = 1
                    
  And
                        forms.id = cbusers.form_id
                    
  And
                        records.record_id = cbusers.record_id
                    
  And
                        users.id = cbusers.user_id
                    
  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
11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
10	JFalangDatabase->execute()	JROOT/plugins/system/falangdriver/falang_database.php:124
9	JFalangDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:356
8	plgSystemContentbuilder_system->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: 0.41 ms Nach letzter Abfrage: 3.77 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 18.280 MB Zeilen zurückgegeben: 1

Select `type`, `reference_id` 
  From kyhul_contentbuilder_forms 
  Where id = 22 
  And published = 1

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
11	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
10	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
9	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:2677
8	contentbuilder::setPermissions()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:23
7	ContentbuilderControllerList->__construct()	JROOT/components/com_contentbuilder/contentbuilder.php:167
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.32 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 18.287 MB Zeilen zurückgegeben: 1

Select `name`,`bytable` 
  From kyhul_contentbuilder_storages 
  Where id = 4

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
12	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
11	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
10	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:76
9	contentbuilder_com_contentbuilder::getNumRecordsQuery()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:2688
8	contentbuilder::setPermissions()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:23
7	ContentbuilderControllerList->__construct()	JROOT/components/com_contentbuilder/contentbuilder.php:167
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.61 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 18.298 MB Zeilen zurückgegeben: 1

Select 
                forms.config,
                forms.verification_required_view,
                forms.verification_required_new,
                forms.verification_required_edit,
                forms.verification_days_view,
                forms.verification_days_new,
                forms.verification_days_edit,
                forms.verification_url_view,
                forms.verification_url_new,
                forms.verification_url_edit,
                contentbuilder_users.userid,
                forms.limit_add,
                forms.limit_edit,
                (Select count(id) 
  From kyhul_sprecher_de 
  Where user_id = 0)  As amount_records,
                contentbuilder_users.verified_view,
                contentbuilder_users.verified_new,
                contentbuilder_users.verified_edit,
                contentbuilder_users.verification_date_view,
                contentbuilder_users.verification_date_new,
                contentbuilder_users.verification_date_edit,
                contentbuilder_users.limit_add As user_limit_add,
                contentbuilder_users.limit_edit As user_limit_edit,
                contentbuilder_users.published
                ,'0' As edited
            
  From 
                kyhul_contentbuilder_forms As forms
                
  Left Join 
                    kyhul_contentbuilder_users As contentbuilder_users
                
  On ( contentbuilder_users.form_id = forms.id 
  And contentbuilder_users.userid = 0 )
                
            
  Where 
                forms.id = 22
            
  And
                forms.published = 1

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	contentbuilder_users	NULL	system	userid	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	0	0.00	const row not found
1	PRIMARY	forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
2	SUBQUERY	kyhul_sprecher_de	NULL	ref	user_id	user_id	4	const	1	100.00	NULL

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
11	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
10	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
9	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:2759
8	contentbuilder::setPermissions()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:23
7	ContentbuilderControllerList->__construct()	JROOT/components/com_contentbuilder/contentbuilder.php:167
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.53 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.316 MB Zeilen zurückgegeben: 8

Select id 
  From kyhul_usergroups

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kyhul_usergroups	NULL	index	NULL	idx_usergroup_adjacency_lookup	4	NULL	8	100.00	Using index

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
12	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
10	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
9	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:3146
8	contentbuilder::setPermissions()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:23
7	ContentbuilderControllerList->__construct()	JROOT/components/com_contentbuilder/contentbuilder.php:167
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.71 ms Nach letzter Abfrage: 2.36 ms Abfragespeichernutzung: 0.089 MB Speichernutzung vor Abfrage: 18.799 MB Zeilen zurückgegeben: 1

Select SQL_CALC_FOUND_ROWS * 
  From kyhul_contentbuilder_forms 
  Where id = 22 
  And published = 1 
  LIMIT 0, 1

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_contentbuilder/models/list.php:230
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.08 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 18.827 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #7

Select * 
  From kyhul_contentbuilder_storages 
  Where id = 4 
  And published = 1 
  Order By `ordering`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
15	JFalangDatabase->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:26
14	contentbuilder_com_contentbuilder->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
13	contentbuilder::getForm()	JROOT/administrator/components/com_contentbuilder/models/list.php:256
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.06 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 18.837 MB Zeilen zurückgegeben: 12

Doppelte Abfragen: #8

Select * 
  From kyhul_contentbuilder_storage_fields 
  Where storage_id = 4 
  And published = 1 
  Order By `ordering`

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kyhul_contentbuilder_storage_fields	NULL	ref	storage_id	storage_id	4	const	12	10.00	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
15	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:32
14	contentbuilder_com_contentbuilder->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
13	contentbuilder::getForm()	JROOT/administrator/components/com_contentbuilder/models/list.php:256
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.60 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 18.852 MB Zeilen zurückgegeben: 12

Select reference_id 
  From kyhul_contentbuilder_elements 
  Where search_include = 1 
  And published = 1 
  And form_id = 22

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kyhul_contentbuilder_elements	NULL	ref	form_id	form_id	4	const	12	1.56	Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:178
14	JFalangDatabase->loadColumn()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1026
13	contentbuilder::getListSearchableElements()	JROOT/administrator/components/com_contentbuilder/models/list.php:519
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.23 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 18.862 MB Zeilen zurückgegeben: 0

Select reference_id 
  From kyhul_contentbuilder_elements 
  Where linkable = 1 
  And published = 1 
  And form_id = 22

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kyhul_contentbuilder_elements	NULL	ref	form_id	form_id	4	const	12	1.56	Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:178
14	JFalangDatabase->loadColumn()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1038
13	contentbuilder::getListLinkableElements()	JROOT/administrator/components/com_contentbuilder/models/list.php:521
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.34 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 18.870 MB Zeilen zurückgegeben: 8

Select Distinct `id`,`label`, reference_id, `order_type` 
  From kyhul_contentbuilder_elements 
  Where form_id = 22 
  And reference_id In ('29','30','31','32','33','34','35','36','37','38','79','91') 
  And published = 1 
  And list_include = 1 
  Order By ordering

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kyhul_contentbuilder_elements	NULL	range	reference_id,form_id	form_id	8	NULL	12	1.56	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
13	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_contentbuilder/models/list.php:526
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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: 20.79 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 18.888 MB Zeilen zurückgegeben: 5

Select
                SQL_CALC_FOUND_ROWS
                joined_records.published As colPublished,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum,
                joined_records.rand_date As colRand,
                r.id As colRecord,
                r.`Avatar` As `col38`,r.`Name` As `col29`,r.`H__rbeispiel` As `col30`,r.`Geschlecht` As `col31`,r.`Sprache` As `col32`,r.`Kategorien` As `col33`,r.`Stimmenlage` As `col34`,r.`Wohnort` As `col37`,r.`Stimmen_Alte` As `col35`,r.`Beschreibung` As `col36`,r.`Avatar_Filename` As `col79`,r.`Stimme_von` As `col91`,
                joined_articles.article_id As colArticleId,
                r.created_by As colAuthor,
                r.modified_by As colModifiedBy
            
  From
                (
                    kyhul_sprecher_de As r,
                    kyhul_contentbuilder_records As joined_records
                )
                
                
  Left Join (
                    kyhul_contentbuilder_articles As joined_articles,
                    kyhul_contentbuilder_forms As forms,
                    kyhul_content As content
                ) 
  On (
                    joined_articles.`type` = 'com_contentbuilder' 
  And
                    joined_articles.reference_id = 4 
  And
                    joined_records.reference_id = joined_articles.reference_id 
  And
                    joined_records.record_id = joined_articles.record_id 
  And
                    joined_records.`type` = joined_articles.`type` 
  And
                    joined_articles.form_id = forms.id 
  And
                    joined_articles.article_id = content.id 
  And
                    (content.state = 1 Or content.state = 0)
                )
                
                
                
                
  Where
                
                
                
                
                joined_records.reference_id = r.storage_id 
  And
                joined_records.record_id = r.id 
  And
                joined_records.`type` = 'com_contentbuilder'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
                
                
            
        
  Group By r.id    
  Order By colRecord   desc 
  LIMIT 15, 5

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	ALL	PRIMARY,storage_id	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	488	100.00	Using temporary; filesort wurde genutzt
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6	record_id	8	db139985_7.r.id	1	5.00	Using index condition; Using where
1	SIMPLE	joined_articles	NULL	ref	record_id,article_id,record_id_2,type	record_id	8	db139985_7.joined_records.record_id	2	100.00	Using where
1	SIMPLE	forms	NULL	eq_ref	PRIMARY	PRIMARY	4	db139985_7.joined_articles.form_id	1	100.00	Using index
1	SIMPLE	content	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	db139985_7.joined_articles.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
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:553
13	contentbuilder_com_contentbuilder->getListRecords()	JROOT/administrator/components/com_contentbuilder/models/list.php:551
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.14 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 18.904 MB Zeilen zurückgegeben: 1

SELECT FOUND_ROWS();

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 tables used

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
14	JFalangDatabase->loadResult()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:557
13	contentbuilder_com_contentbuilder->getListRecords()	JROOT/administrator/components/com_contentbuilder/models/list.php:551
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.50 ms Nach letzter Abfrage: 0.44 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 18.918 MB Zeilen zurückgegeben: 31

Doppelte Abfragen: #62

SHOW FULL COLUMNS 
  FROM `kyhul_content`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
15	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:453
13	contentbuilder::applyItemWrappers()	JROOT/administrator/components/com_contentbuilder/models/list.php:557
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.82 ms Nach letzter Abfrage: 1.62 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 18.968 MB Zeilen zurückgegeben: 12

Select reference_id, item_wrapper, wordwrap, `label`, `options` 
  From kyhul_contentbuilder_elements 
  Where published = 1 
  And form_id = 22

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kyhul_contentbuilder_elements	NULL	ref	form_id	form_id	4	const	12	10.00	Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
14	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:472
13	contentbuilder::applyItemWrappers()	JROOT/administrator/components/com_contentbuilder/models/list.php:557
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.81 ms Nach letzter Abfrage: 5.75 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 20.409 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 kyhul_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  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 index condition; Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	db139985_7.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	db139985_7.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	db139985_7.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	db139985_7.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	db139985_7.a.group_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
24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:513
13	contentbuilder::applyItemWrappers()	JROOT/administrator/components/com_contentbuilder/models/list.php:557
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.12 ms Nach letzter Abfrage: 1.82 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 20.446 MB Zeilen zurückgegeben: 0

SELECT r.*

  FROM kyhul_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'articles')

  ORDER BY r.ordering, r.id

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/rereplacer/src/Items.php:45
20	RegularLabs\Plugin\System\ReReplacer\Items::getItemList()	JROOT/plugins/system/rereplacer/src/Helper.php:27
19	RegularLabs\Plugin\System\ReReplacer\Helper->onContentPrepare()	Der selbe Aufruf in der Zeile darunter.
18	call_user_func_array()	JROOT/plugins/system/rereplacer/src/Plugin.php:97
17	RegularLabs\Plugin\System\ReReplacer\Plugin->run()	JROOT/plugins/system/rereplacer/rereplacer.php:67
16	PlgSystemReReplacer->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:513
13	contentbuilder::applyItemWrappers()	JROOT/administrator/components/com_contentbuilder/models/list.php:557
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.71 ms Nach letzter Abfrage: 7.14 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 21.423 MB Zeilen zurückgegeben: 1

Select
                r.`Name` As `col29Value`,r.`H__rbeispiel` As `col30Value`,r.`Geschlecht` As `col31Value`,r.`Sprache` As `col32Value`,r.`Kategorien` As `col33Value`,r.`Stimmenlage` As `col34Value`,r.`Stimmen_Alte` As `col35Value`,r.`Beschreibung` As `col36Value`,r.`Wohnort` As `col37Value`,r.`Avatar` As `col38Value`,r.`Avatar_Filename` As `col79Value`,r.`Stimme_von` As `col91Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                kyhul_sprecher_de As r
                 
  Left Join kyhul_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_contentbuilder' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.storage_id ) 
                
            
  Where
                r.id = '520' 
  And
                joined_records.`type` = 'com_contentbuilder'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.storage_id = 4

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY,storage_id	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6	record_id	8	const	3	1.67	Using index condition; Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
18	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:219
17	contentbuilder_com_contentbuilder->getRecord()	JROOT/plugins/content/contentbuilder_rating/contentbuilder_rating.php:162
16	plgContentContentbuilder_rating->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:513
13	contentbuilder::applyItemWrappers()	JROOT/administrator/components/com_contentbuilder/models/list.php:557
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.46 ms Nach letzter Abfrage: 1.32 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 21.463 MB Zeilen zurückgegeben: 1

Select
                r.`Name` As `col29Value`,r.`H__rbeispiel` As `col30Value`,r.`Geschlecht` As `col31Value`,r.`Sprache` As `col32Value`,r.`Kategorien` As `col33Value`,r.`Stimmenlage` As `col34Value`,r.`Stimmen_Alte` As `col35Value`,r.`Beschreibung` As `col36Value`,r.`Wohnort` As `col37Value`,r.`Avatar` As `col38Value`,r.`Avatar_Filename` As `col79Value`,r.`Stimme_von` As `col91Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                kyhul_sprecher_de As r
                 
  Left Join kyhul_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_contentbuilder' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.storage_id ) 
                
            
  Where
                r.id = '519' 
  And
                joined_records.`type` = 'com_contentbuilder'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.storage_id = 4

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY,storage_id	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6	record_id	8	const	2	2.50	Using index condition; Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
18	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:219
17	contentbuilder_com_contentbuilder->getRecord()	JROOT/plugins/content/contentbuilder_rating/contentbuilder_rating.php:162
16	plgContentContentbuilder_rating->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:513
13	contentbuilder::applyItemWrappers()	JROOT/administrator/components/com_contentbuilder/models/list.php:557
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.57 ms Nach letzter Abfrage: 0.68 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 21.476 MB Zeilen zurückgegeben: 1

Select
                r.`Name` As `col29Value`,r.`H__rbeispiel` As `col30Value`,r.`Geschlecht` As `col31Value`,r.`Sprache` As `col32Value`,r.`Kategorien` As `col33Value`,r.`Stimmenlage` As `col34Value`,r.`Stimmen_Alte` As `col35Value`,r.`Beschreibung` As `col36Value`,r.`Wohnort` As `col37Value`,r.`Avatar` As `col38Value`,r.`Avatar_Filename` As `col79Value`,r.`Stimme_von` As `col91Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                kyhul_sprecher_de As r
                 
  Left Join kyhul_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_contentbuilder' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.storage_id ) 
                
            
  Where
                r.id = '518' 
  And
                joined_records.`type` = 'com_contentbuilder'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.storage_id = 4

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY,storage_id	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6	record_id	8	const	3	1.67	Using index condition; Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
18	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:219
17	contentbuilder_com_contentbuilder->getRecord()	JROOT/plugins/content/contentbuilder_rating/contentbuilder_rating.php:162
16	plgContentContentbuilder_rating->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:513
13	contentbuilder::applyItemWrappers()	JROOT/administrator/components/com_contentbuilder/models/list.php:557
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.59 ms Nach letzter Abfrage: 0.67 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 21.490 MB Zeilen zurückgegeben: 1

Select
                r.`Name` As `col29Value`,r.`H__rbeispiel` As `col30Value`,r.`Geschlecht` As `col31Value`,r.`Sprache` As `col32Value`,r.`Kategorien` As `col33Value`,r.`Stimmenlage` As `col34Value`,r.`Stimmen_Alte` As `col35Value`,r.`Beschreibung` As `col36Value`,r.`Wohnort` As `col37Value`,r.`Avatar` As `col38Value`,r.`Avatar_Filename` As `col79Value`,r.`Stimme_von` As `col91Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                kyhul_sprecher_de As r
                 
  Left Join kyhul_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_contentbuilder' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.storage_id ) 
                
            
  Where
                r.id = '517' 
  And
                joined_records.`type` = 'com_contentbuilder'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.storage_id = 4

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY,storage_id	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6	record_id	8	const	2	2.50	Using index condition; Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
18	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:219
17	contentbuilder_com_contentbuilder->getRecord()	JROOT/plugins/content/contentbuilder_rating/contentbuilder_rating.php:162
16	plgContentContentbuilder_rating->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:513
13	contentbuilder::applyItemWrappers()	JROOT/administrator/components/com_contentbuilder/models/list.php:557
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.48 ms Nach letzter Abfrage: 0.64 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 21.503 MB Zeilen zurückgegeben: 1

Select
                r.`Name` As `col29Value`,r.`H__rbeispiel` As `col30Value`,r.`Geschlecht` As `col31Value`,r.`Sprache` As `col32Value`,r.`Kategorien` As `col33Value`,r.`Stimmenlage` As `col34Value`,r.`Stimmen_Alte` As `col35Value`,r.`Beschreibung` As `col36Value`,r.`Wohnort` As `col37Value`,r.`Avatar` As `col38Value`,r.`Avatar_Filename` As `col79Value`,r.`Stimme_von` As `col91Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                kyhul_sprecher_de As r
                 
  Left Join kyhul_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_contentbuilder' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.storage_id ) 
                
            
  Where
                r.id = '516' 
  And
                joined_records.`type` = 'com_contentbuilder'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.storage_id = 4

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY,storage_id	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6	record_id	8	const	2	2.50	Using index condition; Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
18	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:219
17	contentbuilder_com_contentbuilder->getRecord()	JROOT/plugins/content/contentbuilder_rating/contentbuilder_rating.php:162
16	plgContentContentbuilder_rating->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:513
13	contentbuilder::applyItemWrappers()	JROOT/administrator/components/com_contentbuilder/models/list.php:557
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.78 ms Nach letzter Abfrage: 0.75 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 21.505 MB Zeilen zurückgegeben: 3

Select * 
  From kyhul_contentbuilder_list_states 
  where form_id = 22 
  And published = 1 
  Order By id

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
14	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:3543
13	contentbuilder::getListStates()	JROOT/administrator/components/com_contentbuilder/models/list.php:565
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.57 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 21.520 MB Zeilen zurückgegeben: 5

Select lang_code 
  From kyhul_languages 
  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	kyhul_languages	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	5	20.00	Using where; filesort wurde genutzt

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:178
15	JFalangDatabase->loadColumn()	JROOT/administrator/components/com_contentbuilder/classes/joomla_compat.php:128
14	CBCompat::loadColumn()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:436
13	contentbuilder::getLanguageCodes()	JROOT/administrator/components/com_contentbuilder/models/list.php:577
12	ContentbuilderModelList->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/list/view.html.php:22
10	ContentbuilderViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/list.php:35
8	ContentbuilderControllerList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.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.21 ms Nach letzter Abfrage: 15.42 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 22.661 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 kyhul_fields AS a

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

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

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

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

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

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

  ORDER BY a.ordering ASC

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 index condition; Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	db139985_7.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	db139985_7.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	db139985_7.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	db139985_7.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	db139985_7.a.group_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
28	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
25	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
23	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
22	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
21	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
20	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
17	JHtmlContent::prepare()	Der selbe Aufruf in der Zeile darunter.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
13	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Der selbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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: 7.18 ms Nach letzter Abfrage: 4.88 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 23.125 MB Zeilen zurückgegeben: 1

SELECT m.*

  FROM kyhul_modules AS m

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

  WHERE m.client_id = 0 
  AND m.title = 'Sprechersuche de' 
  AND m.access IN (1,1) 
  AND m.published = 1 
  AND e.enabled = 1

  ORDER BY m.ordering

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	published,newsfeeds	published	5	NULL	36	1.00	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	db139985_7.m.module,const	1	10.00	Using index condition; Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
35	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
34	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
32	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
31	JFalangDatabase->loadObject()	JROOT/plugins/system/modulesanywhere/src/Replace.php:625
30	RegularLabs\Plugin\System\ModulesAnywhere\Replace::getModuleFromDatabase()	JROOT/plugins/system/modulesanywhere/src/Replace.php:517
29	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule()	JROOT/plugins/system/modulesanywhere/src/Replace.php:303
28	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch()	JROOT/plugins/system/modulesanywhere/src/Replace.php:194
27	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches()	JROOT/plugins/system/modulesanywhere/src/Replace.php:176
26	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace()	JROOT/plugins/system/modulesanywhere/src/Replace.php:131
25	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules()	JROOT/plugins/system/modulesanywhere/src/Helper.php:81
24	RegularLabs\Plugin\System\ModulesAnywhere\Helper->processModules()	Der selbe Aufruf in der Zeile darunter.
23	call_user_func_array()	JROOT/libraries/regularlabs/src/Article.php:226
22	RegularLabs\Library\Article::processText()	JROOT/libraries/regularlabs/src/Article.php:209
21	RegularLabs\Library\Article::process()	JROOT/plugins/system/modulesanywhere/src/Helper.php:31
20	RegularLabs\Plugin\System\ModulesAnywhere\Helper->onContentPrepare()	Der selbe Aufruf in der Zeile darunter.
19	call_user_func_array()	JROOT/plugins/system/modulesanywhere/src/Plugin.php:97
18	RegularLabs\Plugin\System\ModulesAnywhere\Plugin->run()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:49
17	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Der selbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.12 ms Nach letzter Abfrage: 1.10 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 23.606 MB Zeilen zurückgegeben: 10

SELECT joomlatablename,tablepkID 
  FROM `kyhul_falang_tableinfo`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
40	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
39	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
38	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
37	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:144
36	FalangManager->_loadPrimaryKeyData()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:57
35	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
34	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
33	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
32	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
31	JFalangDatabase->loadObject()	JROOT/plugins/system/modulesanywhere/src/Replace.php:625
30	RegularLabs\Plugin\System\ModulesAnywhere\Replace::getModuleFromDatabase()	JROOT/plugins/system/modulesanywhere/src/Replace.php:517
29	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule()	JROOT/plugins/system/modulesanywhere/src/Replace.php:303
28	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch()	JROOT/plugins/system/modulesanywhere/src/Replace.php:194
27	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches()	JROOT/plugins/system/modulesanywhere/src/Replace.php:176
26	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace()	JROOT/plugins/system/modulesanywhere/src/Replace.php:131
25	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules()	JROOT/plugins/system/modulesanywhere/src/Helper.php:81
24	RegularLabs\Plugin\System\ModulesAnywhere\Helper->processModules()	Der selbe Aufruf in der Zeile darunter.
23	call_user_func_array()	JROOT/libraries/regularlabs/src/Article.php:226
22	RegularLabs\Library\Article::processText()	JROOT/libraries/regularlabs/src/Article.php:209
21	RegularLabs\Library\Article::process()	JROOT/plugins/system/modulesanywhere/src/Helper.php:31
20	RegularLabs\Plugin\System\ModulesAnywhere\Helper->onContentPrepare()	Der selbe Aufruf in der Zeile darunter.
19	call_user_func_array()	JROOT/plugins/system/modulesanywhere/src/Plugin.php:97
18	RegularLabs\Plugin\System\ModulesAnywhere\Plugin->run()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:49
17	PlgSystemModulesAnywhere->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Der selbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.14 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 23.626 MB Zeilen zurückgegeben: 5

SELECT * 
  FROM kyhul_languages 
  ORDER BY ordering

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
40	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
39	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
38	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
37	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:319
36	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
35	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
34	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
33	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
32	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
31	JFalangDatabase->loadObject()	JROOT/pl