Wir hatten die Gelegenheit mit Ronald Nitschke nach Sprachaufnahmen bei uns ein Interview zu führen, hier das Interview: Ronald Nitschke hat sein 1960 in über 200 Fernsehserien und Serien als Schauspieler mitgespielt. Daneben arbeitete er auch als Synchronautor und Regisseur. Er schrieb die deutschen Dialogbücher für Filme von Mel Brooks, James Ca...
Mixwerk Blog
Für den Film "The Female Brain" haben wir Tonstudio mit Dennis die Rolle des Kevin aufgenommen. Dennis spricht die deutsche Stimme von Captain America, den Serienkiller Dexter, David Fisher in Six Feet Under oder auch als Deadpool in der gleichnamigen Filmreihe. Hier das Interview mit ihm, das in unserer Sprecheragentur aufgenommen wurde: Dennis ha...
Markiert in:
Willkommen zu unserem Erfahrungsberichten über Sprecher, die uns kontaktieren. Heute gehts um den persönlichen und postalischen Kontakt bei der ersten Kontaktaufnahme: 1.3 Erstkontakt persönlich vor Ort Die wenigsten Sprecherinnen und Sprecher kommen hier in der Sprecheragentur und im Tonstudio Berlin vorbei und wir raten auch davon ab, ohne vorher...
Markiert in:
Willkommen zu unseren Erfahrungsberichten über Sprecher, die uns kontaktieren. Heute gehts um die telefonische Kontaktaufnahme: 1.2 Erstkontakt per Telefon Ich weiß, Profisprecherinnen und Profisprecher sind keine Vertriebler, im Augenblick der telefonischen Bewerbung allerdings sehr wohl. Das Wichtigste: Holt Euch vorher Infos im Internet was wir ...
Markiert in:
Willkommen zu unserem Erfahrungsberichten über Sprecher, die uns kontaktieren. Wir hoffen, Euch damit zu helfen, bei uns und anderen Sprecheragenturen oder Tonstudios noch erfolgreicher zu sein. Es sollen die Möglichkeiten des eigenen „Marketings" von Sprecherinnen und Sprechern aus unserer Sicht aufgezeigt werden. Dieser Blog richtet sich sowohl a...
Markiert in:
Voice-over ist ein Fachbegriff aus der Studiotechnik des Hörfunks und beim Film. Er bezeichnet die Sprachaufnahmen einer Stimme (engl. voice) oder eines Sprechers, die über (engl. over) eine andere Tonaufnahme oder über eine Filmszene gelegt wird.
Im Hörfunk kommt das Voice-over bei der Übersetzung fremdsprachiger Originaltöne und bei Interviews vor.
Im Hörfunk kommt das Voice-over bei der Übersetzung fremdsprachiger Originaltöne und bei Interviews vor.
Markiert in:
Eine Sprecheragentur hat eine Karte an Profi Sprechern in vielen Sprachen, meist gegliedert nach Sprache, Geschlecht, Alter, Stimmlage. Mixwerk ist eigentlich mehr ein Tonstudio, das auch Profi Sprecher mit anbietet. Wir nehmen dann in unseren Studios diese Sprecher auf, meist als "Voiceover", Imagefilm, elearning, Schulungsfilm oder Werbung. Der Vorteil ist, das wir in über 45 Sprachen Ihnen auf einen Schlag die benötigten Aufnahmen senden können, das spart viel Geld, Zeit und Energie. Wir können zusätzlich in unseren Studios auch per ISDN, also in CD Qualität weltweit Sprecher aufnehmen, egal wo Sie sind.
Markiert in:
Das ist die Gretchen Frage.
Hier im Mixwerk können Sie sich im Untermenü "Sprecher" unsere Sprecher in über 40 Sprachen anhören. Dann werden Ihnen die jeweiligen Sprecher/innen in der Landesprache angezeigt und mit Klick auf den Play Button hören Sie sofort die ausgesuchte Stimme.
Hier im Mixwerk können Sie sich im Untermenü "Sprecher" unsere Sprecher in über 40 Sprachen anhören. Dann werden Ihnen die jeweiligen Sprecher/innen in der Landesprache angezeigt und mit Klick auf den Play Button hören Sie sofort die ausgesuchte Stimme.
Markiert in:
Joomla!-Debug-Konsole
{ "__default": { "session": { "counter": 1, "timer": { "start": 1701624492, "last": 1701624492, "now": 1701624492 }, "token": "TkR5SSNT0rugug2H9fX1SUx03NqykmQD" }, "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" } }, "__easyblog": { "site": { "messages": null } } }
Zeit
Speicher
Zeit: 10.16 ms / 10.16 ms Speicher: 2.445 MB / 2.83 MB Application: afterLoad
Zeit: 69.20 ms / 79.36 ms Speicher: 11.208 MB / 14.04 MB Application: afterInitialise
Zeit: 25.66 ms / 105.02 ms Speicher: 4.348 MB / 18.39 MB Application: afterRoute
Zeit: 0.63 ms / 105.65 ms Speicher: 0.032 MB / 18.42 MB Application: beforeRenderComponent com_easyblog
Zeit: 0.56 ms / 106.21 ms Speicher: 0.027 MB / 18.45 MB Application: Before Access::preloadComponents (all components)
Zeit: 4.24 ms / 110.45 ms Speicher: 0.073 MB / 18.52 MB Application: After Access::preloadComponents (all components)
Zeit: 0.02 ms / 110.47 ms Speicher: -0.002 MB / 18.52 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Zeit: 0.49 ms / 110.97 ms Speicher: 0.025 MB / 18.54 MB Application: After Access::getAssetRules (id:1 name:root.1)
Zeit: 175.47 ms / 286.43 ms Speicher: 15.876 MB / 34.42 MB Application: afterRenderComponent com_easyblog
Zeit: 1.50 ms / 287.93 ms Speicher: 0.670 MB / 35.09 MB Application: afterDispatch
Zeit: 4.55 ms / 292.47 ms Speicher: 0.083 MB / 35.17 MB Application: beforeRenderModule mod_menu (Unsere Leistungen)
Zeit: 3.11 ms / 295.58 ms Speicher: 0.089 MB / 35.26 MB Application: afterRenderModule mod_menu (Unsere Leistungen)
Zeit: 0.42 ms / 296.00 ms Speicher: -0.078 MB / 35.18 MB Application: beforeRenderModule mod_custom (Kontakt Media)
Zeit: 3.09 ms / 299.09 ms Speicher: 0.021 MB / 35.21 MB Application: afterRenderModule mod_custom (Kontakt Media)
Zeit: 0.37 ms / 299.45 ms Speicher: 0.000 MB / 35.21 MB Application: beforeRenderModule mod_custom (Kontakt Synchron)
Zeit: 0.75 ms / 300.20 ms Speicher: 0.004 MB / 35.21 MB Application: afterRenderModule mod_custom (Kontakt Synchron)
Zeit: 0.48 ms / 300.69 ms Speicher: 0.001 MB / 35.21 MB Application: beforeRenderModule mod_custom (Separator Blog Beiträge)
Zeit: 0.60 ms / 301.29 ms Speicher: 0.004 MB / 35.22 MB Application: afterRenderModule mod_custom (Separator Blog Beiträge)
Zeit: 0.22 ms / 301.50 ms Speicher: -0.019 MB / 35.20 MB Application: beforeRenderModule mod_falang (FaLang Language Switcher)
Zeit: 7.88 ms / 309.38 ms Speicher: 1.088 MB / 36.28 MB Application: afterRenderModule mod_falang (FaLang Language Switcher)
Zeit: 0.39 ms / 309.77 ms Speicher: 0.018 MB / 36.30 MB Application: beforeRenderModule mod_flexi_customcode (static background image)
Zeit: 0.91 ms / 310.68 ms Speicher: 0.013 MB / 36.32 MB Application: afterRenderModule mod_flexi_customcode (static background image)
Zeit: 29.16 ms / 339.84 ms Speicher: 0.235 MB / 36.55 MB Application: afterRender
Datenbankabfragen gesamt: 65.87 ms
36,85 MB (38.635.976 Bytes)
112 ausgeführte Abfragen 65.87 ms
23 Duplikate gefunden!
- Abfragezeit: 0.44 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 13.112 MB
Update kyhul_contentbuilder_articles As articles, kyhul_content As content, kyhul_contentbuilder_forms As forms, kyhul_contentbuilder_registered_users As cbusers, kyhul_users As users
Set content.state = 0
Where articles.article_id = content.id
And content.state = 1
And articles.form_id = forms.id
And forms.act_as_registration = 1
And forms.id = cbusers.form_id
And content.created_by = cbusers.user_id
And ( ( users.id = cbusers.user_id
And users.block = 1 ) )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 Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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 - Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 13.120 MB
Update kyhul_contentbuilder_articles As articles, kyhul_content As content, kyhul_contentbuilder_forms As forms, kyhul_contentbuilder_records As records, kyhul_contentbuilder_registered_users As cbusers, kyhul_users As users
Set content.state = forms.auto_publish
Where articles.article_id = content.id
And content.state = 0
And articles.form_id = forms.id
And forms.act_as_registration = 1
And forms.id = cbusers.form_id
And content.created_by = cbusers.user_id
And users.id = cbusers.user_id
And records.record_id = cbusers.record_id
And records.`type` = forms.`type`
And users.block = 0id 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 Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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 - Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.92 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 14.026 MB Zeilen zurückgegeben: 0
Select form.id As form_id, form.act_as_registration, form.default_category, form.registration_name_field, form.registration_username_field, form.registration_email_field, form.registration_email_repeat_field, form.`last_update`, article.`article_id`, form.`title_field`, form.`create_articles`, form.`name`, form.`use_view_name_as_title`, form.`protect_upload_directory`, form.`reference_id`, records.`record_id`, form.`type`, form.`published_only`, form.`own_only`, form.`own_only_fe`, records.`last_update` As record_last_update, article.`last_update` As article_last_update
From kyhul_contentbuilder_records As records
Left Join kyhul_contentbuilder_forms As form
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id )
Left Join kyhul_contentbuilder_articles As article
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id
And article.form_id = form.id
And article.record_id = records.record_id )
Left Join kyhul_content As content
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id
And article.article_id = content.id
And article.form_id = form.id
And article.record_id = records.record_id )
Where form.`published` = 1
And form.create_articles = 1
And form.`type` = records.`type`
And form.reference_id = records.reference_id
And ( ( article.form_id = form.id
And article.record_id = records.record_id
And article.article_id = content.id
And ( content.state = 1 Or content.state = 0 )
And ( form.`last_update` > article.`last_update` Or records.`last_update` > article.`last_update` ) ) Or ( form.id Is Not Null
And records.id Is Not Null
And content.id Is Null
And article.id Is Null ) )
Limit 50id 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 Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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 - Abfragezeit: 0.77 ms Nach letzter Abfrage: 9.21 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 16.440 MB Zeilen zurückgegeben: 2
SHOW FULL COLUMNS
FROM `kyhul_komento_configs`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `kyhul_komento_configs`Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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 - Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.58 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 16.458 MB Zeilen zurückgegeben: 1
SELECT *
FROM kyhul_komento_configs
WHERE `component` = 'com_komento'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 Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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 - Abfragezeit: 0.37 ms Nach letzter Abfrage: 9.62 ms Abfragespeichernutzung: 0.079 MB Speichernutzung vor Abfrage: 17.750 MB Zeilen zurückgegeben: 1
SELECT *
FROM kyhul_easyblog_configs
WHERE `name` = 'config'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kyhul_easyblog_configs NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 3 33.33 Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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:434 14 JFalangDatabase->loadAssoc() JROOT/libraries/src/Table/Table.php:747 13 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_easyblog/includes/easyblog.php:581 12 EB::config() JROOT/components/com_easyblog/router.php:513 11 EasyBlogRouterBase::parseRoute() JROOT/components/com_easyblog/router.php:1264 10 EasyBlogParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 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 - Abfragezeit: 0.71 ms Nach letzter Abfrage: 1.24 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 17.882 MB Zeilen zurückgegeben: 1
SELECT *
FROM `kyhul_easyblog_tag`
WHERE ( BINARY `title`='sprachaufnahmen' OR BINARY `alias`='sprachaufnahmen' )id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kyhul_easyblog_tag NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 46 100.00 Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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:416 14 JFalangDatabase->loadObject() JROOT/administrator/components/com_easyblog/includes/utils.php:330 13 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/tables/tag.php:75 12 EasyBlogTableTag->load() JROOT/components/com_easyblog/router.php:956 11 EasyBlogRouterBase::parseRoute() JROOT/components/com_easyblog/router.php:1264 10 EasyBlogParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 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 - Abfragezeit: 3.85 ms Nach letzter Abfrage: 5.54 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 18.456 MB Zeilen zurückgegeben: 55
SELECT `id`,`name`,`rules`,`parent_id`
FROM `kyhul_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_advportfoliopro','com_ajax','com_akeeba','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contentbuilder','com_contenthistory','com_cpanel','com_easyblog','com_falang','com_feedgator','com_fields','com_finder','com_installer','com_jbetolo','com_jce','com_joomlaupdate','com_jotcache','com_komento','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocamaps','com_phocapanorama','com_plugins','com_postinstall','com_privacy','com_redirect','com_regularlabsmanager','com_rereplacer','com_search','com_sitemapgenerator','com_smartslider3','com_tagmeta','com_tags','com_templates','com_uniterevolution2','com_users','com_weblinks','com_wrapper','com_xmap')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kyhul_assets NULL ALL idx_asset_name ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 541 10.54 Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/Access/Access.php:429 13 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 12 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 11 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 10 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 9 Joomla\CMS\User\User->authorise() JROOT/administrator/components/com_easyblog/includes/easyblog.php:1225 8 EB::isSiteAdmin() JROOT/administrator/components/com_easyblog/includes/easyblog.php:136 7 EB::checkEnvironment() JROOT/components/com_easyblog/easyblog.php:20 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.63 ms Nach letzter Abfrage: 3.39 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 19.027 MB
DELETE
FROM `kyhul_easyblog_mailq`
WHERE `status`='1'
AND DATEDIFF(NOW(), `created`) >='7'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 DELETE kyhul_easyblog_mailq NULL range easyblog_mailq_status,idx_mailq_statuscreated easyblog_mailq_status 1 const 1 100.00 Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 12 JFalangDatabase->execute() JROOT/administrator/components/com_easyblog/includes/utils.php:198 11 EasyBlogDbJoomla->query() JROOT/administrator/components/com_easyblog/models/mailer.php:39 10 EasyBlogModelMailer->cleanup() JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:29 9 EasyBlogMailer->dispatch() JROOT/components/com_easyblog/services/maintenance.php:18 8 require_once JROOT/components/com_easyblog/services/maintenance.php JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 7 EB::loadServices() JROOT/components/com_easyblog/easyblog.php:27 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.08 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 19.034 MB Zeilen zurückgegeben: 0
SELECT `id`
FROM `kyhul_easyblog_mailq`
WHERE `status`='0'
ORDER BY `id` ASC
LIMIT 20id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_easyblog/includes/utils.php:330 11 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/mailer.php:67 10 EasyBlogModelMailer->getPendingEmails() JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:32 9 EasyBlogMailer->dispatch() JROOT/components/com_easyblog/services/maintenance.php:18 8 require_once JROOT/components/com_easyblog/services/maintenance.php JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 7 EB::loadServices() JROOT/components/com_easyblog/easyblog.php:27 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 1.04 ms Nach letzter Abfrage: 7.40 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 20.604 MB Zeilen zurückgegeben: 0
SELECT *
FROM `kyhul_easyblog_post`
WHERE `publish_up`<='2023-12-03 17:28:12'
AND `published`='2'
AND `state`='0'
ORDER BY `id`
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kyhul_easyblog_post NULL ref easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1 easyblog_post_blogger_list 1 const 1 5.00 Using index condition; Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_easyblog/includes/utils.php:330 11 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/blogs.php:386 10 EasyBlogModelBlogs->getScheduledPosts() JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:51 9 EasyBlogScheduler->publish() JROOT/components/com_easyblog/services/maintenance.php:22 8 require_once JROOT/components/com_easyblog/services/maintenance.php JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 7 EB::loadServices() JROOT/components/com_easyblog/easyblog.php:27 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.30 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 20.619 MB Zeilen zurückgegeben: 0
SELECT id, created_by
FROM`kyhul_easyblog_post`
WHERE `publish_down` > `publish_up`
AND `publish_down` <= '2023-12-03 17:28:12'
AND `publish_down` != '0000-00-00 00:00:00'
AND `published` = '1'
AND `state` = '0'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kyhul_easyblog_post NULL range easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1,idx_publishdown_posts idx_publishdown_posts 11 NULL 2 2.89 Using index condition; Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_easyblog/includes/utils.php:330 11 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/blogs.php:542 10 EasyBlogModelBlogs->getUnpublishScheduledPosts() JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:26 9 EasyBlogScheduler->unpublish() JROOT/components/com_easyblog/services/maintenance.php:25 8 require_once JROOT/components/com_easyblog/services/maintenance.php JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 7 EB::loadServices() JROOT/components/com_easyblog/easyblog.php:27 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.32 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 20.624 MB Zeilen zurückgegeben: 0
SELECT *
FROM `kyhul_easyblog_uploader_tmp`
WHERE `created` <= DATE_SUB('2023-12-03 17:28:12' , INTERVAL 120 MINUTE)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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_easyblog/includes/utils.php:330 10 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:165 9 EasyBlogScheduler->removeTmpFiles() JROOT/components/com_easyblog/services/maintenance.php:28 8 require_once JROOT/components/com_easyblog/services/maintenance.php JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 7 EB::loadServices() JROOT/components/com_easyblog/easyblog.php:27 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.41 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 20.632 MB Zeilen zurückgegeben: 0
SELECT a.`id`
FROM `kyhul_easyblog_post` as a
inner join `kyhul_easyblog_revisions` as b
on a.`id` = b.`post_id`
where a.`published` = '9'
and a.`created` <= DATE_SUB('2023-12-03 17:28:12', INTERVAL 3 DAY)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref PRIMARY,easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1 easyblog_post_published 1 const 1 33.33 Using where 1 SIMPLE b NULL ref idx_postid,idx_ordering,idx_revision_state idx_postid 8 db139985_7.a.id 1 100.00 Using where; Using index Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_easyblog/includes/utils.php:330 10 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:207 9 EasyBlogScheduler->removeBlankPosts() JROOT/components/com_easyblog/services/maintenance.php:31 8 require_once JROOT/components/com_easyblog/services/maintenance.php JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 7 EB::loadServices() JROOT/components/com_easyblog/easyblog.php:27 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 20.639 MB
DELETE a, b
FROM `kyhul_easyblog_post` as a
inner join `kyhul_easyblog_revisions` as b
on a.`id` = b.`post_id`
where a.`published` = '9'
and a.`created` <= DATE_SUB('2023-12-03 17:28:12', INTERVAL 3 DAY)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 DELETE a NULL ref PRIMARY,easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1 easyblog_post_published 1 const 1 33.33 Using where 1 DELETE b NULL ref idx_postid,idx_ordering,idx_revision_state idx_postid 8 db139985_7.a.id 1 100.00 Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 11 JFalangDatabase->execute() JROOT/administrator/components/com_easyblog/includes/utils.php:198 10 EasyBlogDbJoomla->query() JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:220 9 EasyBlogScheduler->removeBlankPosts() JROOT/components/com_easyblog/services/maintenance.php:31 8 require_once JROOT/components/com_easyblog/services/maintenance.php JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 7 EB::loadServices() JROOT/components/com_easyblog/easyblog.php:27 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.54 ms Nach letzter Abfrage: 1.00 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 20.681 MB Zeilen zurückgegeben: 0
select a.`id`, a.`user_id`, b.`name`, b.`email`
from `kyhul_easyblog_oauth` as a
inner join `kyhul_users` as b
on a.`user_id` = b.`id`
where a.`type` = 'facebook'
and a.`notify` = '0'
and a.`system` = '1'
and a.`expires` <= DATE_ADD('2023-12-03 17:28:12', INTERVAL 7 DAY)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref easyblog_oauth_user_type,idx_expiry_notify idx_expiry_notify 806 const,const,const 1 33.33 Using where 1 SIMPLE b NULL eq_ref PRIMARY PRIMARY 4 db139985_7.a.user_id 1 100.00 NULL Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_easyblog/includes/utils.php:330 12 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/oauth.php:361 11 EasyBlogModelOauth->getSoonTobeExpired() JROOT/administrator/components/com_easyblog/includes/oauth/adapters/facebook/client.php:572 10 EasyBlogClientFacebook->notifyAdminTokenExpiry() JROOT/administrator/components/com_easyblog/includes/oauth/oauth.php:111 9 EasyBlogOauth->notifyAdminTokenExpiry() JROOT/components/com_easyblog/services/maintenance.php:34 8 require_once JROOT/components/com_easyblog/services/maintenance.php JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 7 EB::loadServices() JROOT/components/com_easyblog/easyblog.php:27 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.52 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 21.155 MB Zeilen zurückgegeben: 1
SELECT *
FROM `kyhul_menu`
WHERE `published`='1'
AND `link` LIKE 'index.php?option=com_easyblog%'
AND `client_id` = '0'
ORDER BY `id`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kyhul_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 70 1.11 Using index condition; Using where; filesort wurde genutzt Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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_easyblog/includes/utils.php:330 13 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/menu.php:64 12 EasyBlogModelMenu->getAssociatedMenus() JROOT/administrator/components/com_easyblog/includes/router.php:97 11 EBR::getMenus() JROOT/administrator/components/com_easyblog/includes/router.php:453 10 EBR::_() JROOT/administrator/components/com_easyblog/includes/router.php:955 9 EBR::getRoutedURL() JROOT/components/com_easyblog/services/weblog.php:26 8 require_once JROOT/components/com_easyblog/services/weblog.php JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 7 EB::loadServices() JROOT/components/com_easyblog/easyblog.php:27 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.08 ms Nach letzter Abfrage: 0.60 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 21.187 MB Zeilen zurückgegeben: 10
SELECT joomlatablename,tablepkID
FROM `kyhul_falang_tableinfo`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 Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_falang/classes/FalangManager.class.php:144 18 FalangManager->_loadPrimaryKeyData() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:57 17 FalangManager->__construct() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 16 FalangManager::getInstance() JROOT/components/com_falang/helpers/falang.class.php:35 15 Falang::translateList() JROOT/plugins/system/falangdriver/falang_database.php:334 14 JFalangDatabase->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:330 13 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/menu.php:64 12 EasyBlogModelMenu->getAssociatedMenus() JROOT/administrator/components/com_easyblog/includes/router.php:97 11 EBR::getMenus() JROOT/administrator/components/com_easyblog/includes/router.php:453 10 EBR::_() JROOT/administrator/components/com_easyblog/includes/router.php:955 9 EBR::getRoutedURL() JROOT/components/com_easyblog/services/weblog.php:26 8 require_once JROOT/components/com_easyblog/services/weblog.php JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 7 EB::loadServices() JROOT/components/com_easyblog/easyblog.php:27 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.07 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 21.200 MB Zeilen zurückgegeben: 5
SELECT *
FROM kyhul_languages
ORDER BY orderingid 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 Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_falang/classes/FalangManager.class.php:319 18 FalangManager->getLanguages() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63 17 FalangManager->__construct() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 16 FalangManager::getInstance() JROOT/components/com_falang/helpers/falang.class.php:35 15 Falang::translateList() JROOT/plugins/system/falangdriver/falang_database.php:334 14 JFalangDatabase->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:330 13 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/menu.php:64 12 EasyBlogModelMenu->getAssociatedMenus() JROOT/administrator/components/com_easyblog/includes/router.php:97 11 EBR::getMenus() JROOT/administrator/components/com_easyblog/includes/router.php:453 10 EBR::_() JROOT/administrator/components/com_easyblog/includes/router.php:955 9 EBR::getRoutedURL() JROOT/components/com_easyblog/services/weblog.php:26 8 require_once JROOT/components/com_easyblog/services/weblog.php JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 7 EB::loadServices() JROOT/components/com_easyblog/easyblog.php:27 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.57 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 21.220 MB Zeilen zurückgegeben: 14
SHOW FULL COLUMNS
FROM `kyhul_languages`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `kyhul_languages`Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 26 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 25 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 23 JFalangDatabase->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 21 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 20 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_falang/tables/JFLanguage.php:54 19 TableJFLanguage->__construct() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:325 18 FalangManager->getLanguages() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63 17 FalangManager->__construct() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 16 FalangManager::getInstance() JROOT/components/com_falang/helpers/falang.class.php:35 15 Falang::translateList() JROOT/plugins/system/falangdriver/falang_database.php:334 14 JFalangDatabase->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:330 13 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/menu.php:64 12 EasyBlogModelMenu->getAssociatedMenus() JROOT/administrator/components/com_easyblog/includes/router.php:97 11 EBR::getMenus() JROOT/administrator/components/com_easyblog/includes/router.php:453 10 EBR::_() JROOT/administrator/components/com_easyblog/includes/router.php:955 9 EBR::getRoutedURL() JROOT/components/com_easyblog/services/weblog.php:26 8 require_once JROOT/components/com_easyblog/services/weblog.php JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 7 EB::loadServices() JROOT/components/com_easyblog/easyblog.php:27 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.08 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 21.260 MB Zeilen zurückgegeben: 0
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM kyhul_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(158)
AND falang_content.reference_table='menu'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE falang_content NULL ref falangContent,falangContentLanguage,reference_id,language_id,reference_table,idxFalang1 falangContent 310 const,const,const 1 10.00 Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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:277 17 JFalangDatabase->loadObjectList() JROOT/components/com_falang/helpers/falang.class.php:235 16 Falang::translateListWithIDs() JROOT/components/com_falang/helpers/falang.class.php:108 15 Falang::translateList() JROOT/plugins/system/falangdriver/falang_database.php:334 14 JFalangDatabase->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:330 13 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/menu.php:64 12 EasyBlogModelMenu->getAssociatedMenus() JROOT/administrator/components/com_easyblog/includes/router.php:97 11 EBR::getMenus() JROOT/administrator/components/com_easyblog/includes/router.php:453 10 EBR::_() JROOT/administrator/components/com_easyblog/includes/router.php:955 9 EBR::getRoutedURL() JROOT/components/com_easyblog/services/weblog.php:26 8 require_once JROOT/components/com_easyblog/services/weblog.php JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 7 EB::loadServices() JROOT/components/com_easyblog/easyblog.php:27 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.09 ms Nach letzter Abfrage: 0.77 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 21.263 MB Zeilen zurückgegeben: 46
SELECT *
FROM `kyhul_easyblog_acl`
WHERE `published`='1'
ORDER BY `id` ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kyhul_easyblog_acl NULL ALL idx_acl_published,idx_acl_published_id ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 46 97.83 Using where; filesort wurde genutzt Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_easyblog/includes/utils.php:330 12 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/includes/acl/acl.php:322 11 EasyBlogAcl::getRules() JROOT/administrator/components/com_easyblog/includes/acl/acl.php:36 10 EasyBlogAcl::getRuleSet() JROOT/administrator/components/com_easyblog/includes/easyblog.php:219 9 EB::acl() JROOT/components/com_easyblog/controllers/controller.php:22 8 EasyBlogController->__construct() JROOT/libraries/src/MVC/Controller/BaseController.php:313 7 Joomla\CMS\MVC\Controller\BaseController::getInstance() JROOT/components/com_easyblog/easyblog.php:33 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.07 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 21.298 MB Zeilen zurückgegeben: 46
SELECT *
FROM `kyhul_easyblog_acl_group`
WHERE `content_id` IN (1)
AND `type`='
group'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kyhul_easyblog_acl_group NULL ref easyblog_post_acl_content_type easyblog_post_acl_content_type 810 const,const 46 100.00 Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_easyblog/includes/utils.php:330 12 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/includes/acl/acl.php:151 11 EasyBlogAcl::getEasyBlogAclGroups() JROOT/administrator/components/com_easyblog/includes/acl/acl.php:98 10 EasyBlogAcl::getRuleSet() JROOT/administrator/components/com_easyblog/includes/easyblog.php:219 9 EB::acl() JROOT/components/com_easyblog/controllers/controller.php:22 8 EasyBlogController->__construct() JROOT/libraries/src/MVC/Controller/BaseController.php:313 7 Joomla\CMS\MVC\Controller\BaseController::getInstance() JROOT/components/com_easyblog/easyblog.php:33 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 1.07 ms Nach letzter Abfrage: 1.87 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 21.822 MB Zeilen zurückgegeben: 0
SELECT `id`
FROM `kyhul_menu`
WHERE ( `link`='index.php?option=com_easyblog&view=tags&layout=tag&id=2' OR `link` LIKE 'index.php?option=com_easyblog&view=tags&layout=tag&id=2&
limit%' OR `link` LIKE 'index.php?option=com_easyblog&view=tags&layout=tag&id=2' OR `link` LIKE 'index.php?option=com_easyblog&view=tags&layout=tag&id=2&
limit%' )
AND `published`='1'
AND (`language`='de-DE' OR `language`='' OR `language`='*')
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kyhul_menu NULL range idx_language idx_language 28 NULL 172 3.68 Using index condition; Using where Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 25 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 24 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 22 JFalangDatabase->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:416 21 JFalangDatabase->loadObject() JROOT/plugins/system/falangdriver/falang_database.php:351 20 JFalangDatabase->_loadObject() JROOT/plugins/system/falangdriver/falang_database.php:143 19 JFalangDatabase->loadResult() JROOT/administrator/components/com_easyblog/includes/utils.php:330 18 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/menu.php:406 17 EasyBlogModelMenu->getMenusByTagId() JROOT/administrator/components/com_easyblog/includes/easyblog.php:4327 16 EB::getMenuParams() JROOT/administrator/components/com_easyblog/includes/themes/themes.php:159 15 EasyBlogThemes->__construct() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3832 14 EB::template() JROOT/components/com_easyblog/views/views.php:48 13 EasyBlogView->__construct() JROOT/components/com_easyblog/views/tags/view.html.php:32 12 EasyBlogViewTags->__construct() JROOT/libraries/src/MVC/Factory/LegacyFactory.php:89 11 Joomla\CMS\MVC\Factory\LegacyFactory->createView() JROOT/libraries/src/MVC/Controller/BaseController.php:590 10 Joomla\CMS\MVC\Controller\BaseController->createView() JROOT/libraries/src/MVC/Controller/BaseController.php:833 9 Joomla\CMS\MVC\Controller\BaseController->getView() JROOT/components/com_easyblog/controllers/controller.php:69 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.24 ms Nach letzter Abfrage: 1.01 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 21.847 MB Zeilen zurückgegeben: 1
SELECT *
FROM kyhul_easyblog_tag
WHERE `id` = '2'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kyhul_easyblog_tag NULL const PRIMARY PRIMARY 8 const 1 100.00 NULL Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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:416 14 JFalangDatabase->loadObject() JROOT/plugins/system/falangdriver/falang_database.php:351 13 JFalangDatabase->_loadObject() JROOT/plugins/system/falangdriver/falang_database.php:434 12 JFalangDatabase->loadAssoc() JROOT/libraries/src/Table/Table.php:747 11 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_easyblog/tables/tag.php:47 10 EasyBlogTableTag->load() JROOT/components/com_easyblog/views/tags/view.html.php:118 9 EasyBlogViewTags->tag() JROOT/components/com_easyblog/controllers/controller.php:103 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 5.30 ms Nach letzter Abfrage: 4.68 ms Abfragespeichernutzung: 0.320 MB Speichernutzung vor Abfrage: 23.916 MB Zeilen zurückgegeben: 8
SELECT DISTINCT b.*, ifnull(f.`id`, 0) as `featured`
FROM `kyhul_easyblog_post_tag` AS a
INNER JOIN `kyhul_easyblog_post` AS b
ON a.post_id=b.id
LEFT JOIN `kyhul_easyblog_featured` AS f
ON b.`id` = f.`content_id`
AND f.`type` = 'post'
INNER JOIN `kyhul_users` AS uu
ON b.`created_by` = uu.`id`
and uu.`block` = 0
WHERE a.`tag_id` IN ('2')
AND b.`published` = '1'
AND b.`state`='0'
AND ((b.`source_type` = 'easyblog.sitewide') OR ( b.`source_type` = 'easyblog.team'
and 1 <= (select count(1)
from `kyhul_easyblog_team` as srcteam
where srcteam.`id` = b.`source_id`
and srcteam.`published` = 1
and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2
and (select count(1)
from `kyhul_easyblog_team_groups` as srcteamgrp
where srcteamgrp.`team_id` = srcteam.`id`
and srcteamgrp.`group_id` IN (1) ) > 0)))))
AND (`b`.`language`='de-DE' OR `b`.`language`='' OR `b`.`language`='*')
AND b.`access` = '0'
AND (1 <= (select count(1)
from `kyhul_easyblog_post_category` AS acp
INNER JOIN `kyhul_easyblog_category` as cat
on acp.`category_id` = cat.`id`
where acp.`post_id` = b.`id`
and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1)
and (0 > 0) ) OR ( (cat.`private` = 2)
and ( (select count(1)
from `kyhul_easyblog_category_acl` as cacl
where cacl.`category_id` = cat.id
and cacl.`acl_id` = 1
and cacl.`content_id` in (1)) > 0 ) ) )
and not exists ( select acp2.post_id
from `kyhul_easyblog_post_category` as acp2
inner join `kyhul_easyblog_category` as cat2
on acp2.`category_id` = cat2.`id`
where acp2.`post_id` = acp.`post_id`
and ( ( cat2.`private` = 1
and (0 = 0) ) OR ( cat2.`private` = 2
and (select count(1)
from `kyhul_easyblog_category_acl` as cacl2
where cacl2.`category_id` = cat2.`id`
and cacl2.`acl_id` = 1
and cacl2.`content_id` IN (1)) = 0 ) ) ) ))
ORDER BY b.`created` desc
LIMIT 0,100id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY f NULL system easyblog_featured_content_type,easyblog_content ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 0 0.00 const row not found 1 PRIMARY a NULL ref easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id easyblog_post_tagpost_id 8 const 10 100.00 Using where; Using index; Using temporary; filesort wurde genutzt 1 PRIMARY b NULL eq_ref PRIMARY,easyblog_post_published,easyblog_post_created_by,easyblog_post_blogger_list,easyblog_post_searchnew,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1 PRIMARY 8 db139985_7.a.post_id 1 5.00 Using where 1 PRIMARY uu NULL eq_ref PRIMARY,idx_block PRIMARY 4 db139985_7.b.created_by 1 100.00 Using where; Distinct 4 DEPENDENT SUBQUERY acp NULL ref eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post eb_post_category_post_cat 4 db139985_7.b.id 2 100.00 Using where; Using index 4 DEPENDENT SUBQUERY cat NULL eq_ref PRIMARY,easyblog_cat_private PRIMARY 8 db139985_7.acp.category_id 1 100.00 Using index condition; Using where 6 DEPENDENT SUBQUERY acp2 NULL ref eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post eb_post_category_post_cat 4 db139985_7.acp.post_id 2 100.00 Using index 6 DEPENDENT SUBQUERY cat2 NULL eq_ref PRIMARY,easyblog_cat_private PRIMARY 8 db139985_7.acp2.category_id 1 20.00 Using index condition; Using where 7 DEPENDENT SUBQUERY NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table 5 DEPENDENT SUBQUERY NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table 2 DEPENDENT SUBQUERY NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table 3 DEPENDENT SUBQUERY NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_easyblog/includes/utils.php:330 11 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/blog.php:1688 10 EasyBlogModelBlog->getTaggedBlogs() JROOT/components/com_easyblog/views/tags/view.html.php:160 9 EasyBlogViewTags->tag() JROOT/components/com_easyblog/controllers/controller.php:103 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 3.69 ms Nach letzter Abfrage: 0.29 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 24.162 MB Zeilen zurückgegeben: 1
SELECT COUNT(1)
FROM (SELECT DISTINCT b.*, ifnull(f.`id`, 0) as `featured`
FROM `kyhul_easyblog_post_tag` AS a
INNER JOIN `kyhul_easyblog_post` AS b
ON a.post_id=b.id
LEFT JOIN `kyhul_easyblog_featured` AS f
ON b.`id` = f.`content_id`
AND f.`type` = 'post'
INNER JOIN `kyhul_users` AS uu
ON b.`created_by` = uu.`id`
and uu.`block` = 0
WHERE a.`tag_id` IN ('2')
AND b.`published` = '1'
AND b.`state`='0'
AND ((b.`source_type` = 'easyblog.sitewide') OR ( b.`source_type` = 'easyblog.team'
and 1 <= (select count(1)
from `kyhul_easyblog_team` as srcteam
where srcteam.`id` = b.`source_id`
and srcteam.`published` = 1
and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2
and (select count(1)
from `kyhul_easyblog_team_groups` as srcteamgrp
where srcteamgrp.`team_id` = srcteam.`id`
and srcteamgrp.`group_id` IN (1) ) > 0)))))
AND (`b`.`language`='de-DE' OR `b`.`language`='' OR `b`.`language`='*')
AND b.`access` = '0'
AND (1 <= (select count(1)
from `kyhul_easyblog_post_category` AS acp
INNER JOIN `kyhul_easyblog_category` as cat
on acp.`category_id` = cat.`id`
where acp.`post_id` = b.`id`
and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1)
and (0 > 0) ) OR ( (cat.`private` = 2)
and ( (select count(1)
from `kyhul_easyblog_category_acl` as cacl
where cacl.`category_id` = cat.id
and cacl.`acl_id` = 1
and cacl.`content_id` in (1)) > 0 ) ) )
and not exists ( select acp2.post_id
from `kyhul_easyblog_post_category` as acp2
inner join `kyhul_easyblog_category` as cat2
on acp2.`category_id` = cat2.`id`
where acp2.`post_id` = acp.`post_id`
and ( ( cat2.`private` = 1
and (0 = 0) ) OR ( cat2.`private` = 2
and (select count(1)
from `kyhul_easyblog_category_acl` as cacl2
where cacl2.`category_id` = cat2.`id`
and cacl2.`acl_id` = 1
and cacl2.`content_id` IN (1)) = 0 ) ) ) ))
ORDER BY b.`created` desc) as xid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY <derived2> NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2 100.00 NULL 2 DERIVED f NULL system easyblog_featured_content_type,easyblog_content ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 0 0.00 const row not found 2 DERIVED a NULL ref easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id easyblog_post_tagpost_id 8 const 10 100.00 Using where; Using index; Using temporary; filesort wurde genutzt 2 DERIVED b NULL eq_ref PRIMARY,easyblog_post_published,easyblog_post_created_by,easyblog_post_blogger_list,easyblog_post_searchnew,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1 PRIMARY 8 db139985_7.a.post_id 1 5.00 Using where 2 DERIVED uu NULL eq_ref PRIMARY,idx_block PRIMARY 4 db139985_7.b.created_by 1 100.00 Using where; Distinct 5 DEPENDENT SUBQUERY acp NULL ref eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post eb_post_category_post_cat 4 db139985_7.b.id 2 100.00 Using where; Using index 5 DEPENDENT SUBQUERY cat NULL eq_ref PRIMARY,easyblog_cat_private PRIMARY 8 db139985_7.acp.category_id 1 100.00 Using index condition; Using where 7 DEPENDENT SUBQUERY acp2 NULL ref eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post eb_post_category_post_cat 4 db139985_7.acp.post_id 2 100.00 Using index 7 DEPENDENT SUBQUERY cat2 NULL eq_ref PRIMARY,easyblog_cat_private PRIMARY 8 db139985_7.acp2.category_id 1 20.00 Using index condition; Using where 8 DEPENDENT SUBQUERY NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table 6 DEPENDENT SUBQUERY NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table 3 DEPENDENT SUBQUERY NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table 4 DEPENDENT SUBQUERY NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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:416 14 JFalangDatabase->loadObject() JROOT/plugins/system/falangdriver/falang_database.php:351 13 JFalangDatabase->_loadObject() JROOT/plugins/system/falangdriver/falang_database.php:143 12 JFalangDatabase->loadResult() JROOT/administrator/components/com_easyblog/includes/utils.php:330 11 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/blog.php:1691 10 EasyBlogModelBlog->getTaggedBlogs() JROOT/components/com_easyblog/views/tags/view.html.php:160 9 EasyBlogViewTags->tag() JROOT/components/com_easyblog/controllers/controller.php:103 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.54 ms Nach letzter Abfrage: 0.93 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 24.175 MB Zeilen zurückgegeben: 1
SELECT *
FROM kyhul_easyblog_meta
WHERE `content_id` = '3'
AND `type` = 'view'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kyhul_easyblog_meta NULL ref idx_meta_content_type idx_meta_content_type 86 const,const 1 100.00 NULL Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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:416 14 JFalangDatabase->loadObject() JROOT/plugins/system/falangdriver/falang_database.php:351 13 JFalangDatabase->_loadObject() JROOT/plugins/system/falangdriver/falang_database.php:434 12 JFalangDatabase->loadAssoc() JROOT/libraries/src/Table/Table.php:747 11 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_easyblog/includes/easyblog.php:1958 10 EB::setMeta() JROOT/components/com_easyblog/views/tags/view.html.php:166 9 EasyBlogViewTags->tag() JROOT/components/com_easyblog/controllers/controller.php:103 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.41 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 24.184 MB Zeilen zurückgegeben: 1
select count(1)
from `kyhul_easyblog_post` as a
inner join `kyhul_easyblog_post_tag` as b
on a.`id` = b.`post_id`
and b.`tag_id` = '2'
where a.`access` = '1'
and a.`published` = '1'
AND (1 <= (select count(1)
from `kyhul_easyblog_post_category` AS acp
INNER JOIN `kyhul_easyblog_category` as cat
on acp.`category_id` = cat.`id`
where acp.`post_id` = a.`id`
and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1)
and (0 > 0) ) OR ( (cat.`private` = 2)
and ( (select count(1)
from `kyhul_easyblog_category_acl` as cacl
where cacl.`category_id` = cat.id
and cacl.`acl_id` = 1
and cacl.`content_id` in (1)) > 0 ) ) )
and not exists ( select acp2.post_id
from `kyhul_easyblog_post_category` as acp2
inner join `kyhul_easyblog_category` as cat2
on acp2.`category_id` = cat2.`id`
where acp2.`post_id` = acp.`post_id`
and ( ( cat2.`private` = 1
and (0 = 0) ) OR ( cat2.`private` = 2
and (select count(1)
from `kyhul_easyblog_category_acl` as cacl2
where cacl2.`category_id` = cat2.`id`
and cacl2.`acl_id` = 1
and cacl2.`content_id` IN (1)) = 0 ) ) ) ))id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL ref PRIMARY,easyblog_post_published,easyblog_post_blogger_list,easyblog_post_searchnew,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1 easyblog_post_searchnew 5 const,const 1 100.00 Using where 1 PRIMARY b NULL ref easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id easyblog_post_tagpost_id 16 const,db139985_7.a.id 1 100.00 Using where; Using index 2 DEPENDENT SUBQUERY acp NULL ref eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post eb_post_category_post_cat 4 db139985_7.a.id 2 100.00 Using where; Using index 2 DEPENDENT SUBQUERY cat NULL eq_ref PRIMARY,easyblog_cat_private PRIMARY 8 db139985_7.acp.category_id 1 100.00 Using index condition; Using where 4 DEPENDENT SUBQUERY acp2 NULL ref eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post eb_post_category_post_cat 4 db139985_7.acp.post_id 2 100.00 Using index 4 DEPENDENT SUBQUERY cat2 NULL eq_ref PRIMARY,easyblog_cat_private PRIMARY 8 db139985_7.acp2.category_id 1 20.00 Using index condition; Using where 5 DEPENDENT SUBQUERY NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table 3 DEPENDENT SUBQUERY NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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:416 14 JFalangDatabase->loadObject() JROOT/plugins/system/falangdriver/falang_database.php:351 13 JFalangDatabase->_loadObject() JROOT/plugins/system/falangdriver/falang_database.php:143 12 JFalangDatabase->loadResult() JROOT/administrator/components/com_easyblog/includes/utils.php:330 11 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/tags.php:836 10 EasyBlogModelTags->getTagPrivateBlogCount() JROOT/components/com_easyblog/views/tags/view.html.php:179 9 EasyBlogViewTags->tag() JROOT/components/com_easyblog/controllers/controller.php:103 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.82 ms Nach letzter Abfrage: 1.12 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 24.253 MB Zeilen zurückgegeben: 0
SELECT COUNT(1) as `voted`, `uid`
FROM `kyhul_easyblog_ratings`
WHERE `uid` IN (1058,1057,1047,1046,1035,22,21,9)
AND `type`='entry'
AND `created_by`='0'
AND (`sessionid` = 'phcp881om61v1jokm7gblaglvn' OR `ip` = '3.80.4.147')
GROUP BY `uid`
ORDER BY NULLid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kyhul_easyblog_ratings NULL ref post_id,created_by,idx_uid_type,idx_uid_type_user,idx_uid_type_user_session,idx_uid_type_user_ipaddr created_by 4 const 15 5.88 Using index condition; Using where; Using temporary Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_easyblog/includes/utils.php:330 16 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/ratings.php:135 15 EasyBlogModelRatings->preloadUserPostRatings() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:447 14 EasyBlogCache->cacheVoted() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:352 13 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 12 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 11 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954 10 EB::formatter() JROOT/components/com_easyblog/views/tags/view.html.php:223 9 EasyBlogViewTags->tag() JROOT/components/com_easyblog/controllers/controller.php:103 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.73 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 24.262 MB Zeilen zurückgegeben: 3
SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid`
FROM `kyhul_easyblog_ratings` AS a
WHERE a.`uid` IN(1058,1057,1047,1046,1035,22,21,9)
AND `type`='entry'
GROUP BY `uid`
ORDER BY NULLid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL post_id,idx_uid_type,idx_uid_type_user,idx_uid_type_user_ipaddr ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 17 5.88 Using where; Using temporary Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_easyblog/includes/utils.php:330 16 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/ratings.php:176 15 EasyBlogModelRatings->preloadRatings() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:578 14 EasyBlogCache->cacheRatings() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:357 13 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 12 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 11 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954 10 EB::formatter() JROOT/components/com_easyblog/views/tags/view.html.php:223 9 EasyBlogViewTags->tag() JROOT/components/com_easyblog/controllers/controller.php:103 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 1.10 ms Nach letzter Abfrage: 0.73 ms Abfragespeichernutzung: 0.049 MB Speichernutzung vor Abfrage: 24.291 MB Zeilen zurückgegeben: 18
select a.*, b.`post_id`, b.`primary`
from `kyhul_easyblog_category` as a
inner join `kyhul_easyblog_post_category` as b
on a.`id` = b.`category_id`
where b.`post_id` IN (1058,1057,1047,1046,1035,22,21,9)
order by a.`lft` ascid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b NULL range eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post eb_post_category_postid 4 NULL 15 100.00 Using index condition; Using temporary; filesort wurde genutzt 1 SIMPLE a NULL eq_ref PRIMARY PRIMARY 8 db139985_7.b.category_id 1 100.00 Using index condition Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_easyblog/includes/utils.php:330 16 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/category.php:1753 15 EasyBlogModelCategory->preloadByPosts() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:721 14 EasyBlogCache->cacheCategories() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:372 13 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 12 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 11 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954 10 EB::formatter() JROOT/components/com_easyblog/views/tags/view.html.php:223 9 EasyBlogViewTags->tag() JROOT/components/com_easyblog/controllers/controller.php:103 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.77 ms Nach letzter Abfrage: 0.75 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 25.067 MB Zeilen zurückgegeben: 33
select a.*, b.`post_id`
from `kyhul_easyblog_tag` as a
inner join `kyhul_easyblog_post_tag` as b
on a.`id` = b.`tag_id`
where b.`post_id` IN (1058,1057,1047,1046,1035,22,21,9)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b NULL range easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id easyblog_post_tag_post_id 8 NULL 26 100.00 Using index condition 1 SIMPLE a NULL eq_ref PRIMARY PRIMARY 8 db139985_7.b.tag_id 1 100.00 NULL Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_easyblog/includes/utils.php:330 16 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/tags.php:924 15 EasyBlogModelTags->preloadByPosts() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:803 14 EasyBlogCache->cacheTags() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:377 13 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 12 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 11 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954 10 EB::formatter() JROOT/components/com_easyblog/views/tags/view.html.php:223 9 EasyBlogViewTags->tag() JROOT/components/com_easyblog/controllers/controller.php:103 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.99 ms Nach letzter Abfrage: 1.14 ms Abfragespeichernutzung: 0.261 MB Speichernutzung vor Abfrage: 25.172 MB Zeilen zurückgegeben: 8
select a.*
from `kyhul_easyblog_revisions` as a
where a.`id` IN ( 2324,2585,2305,2314,2251,2181,2182,2216)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL range PRIMARY PRIMARY 8 NULL 8 100.00 Using index condition Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_easyblog/includes/utils.php:330 16 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/revisions.php:625 15 EasyBlogModelRevisions->preload() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:697 14 EasyBlogCache->cacheRevisions() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:382 13 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 12 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 11 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954 10 EB::formatter() JROOT/components/com_easyblog/views/tags/view.html.php:223 9 EasyBlogViewTags->tag() JROOT/components/com_easyblog/controllers/controller.php:103 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.76 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 25.464 MB Zeilen zurückgegeben: 1
select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css`, e.`ordering`
from `kyhul_users` as u
left join `kyhul_easyblog_users` as e
ON u.`id` = e.`id`
where u.`id` = 43id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE e NULL const PRIMARY PRIMARY 8 const 1 100.00 NULL Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 23 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 22 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 20 JFalangDatabase->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:330 19 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/users.php:298 18 EasyBlogModelUsers->getUsersMeta() JROOT/administrator/components/com_easyblog/includes/user/user.php:171 17 EasyBlogUser::loadUsers() JROOT/administrator/components/com_easyblog/includes/user/user.php:63 16 EasyBlogUser::factory() JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099 15 EB::user() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:784 14 EasyBlogCache->cacheAuthors() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:387 13 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 12 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 11 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954 10 EB::formatter() JROOT/components/com_easyblog/views/tags/view.html.php:223 9 EasyBlogViewTags->tag() JROOT/components/com_easyblog/controllers/controller.php:103 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.50 ms Nach letzter Abfrage: 0.51 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 25.485 MB Zeilen zurückgegeben: 17
SHOW FULL COLUMNS
FROM `kyhul_users`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `kyhul_users`Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 31 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 30 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1701 29 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 28 JFalangDatabase->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 27 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 26 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 25 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 24 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:328 23 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 22 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 21 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 20 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 19 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 18 Joomla\CMS\Factory::getUser() JROOT/administrator/components/com_easyblog/includes/user/user.php:218 17 EasyBlogUser::loadUsers() JROOT/administrator/components/com_easyblog/includes/user/user.php:63 16 EasyBlogUser::factory() JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099 15 EB::user() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:784 14 EasyBlogCache->cacheAuthors() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:387 13 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 12 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 11 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954 10 EB::formatter() JROOT/components/com_easyblog/views/tags/view.html.php:223 9 EasyBlogViewTags->tag() JROOT/components/com_easyblog/controllers/controller.php:103 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 25.519 MB Zeilen zurückgegeben: 1
SELECT *
FROM `kyhul_users`
WHERE `id` = 43id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kyhul_users NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 29 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 28 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1701 27 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 26 JFalangDatabase->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:416 25 JFalangDatabase->loadObject() JROOT/plugins/system/falangdriver/falang_database.php:351 24 JFalangDatabase->_loadObject() JROOT/plugins/system/falangdriver/falang_database.php:434 23 JFalangDatabase->loadAssoc() JROOT/libraries/src/Table/User.php:87 22 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 21 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 20 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 19 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 18 Joomla\CMS\Factory::getUser() JROOT/administrator/components/com_easyblog/includes/user/user.php:218 17 EasyBlogUser::loadUsers() JROOT/administrator/components/com_easyblog/includes/user/user.php:63 16 EasyBlogUser::factory() JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099 15 EB::user() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:784 14 EasyBlogCache->cacheAuthors() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:387 13 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 12 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 11 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954 10 EB::formatter() JROOT/components/com_easyblog/views/tags/view.html.php:223 9 EasyBlogViewTags->tag() JROOT/components/com_easyblog/controllers/controller.php:103 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.89 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 26.194 MB Zeilen zurückgegeben: 1
SELECT `g`.`id`,`g`.`title`
FROM `kyhul_usergroups` AS g
INNER JOIN `kyhul_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 43id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY PRIMARY 4 const 1 100.00 Using index 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 db139985_7.m.group_id 1 100.00 NULL Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# Aufrufer Datei und Zeilennummer 27 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 26 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1701 25 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 24 JFalangDatabase->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:459 23 JFalangDatabase->loadAssocList() JROOT/libraries/src/Table/User.php:112 22 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 21 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 20 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 19 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 18 Joomla\CMS\Factory::getUser() JROOT/administrator/components/com_easyblog/includes/user/user.php:218 17 EasyBlogUser::loadUsers() JROOT/administrator/components/com_easyblog/includes/user/user.php:63 16 EasyBlogUser::factory() JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099 15 EB::user() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:784 14 EasyBlogCache->cacheAuthors() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:387 13 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 12 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 11 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954 10 EB::formatter() JROOT/components/com_easyblog/views/tags/view.html.php:223 9 EasyBlogViewTags->tag() JROOT/components/com_easyblog/controllers/controller.php:103 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 1.98 ms Nach letzter Abfrage: 0.50 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 26.218 MB Zeilen zurückgegeben: 0
select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value`
from `kyhul_easyblog_category_fields_groups` as a
inner join `kyhul_easyblog_post_category` as p
on `a`.`category_id` = `p`.`category_id`
inner join `kyhul_easyblog_fields_groups` as fg
on `a`.`group_id` = `fg`.`id`
inner join `kyhul_easyblog_fields` as f
on `fg`.`id` = `f`.`group_id`
left join `kyhul_easyblog_fields_values` as fv
on `fv`.`field_id` = `f`.`id`
and `fv`.`post_id` = `p`.`post_id`
LEFT JOIN `kyhul_easyblog_fields_groups_acl` AS acl
ON fg.`id` = acl.`group_id`
where p.post_id IN (1058,1057,1047,1046,1035,22,21,9)
AND ( acl.`acl_id` IN(1)
AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_easyblog/includes/utils.php:330 16 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/fields.php:309 15 EasyBlogModelFields->preloadFields() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:484 14 EasyBlogCache->cacheFields() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:392 13 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 12 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 11 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954 10 EB::formatter() JROOT/components/com_easyblog/views/tags/view.html.php:223 9 EasyBlogViewTags->tag() JROOT/components/com_easyblog/controllers/controller.php:103 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 0.47 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 26.241 MB Zeilen zurückgegeben: 8
select *
from `kyhul_easyblog_meta`
where `content_id` in (1058,1057,1047,1046,1035,22,21,9)
and `type` = 'post'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kyhul_easyblog_meta NULL range idx_meta_content_type idx_meta_content_type 86 NULL 8 100.00 Using index condition Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_easyblog/includes/utils.php:330 16 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/metas.php:393 15 EasyBlogModelMetas->preloadPostMetas() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:413 14 EasyBlogCache->cacheMetas() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:397 13 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 12 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 11 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954 10 EB::formatter() JROOT/components/com_easyblog/views/tags/view.html.php:223 9 EasyBlogViewTags->tag() JROOT/components/com_easyblog/controllers/controller.php:103 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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 - Abfragezeit: 8.88 ms Nach letzter Abfrage: 15.02 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 28.757 MB Zeilen zurückgegeben: 5
select *
from kyhul_languagesid 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 NULL Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)# 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/administrator/components/com_easyblog/includes/utils.php:330 18 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/includes/router.php:315 17 EBR::getSiteLanguageTag() JROOT/administrator/components/com_easyblog/includes/post/post.php:6569 16 EasyBlogPost->normalizeBlogPermalink() JROOT/administrator/components/com_easyblog/includes/post/post.php:6462 15 EasyBlogPost->getPermalink() JROOT/templates/ammon_v2/html/com_easyblog/blogs/latest/default.main.php:92 14 include JROOT/templates/ammon_v2/html/com_easyblog/blogs/latest/default.main.php JROOT/administrator/components/com_easyblog/includes/themes/themes.php:608 13 EasyBlogThemes->output() JROOT/components/com_easyblog/themes/wireframe/tags/item.php:71 12 include JROOT/components/com_easyblog/themes/wireframe/tags/item.php JROOT/administrator/components/com_easyblog/includes/themes/themes.php:608 11 EasyBlogThemes->output() JROOT/components/com_easyblog/views/views.php:187 10 EasyBlogView->display() JROOT/components/com_easyblog/views/tags/view.html.php:246 9 EasyBlogViewTags->tag() JROOT/components/com_easyblog/controllers/controller.php:103 8 EasyBlogController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_easyblog/easyblog.php:36 6 require_once JROOT/components/com_easyblog/easyblog.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