Joomla!-Debug-KonsoleSitzung __default Profil zum Laufzeitverhalten Zeit Speicher Zeit: 0,0 ms / 0,0 ms Speicher: 0,443 MB / 0,44 MB Application: afterLoad Zeit: 118,8 ms / 118,8 ms Speicher: 3,234 MB / 3,68 MB Application: afterInitialise Zeit: 38,0 ms / 156,8 ms Speicher: 0,831 MB / 4,51 MB Application: afterRoute Zeit: 81,0 ms / 237,9 ms Speicher: 1,477 MB / 5,99 MB Application: afterDispatch Zeit: 22,7 ms / 260,6 ms Speicher: 0,313 MB / 6,30 MB Application: beforeRenderModule mod_menu (Footer Menu) Zeit: 13,7 ms / 274,3 ms Speicher: 0,192 MB / 6,49 MB Application: afterRenderModule mod_menu (Footer Menu) Zeit: 0,2 ms / 274,6 ms Speicher: 0,000 MB / 6,49 MB Application: beforeRenderModule mod_zensocial (We are Social) Zeit: 3,9 ms / 278,5 ms Speicher: 0,020 MB / 6,51 MB Application: afterRenderModule mod_zensocial (We are Social) Zeit: 0,7 ms / 279,2 ms Speicher: 0,005 MB / 6,52 MB Application: beforeRenderModule mod_zentools (slider_home) Zeit: 76,0 ms / 355,6 ms Speicher: 1,000 MB / 7,76 MB Application: afterRenderModule mod_zentools (slider_home) Zeit: 0,0 ms / 356,2 ms Speicher: 0,000 MB / 7,60 MB Application: beforeRenderModule mod_search (Search) Zeit: 4,0 ms / 360,9 ms Speicher: 0,000 MB / 7,62 MB Application: afterRenderModule mod_search (Search) Zeit: 125,0 ms / 486,8 ms Speicher: 2,000 MB / 10,06 MB Application: afterRender Datenbankabfragen gesamt: 42,2 ms Speichernutzung 10,46 MB (10.966.056 Bytes) Datenbankabfragen 55 ausgeführte Abfragen 42,2 ms 26 Duplikate gefunden!2 Duplikate: #9 #17 2 Duplikate: #22 #27 2 Duplikate: #23 #28 2 Duplikate: #24 #29 2 Duplikate: #25 #30 8 Duplikate: #31 #33 #35 #37 #39 #41 #43 #45 8 Duplikate: #32 #34 #36 #38 #40 #42 #44 #46 Abfragezeit: 0,92 ms Abfragespeichernutzung: 0,010 MB Speichernutzung vor Abfrage: 1,506 MB Zeilen zurückgegeben: 1 SELECT `data` FROM `d2qpi_session` WHERE `session_id` = 'pvn2dk0a1s5ic14hs221ilvtp4'Erklären idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEd2qpi_sessionconstPRIMARYPRIMARY602const1 Profil (Profile) StatusDurationstarting0,1 msWaiting for query cache lock0,0 mschecking query cache for query0,1 mschecking permissions0,0 msOpening tables0,0 msSystem lock0,0 msWaiting for query cache lock0,0 msinit0,0 msoptimizing0,0 msstatistics0,1 mspreparing0,0 msexecuting0,0 msSending data0,0 msend0,0 msquery end0,0 msclosing tables0,0 msfreeing items0,0 msWaiting for query cache lock0,0 msfreeing items0,0 msWaiting for query cache lock0,0 msfreeing items0,0 msstoring result in query cache0,0 mslogging slow query0,0 mscleaning up0,0 ms Aufrufstapel (Call Stack) JROOT/libraries/joomla/session/storage/database.php:44 JROOT/libraries/joomla/session/session.php:665 JROOT/libraries/joomla/session/session.php:603 JROOT/libraries/cms/application/cms.php:739 JROOT/libraries/cms/application/cms.php:131 JROOT/libraries/cms/application/site.php:63 JROOT/libraries/cms/application/cms.php:399 JROOT/libraries/joomla/factory.php:125 JROOT/index.php:37 [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen] Abfragezeit: 0,48 ms Nach letzter Abfrage: 2,71 ms Abfragespeichernutzung: 0,004 MB Speichernutzung vor Abfrage: 1,590 MB DELETE FROM `d2qpi_session` WHERE `time` < '1427869701'Erklären „EXPLAIN“ unmöglich für Abfrage: DELETE FROM `d2qpi_session` WHERE `time` < '1427869701' Profil (Profile) StatusDurationstarting0,1 mschecking permissions0,0 msOpening tables0,0 msSystem lock0,0 msinit0,1 msupdating0,0 msend0,0 msquery end0,0 msclosing tables0,0 msfreeing items0,0 mslogging slow query0,0 mscleaning up0,0 ms Aufrufstapel (Call Stack) JROOT/libraries/cms/application/cms.php:756 JROOT/libraries/cms/application/cms.php:131 JROOT/libraries/cms/application/site.php:63 JROOT/libraries/cms/application/cms.php:399 JROOT/libraries/joomla/factory.php:125 JROOT/index.php:37 [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen] Abfragezeit: 0,40 ms Nach letzter Abfrage: 8,51 ms Abfragespeichernutzung: 0,014 MB Speichernutzung vor Abfrage: 1,857 MB Zeilen zurückgegeben: 40 SELECT extension_id AS id, element AS "option", params, enabled FROM d2qpi_extensions WHERE `type` = 'component'Erklären idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEd2qpi_extensionsrefextensionextension62const40Using where Profil (Profile) StatusDurationstarting0,1 msWaiting for query cache lock0,0 mschecking query cache for query0,0 mschecking privileges on cached 0,0 mschecking permissions0,0 mssending cached result to clien0,0 mslogging slow query0,0 mscleaning up0,0 ms Aufrufstapel (Call Stack) JROOT/libraries/joomla/cache/controller/callback.php:157 JROOT/libraries/cms/component/helper.php:434 JROOT/libraries/cms/component/helper.php:43 JROOT/libraries/cms/component/helper.php:119 JROOT/libraries/cms/application/site.php:568 JROOT/libraries/cms/application/site.php:209 JROOT/libraries/cms/application/cms.php:252 JROOT/index.php:40 [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen] Abfragezeit: 2,50 ms Nach letzter Abfrage: 2,29 ms Abfragespeichernutzung: 0,007 MB Speichernutzung vor Abfrage: 1,924 MB Zeilen zurückgegeben: 60 SELECT folder AS type, element AS name, params FROM d2qpi_extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY orderingErklären idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEd2qpi_extensionsrefextensionextension62const79Using where; filesort wurde genutzt Profil (Profile) StatusDurationstarting0,0 msWaiting for query cache lock0,0 mschecking query cache for query0,1 mschecking permissions0,0 msOpening tables0,0 msSystem lock0,0 msWaiting for query cache lock0,1 msinit0,1 msoptimizing0,0 msstatistics0,2 mspreparing0,0 msexecuting0,0 msSorting result0,9 msSending data0,6 msend0,0 msquery end0,0 msclosing tables0,0 msfreeing items0,0 msWaiting for query cache lock0,0 msfreeing items0,0 msWaiting for query cache lock0,0 msfreeing items0,0 msstoring result in query cache0,0 mslogging slow query0,0 mscleaning up0,0 ms Aufrufstapel (Call Stack) JROOT/libraries/cms/plugin/helper.php:310 JROOT/libraries/cms/plugin/helper.php:163 JROOT/libraries/cms/application/site.php:573 JROOT/libraries/cms/application/site.php:209 JROOT/libraries/cms/application/cms.php:252 JROOT/index.php:40 [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen] Abfragezeit: 2,18 ms Nach letzter Abfrage: 74,07 ms Abfragespeichernutzung: 0,017 MB Speichernutzung vor Abfrage: 3,813 MB Zeilen zurückgegeben: 33 SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM d2qpi_menu AS m LEFT JOIN d2qpi_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lftErklären idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEmrefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const1Using where; filesort wurde genutzt1SIMPLEeeq_refPRIMARYPRIMARY4db1163884-cms1.m.component_id1 Profil (Profile) StatusDurationstarting0,1 msWaiting for query cache lock0,0 mschecking query cache for query0,1 mschecking permissions0,0 mschecking permissions0,0 msOpening tables0,1 msSystem lock0,0 msWaiting for query cache lock0,0 msinit0,1 msoptimizing0,0 msstatistics0,2 mspreparing0,0 msexecuting0,0 msSorting result0,4 msSending data0,5 msWaiting for query cache lock0,0 msSending data0,2 msend0,0 msquery end0,0 msclosing tables0,0 msfreeing items0,0 msWaiting for query cache lock0,0 msfreeing items0,0 msWaiting for query cache lock0,0 msfreeing items0,0 msstoring result in query cache0,0 mslogging slow query0,0 mscleaning up0,0 ms Aufrufstapel (Call Stack) JROOT/libraries/cms/menu/site.php:45 JROOT/libraries/cms/menu/menu.php:64 JROOT/libraries/cms/menu/menu.php:118 JROOT/libraries/cms/application/cms.php:424 JROOT/libraries/cms/application/site.php:272 JROOT/libraries/cms/router/site.php:57 JROOT/libraries/cms/router/router.php:196 JROOT/libraries/cms/application/cms.php:520 JROOT/libraries/cms/application/site.php:407 JROOT/libraries/cms/application/cms.php:1088 JROOT/libraries/cms/application/site.php:747 JROOT/libraries/cms/application/site.php:215 JROOT/libraries/cms/application/cms.php:252 JROOT/index.php:40 [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen] Abfragezeit: 1,20 ms Nach letzter Abfrage: 9,87 ms Abfragespeichernutzung: 0,010 MB Speichernutzung vor Abfrage: 4,153 MB Zeilen zurückgegeben: 3 SELECT id, home, template, s.params FROM d2qpi_template_styles as s LEFT JOIN d2qpi_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1Erklären idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEsALLidx_templateES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL5Using where1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid303db1163884-cms1.s.template,const1Using where Profil (Profile) StatusDurationstarting0,0 msWaiting for query cache lock0,0 mschecking query cache for query0,1 mschecking permissions0,0 mschecking permissions0,0 msOpening tables0,0 msSystem lock0,0 msWaiting for query cache lock0,1 msinit0,0 msoptimizing0,0 msstatistics0,2 mspreparing0,0 msexecuting0,0 msSending data0,2 msend0,0 msquery end0,0 msclosing tables0,0 msfreeing items0,0 msWaiting for query cache lock0,0 msfreeing items0,2 msWaiting for query cache lock0,0 msfreeing items0,0 msstoring result in query cache0,0 mslogging slow query0,0 mscleaning up0,0 ms Aufrufstapel (Call Stack) JROOT/libraries/cms/application/site.php:484 JROOT/plugins/system/t3/includes/core/t3.php:308 JROOT/plugins/system/t3/t3.php:81 JROOT/libraries/joomla/event/event.php:69 JROOT/libraries/joomla/event/dispatcher.php:160 JROOT/libraries/joomla/application/base.php:83 JROOT/libraries/cms/application/cms.php:1098 JROOT/libraries/cms/application/site.php:747 JROOT/libraries/cms/application/site.php:215 JROOT/libraries/cms/application/cms.php:252 JROOT/index.php:40 [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen] Abfragezeit: 0,32 ms Nach letzter Abfrage: 14,36 ms Abfragespeichernutzung: 0,014 MB Speichernutzung vor Abfrage: 4,358 MB Zeilen zurückgegeben: 1 SELECT extension_id AS id, element AS "option", params, enabled FROM d2qpi_extensions WHERE `type` = 'library' AND `element` = 'joomla'Erklären idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEd2qpi_extensionsrefelement_clientid,element_folder_clientid,extensionextension364const,const1Using where Profil (Profile) StatusDurationstarting0,0 msWaiting for query cache lock0,0 mschecking query cache for query0,0 mschecking privileges on cached 0,0 mschecking permissions0,0 mssending cached result to clien0,0 mslogging slow query0,0 mscleaning up0,0 ms Aufrufstapel (Call Stack) JROOT/libraries/joomla/cache/controller/callback.php:157 JROOT/libraries/cms/library/helper.php:156 JROOT/libraries/cms/library/helper.php:47 JROOT/libraries/cms/library/helper.php:90 JROOT/libraries/cms/version/version.php:177 JROOT/libraries/joomla/factory.php:736 JROOT/libraries/joomla/factory.php:216 JROOT/plugins/system/jbtype/jbtype.php:29 JROOT/libraries/joomla/event/event.php:69 JROOT/libraries/joomla/event/dispatcher.php:160 JROOT/libraries/joomla/application/base.php:83 JROOT/libraries/cms/application/cms.php:1098 JROOT/libraries/cms/application/site.php:747 JROOT/libraries/cms/application/site.php:215 JROOT/libraries/cms/application/cms.php:252 JROOT/index.php:40 [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen] Abfragezeit: 1,08 ms Nach letzter Abfrage: 0,47 ms Abfragespeichernutzung: 0,010 MB Speichernutzung vor Abfrage: 4,356 MB UPDATE `d2qpi_extensions` SET `params` = '{\"mediaversion\":\"dfdc88d4213a2cb034b8a624ed0ae7c6\"}' WHERE `type` = 'library' AND `element` = 'joomla'Erklären „EXPLAIN“ unmöglich für Abfrage: UPDATE `d2qpi_extensions` SET `params` = '{\"mediaversion\":\"dfdc88d4213a2cb034b8a624ed0ae7c6\"}' WHERE `type` = 'library' AND `element` = 'joomla' Profil (Profile) StatusDurationstarting0,1 mschecking permissions0,0 msOpening tables0,0 msSystem lock0,0 msinit0,3 msUpdating0,1 msend0,0 msWaiting for query cache lock0,0 msend0,3 msquery end0,0 msclosing tables0,0 msfreeing items0,0 mslogging slow query0,0 mscleaning up0,0 ms Aufrufstapel (Call Stack) JROOT/libraries/cms/library/helper.php:119 JROOT/libraries/cms/version/version.php:228 JROOT/libraries/cms/version/version.php:187 JROOT/libraries/joomla/factory.php:736 JROOT/libraries/joomla/factory.php:216 JROOT/plugins/system/jbtype/jbtype.php:29 JROOT/libraries/joomla/event/event.php:69 JROOT/libraries/joomla/event/dispatcher.php:160 JROOT/libraries/joomla/application/base.php:83 JROOT/libraries/cms/application/cms.php:1098 JROOT/libraries/cms/application/site.php:747 JROOT/libraries/cms/application/site.php:215 JROOT/libraries/cms/application/cms.php:252 JROOT/index.php:40 [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen] Abfragezeit: 0,20 ms Nach letzter Abfrage: 3,88 ms Abfragespeichernutzung: 0,013 MB Speichernutzung vor Abfrage: 4,498 MB Zeilen zurückgegeben: 1 Doppelte Abfragen: #17 SELECT alias FROM d2qpi_sermon_sermons WHERE id = 23Erklären idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEd2qpi_sermon_sermonsconstPRIMARYPRIMARY4const1 Profil (Profile) StatusDurationstarting0,0 msWaiting for query cache lock0,0 mschecking query cache for query0,0 mschecking privileges on cached 0,0 mschecking permissions0,0 mssending cached result to clien0,0 mslogging slow query0,0 mscleaning up0,0 ms Aufrufstapel (Call Stack) JROOT/components/com_sermonspeaker/router.php:88 JROOT/libraries/cms/router/site.php:483 JROOT/libraries/cms/router/site.php:452 JROOT/libraries/cms/router/router.php:280 JROOT/libraries/cms/router/site.php:134 JROOT/libraries/joomla/application/route.php:62 JROOT/plugins/system/sef/sef.php:45 JROOT/libraries/joomla/event/event.php:69 JROOT/libraries/joomla/event/dispatcher.php:160 JROOT/libraries/joomla/application/base.php:83 JROOT/libraries/cms/application/cms.php:1098 JROOT/libraries/cms/application/site.php:747 JROOT/libraries/cms/application/site.php:215 JROOT/libraries/cms/application/cms.php:252 JROOT/index.php:40 [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen] Abfragezeit: 0,20 ms Nach letzter Abfrage: 2,01 ms Abfragespeichernutzung: 0,008 MB Speichernutzung vor Abfrage: 4,559 MB Zeilen zurückgegeben: 1 SELECT * FROM d2qpi_languages WHERE published=1 ORDER BY ordering ASCErklären idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEd2qpi_languagesALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL2Using where; filesort wurde genutzt Profil (Profile) StatusDurationstarting0,0 msWaiting for query cache lock0,0 mschecking query cache for query0,0 mschecking privileges on cached 0,0 mschecking permissions0,0 mssending cached result to clien0,0 mslogging slow query0,0 mscleaning up0,0 ms Aufrufstapel (Call Stack) JROOT/libraries/joomla/language/helper.php:164 JROOT/libraries/cms/application/site.php:329 JROOT/libraries/cms/application/site.php:135 JROOT/libraries/cms/application/site.php:230 JROOT/libraries/cms/application/cms.php:252 JROOT/index.php:40 [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen] Abfragezeit: 1,94 ms Nach letzter Abfrage: 30,99 ms Abfragespeichernutzung: 0,019 MB Speichernutzung vor Abfrage: 5,051 MB Zeilen zurückgegeben: 1 SELECT sermon.id, sermon.speaker_id, sermon.series_id, sermon.alias, sermon.catid, CASE WHEN CHAR_LENGTH(sermon.alias) THEN CONCAT_WS(':', sermon.id, sermon.alias) ELSE sermon.id END as slug,sermon.audiofile, sermon.videofile, sermon.title, sermon.sermon_number, sermon.sermon_date, sermon.picture, sermon.checked_out, sermon.checked_out_time, sermon.sermon_time, sermon.notes, sermon.state, sermon.language, sermon.hits, sermon.addfile, sermon.addfileDesc, sermon.metakey, sermon.metadesc, sermon.custom1, sermon.custom2, sermon.created, sermon.created_by, sermon.audiofilesize, sermon.videofilesize, sermon.metadata,GROUP_CONCAT(script.book,"|",script.cap1,"|",script.vers1,"|",script.cap2,"|",script.vers2,"|",script.text ORDER BY script.ordering ASC SEPARATOR "!") AS scripture,user.name AS author,c.title AS category_title, c.access AS category_access, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,speakers.title AS speaker_title, speakers.pic AS pic, speakers.state as speaker_state,speakers.intro, speakers.bio, speakers.website, CASE WHEN CHAR_LENGTH(speakers.alias) THEN CONCAT_WS(':', speakers.id, speakers.alias) ELSE speakers.id END as speaker_slug,c_speaker.access AS speaker_category_access,series.title AS series_title, series.avatar, series.state as series_state, CASE WHEN CHAR_LENGTH(series.alias) THEN CONCAT_WS(':', series.id, series.alias) ELSE series.id END as series_slug ,c_series.access AS series_category_access FROM d2qpi_sermon_sermons AS sermon LEFT JOIN d2qpi_sermon_scriptures AS script ON script.sermon_id = sermon.id LEFT JOIN d2qpi_users AS user ON user.id = sermon.created_by LEFT JOIN d2qpi_categories AS c on c.id = sermon.catid LEFT JOIN d2qpi_sermon_speakers AS speakers on speakers.id = sermon.speaker_id LEFT JOIN d2qpi_categories AS c_speaker on c_speaker.id = speakers.catid LEFT JOIN d2qpi_sermon_series AS series on series.id = sermon.series_id LEFT JOIN d2qpi_categories AS c_series on c_series.id = series.catid WHERE (sermon.speaker_id = 0 OR speakers.catid = 0 OR c_speaker.published = 1) AND (sermon.series_id = 0 OR series.catid = 0 OR c_series.published = 1) AND sermon.id = 23 AND sermon.state = 1 GROUP BY sermon.id