Standort: Sozialamt Mitte - Ambulante Hilfe zur Pflege / Landespflegegeld

Script duration: 167.95 ms

Inline-Log

1. 48.49ms: Query (7.09 ms) - - Trace...
   • 1) Doctrine_Query::_execute("")

     FROM Model_User u ORDER BY u.name

   • 2) Doctrine_Query_Abstract::execute @ /opt/dldb/application/library/Model/User.php::27
   • 3) Model_User::buildCache @ /opt/dldb/application/bootstrap.php::200
   • 4) ::require @ /opt/dldb/public/index.php::2

   FROM Model_User u ORDER BY u.name

2. 91.88ms: Query (0.5 ms) - Rows: 0 - Trace...
   • 2) Doctrine_Query::_execute("325489")

     FROM Model_Dienstleister d LEFT JOIN d.Xuserort x LEFT JOIN x.Behoerde b WHERE d.id = ? AND d.is_zentral = 0 AND (d.publish = 1 OR d.publish IS NULL) AND (d.anzeige IN ('both','public') OR d.anzeige IS NULL) AND (b.publish = 1 OR b.publish IS NULL) AND (b.anzeige IN ('both','public') OR b.anzeige IS NULL)

   • 4) Doctrine_Query::fetchOne @ /opt/dldb/application/modules/default/controllers/OrtController.php::295
   • 5) OrtController::getOrtFromRequest @ /opt/dldb/application/modules/default/controllers/OrtController.php::232
   • 6) OrtController::detailAction @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php::516
   • 9) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

   SELECT * FROM dienstleister d LEFT JOIN xuserort x ON d.id = x.dienstleister_id LEFT JOIN behoerden b ON x.id = b.rid WHERE (d.id = ? AND d.is_zentral = 0 AND (d.publish = 1 OR d.publish IS NULL) AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL) AND (b.publish = 1 OR b.publish IS NULL) AND (b.anzeige IN ('both', 'public') OR b.anzeige IS NULL)) -- 325489

3. 96.52ms: Query (0.019999999999996 ms) - Rows: 0 - Trace...
   • 2) Doctrine_Query::_execute("325489")

     FROM Model_Xuserort as x LEFT JOIN x.Behoerde b WHERE x.dienstleister_id = ? AND (b.publish = 1 OR b.publish IS NULL) AND (b.anzeige IN ('both','public') OR b.anzeige IS NULL)

   • 3) Doctrine_Query_Abstract::execute @ /opt/dldb/application/library/Model/Dienstleister.php::1015
   • 4) Model_Dienstleister::getXuserort @ /opt/dldb/application/library/DLDB/Doctrine/Record.php::29
   • 5) DLDB_Doctrine_Record::get @ /opt/dldb/vendor/lexpress/doctrine1/lib/Doctrine/Access.php::123
   • 10) Doctrine_Query::fetchOne @ /opt/dldb/application/modules/default/controllers/OrtController.php::295
   • 11) OrtController::getOrtFromRequest @ /opt/dldb/application/modules/default/controllers/OrtController.php::232
   • 12) OrtController::detailAction @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php::516
   • 15) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

   SELECT * FROM xuserort x LEFT JOIN behoerden b ON x.id = b.rid WHERE (x.dienstleister_id = ? AND (b.publish = 1 OR b.publish IS NULL) AND (b.anzeige IN ('both', 'public') OR b.anzeige IS NULL)) -- 325489

4. 108.65ms: Query (0.019999999999996 ms) - Rows: 0 - Trace...
   • 2) Doctrine_Query::_execute("403326")

     FROM Model_Xdienst x LEFT JOIN x.Dienstleistung d WHERE x.dienstleister = ? AND d.lastpublished > 0 AND (d.publish = 1 OR d.publish IS NULL) AND (d.anzeige IN ('both','public') OR d.anzeige IS NULL) GROUP BY d.id ORDER BY d.name

   • 3) Doctrine_Query_Abstract::execute @ /opt/dldb/application/library/Model/Dienstleister.php::984
   • 4) Model_Dienstleister::getXDienstUniqueDl @ /opt/dldb/application/library/DLDB/Doctrine/Record.php::29
   • 5) DLDB_Doctrine_Record::get @ /opt/dldb/vendor/lexpress/doctrine1/lib/Doctrine/Access.php::72
   • 6) Doctrine_Access::__get @ /opt/dldb/application/modules/default/views/scripts/ort/detail.phtml::262
   • 7) ::include @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/View.php::157
   • 16) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

   SELECT * FROM xdienst x LEFT JOIN dienstleistungen d ON x.dienstleistung = d.id WHERE (x.dienstleister = ? AND d.lastpublished > 0 AND (d.publish = 1 OR d.publish IS NULL) AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) GROUP BY d.id ORDER BY d.name -- 403326

5. 118.28ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
   • 2) Doctrine_Query::_execute("324394", "325489")

     FROM Model_Xpartner x LEFT JOIN x.Ansprechpartner a LEFT JOIN a.Ort d WHERE x.dienstleistung = ? AND a.dienstleister = ? AND a.rid = d.rid AND d.publish = 1 AND (d.anzeige IN ('both','public') OR d.anzeige IS NULL)

   • 3) Doctrine_Query_Abstract::execute @ /opt/dldb/application/library/Model/Dienstleistungen.php::1455
   • 4) Model_Dienstleistungen::getDlAnsprechpartner @ /opt/dldb/application/modules/default/views/scripts/ort/detail.phtml::290
   • 5) ::include @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/View.php::157
   • 14) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

   SELECT * FROM xpartner x LEFT JOIN ansprechpartner a ON x.ansprechpartner = a.id LEFT JOIN dienstleister d ON a.dienstleister = d.id WHERE (x.dienstleistung = ? AND a.dienstleister = ? AND a.rid = d.rid AND d.publish = 1 AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 324394", "325489

6. 121.19ms: Query (0.019999999999996 ms) - Rows: 0 - Trace...
   • 2) Doctrine_Query::_execute("403326", "324394")

     FROM Model_Xdienst x WHERE x.dienstleister = ? AND x.dienstleistung = ?

   • 3) Doctrine_Query_Abstract::execute @ /opt/dldb/application/library/Model/Dienstleister.php::1468
   • 4) Model_Dienstleister::getZustaendigkeitsHinweise @ /opt/dldb/application/modules/default/views/scripts/ort/detail.phtml::318
   • 5) ::include @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/View.php::157
   • 14) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

   SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 403326", "324394

7. 126.04ms: Query (0.019999999999996 ms) - Rows: 0 - Trace...
   • 2) Doctrine_Query::_execute("121829", "325489")

     FROM Model_Xpartner x LEFT JOIN x.Ansprechpartner a LEFT JOIN a.Ort d WHERE x.dienstleistung = ? AND a.dienstleister = ? AND a.rid = d.rid AND d.publish = 1 AND (d.anzeige IN ('both','public') OR d.anzeige IS NULL)

   • 3) Doctrine_Query_Abstract::execute @ /opt/dldb/application/library/Model/Dienstleistungen.php::1455
   • 4) Model_Dienstleistungen::getDlAnsprechpartner @ /opt/dldb/application/modules/default/views/scripts/ort/detail.phtml::290
   • 5) ::include @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/View.php::157
   • 14) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

   SELECT * FROM xpartner x LEFT JOIN ansprechpartner a ON x.ansprechpartner = a.id LEFT JOIN dienstleister d ON a.dienstleister = d.id WHERE (x.dienstleistung = ? AND a.dienstleister = ? AND a.rid = d.rid AND d.publish = 1 AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 121829", "325489

8. 130.23ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
   • 2) Doctrine_Query::_execute("403326", "121829")

     FROM Model_Xdienst x WHERE x.dienstleister = ? AND x.dienstleistung = ?

   • 3) Doctrine_Query_Abstract::execute @ /opt/dldb/application/library/Model/Dienstleister.php::1468
   • 4) Model_Dienstleister::getZustaendigkeitsHinweise @ /opt/dldb/application/modules/default/views/scripts/ort/detail.phtml::318
   • 5) ::include @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/View.php::157
   • 14) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

   SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 403326", "121829

9. 134.73ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
   • 2) Doctrine_Query::_execute("324474", "325489")

     FROM Model_Xpartner x LEFT JOIN x.Ansprechpartner a LEFT JOIN a.Ort d WHERE x.dienstleistung = ? AND a.dienstleister = ? AND a.rid = d.rid AND d.publish = 1 AND (d.anzeige IN ('both','public') OR d.anzeige IS NULL)

   • 3) Doctrine_Query_Abstract::execute @ /opt/dldb/application/library/Model/Dienstleistungen.php::1455
   • 4) Model_Dienstleistungen::getDlAnsprechpartner @ /opt/dldb/application/modules/default/views/scripts/ort/detail.phtml::290
   • 5) ::include @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/View.php::157
   • 14) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

   SELECT * FROM xpartner x LEFT JOIN ansprechpartner a ON x.ansprechpartner = a.id LEFT JOIN dienstleister d ON a.dienstleister = d.id WHERE (x.dienstleistung = ? AND a.dienstleister = ? AND a.rid = d.rid AND d.publish = 1 AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 324474", "325489

10. 137.16ms: Query (0.0099999999999909 ms) - Rows: 0 - Trace...
    • 2) Doctrine_Query::_execute("403326", "324474")

      FROM Model_Xdienst x WHERE x.dienstleister = ? AND x.dienstleistung = ?

    • 3) Doctrine_Query_Abstract::execute @ /opt/dldb/application/library/Model/Dienstleister.php::1468
    • 4) Model_Dienstleister::getZustaendigkeitsHinweise @ /opt/dldb/application/modules/default/views/scripts/ort/detail.phtml::318
    • 5) ::include @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/View.php::157
    • 14) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

    SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 403326", "324474

11. 143.3ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
    • 2) Doctrine_Query::_execute("324555", "325489")

      FROM Model_Xpartner x LEFT JOIN x.Ansprechpartner a LEFT JOIN a.Ort d WHERE x.dienstleistung = ? AND a.dienstleister = ? AND a.rid = d.rid AND d.publish = 1 AND (d.anzeige IN ('both','public') OR d.anzeige IS NULL)

    • 3) Doctrine_Query_Abstract::execute @ /opt/dldb/application/library/Model/Dienstleistungen.php::1455
    • 4) Model_Dienstleistungen::getDlAnsprechpartner @ /opt/dldb/application/modules/default/views/scripts/ort/detail.phtml::290
    • 5) ::include @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/View.php::157
    • 14) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

    SELECT * FROM xpartner x LEFT JOIN ansprechpartner a ON x.ansprechpartner = a.id LEFT JOIN dienstleister d ON a.dienstleister = d.id WHERE (x.dienstleistung = ? AND a.dienstleister = ? AND a.rid = d.rid AND d.publish = 1 AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 324555", "325489

12. 145.72ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
    • 2) Doctrine_Query::_execute("403326", "324555")

      FROM Model_Xdienst x WHERE x.dienstleister = ? AND x.dienstleistung = ?

    • 3) Doctrine_Query_Abstract::execute @ /opt/dldb/application/library/Model/Dienstleister.php::1468
    • 4) Model_Dienstleister::getZustaendigkeitsHinweise @ /opt/dldb/application/modules/default/views/scripts/ort/detail.phtml::318
    • 5) ::include @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/View.php::157
    • 14) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

    SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 403326", "324555

13. 147.72ms: Query (0.029999999999973 ms) - Rows: 0 - Trace...
    • 2) Doctrine_Query::_execute("0")

      FROM Model_Translation t WHERE t.translation_id = ?

    • 4) Doctrine_Query::fetchArray @ /opt/dldb/application/library/DLDB/Translate.php::262
    • 5) DLDB_Translate::fetchTranslation @ /opt/dldb/application/library/DLDB/Translate.php::87
    • 6) DLDB_Translate::__construct @ /opt/dldb/application/library/DLDB/Language.php::106
    • 7) DLDB_Language::byLanguageTag @ /opt/dldb/application/library/DLDB/Helper/LanguageSelector.php::35
    • 8) DLDB_Helper_LanguageSelector::languageSelector_static @ /opt/dldb/application/library/DLDB/Helper/LanguageSelector.php::21
    • 9) DLDB_Helper_LanguageSelector::languageSelector @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/View/Abstract.php::349
    • 10) Zend_View_Abstract::__call @ /opt/dldb/application/modules/default/views/scripts/ort/detail.phtml::381
    • 11) ::include @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/View.php::157
    • 20) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

    SELECT * FROM translation t WHERE (t.translation_id = ?)0

14. 154.14ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
    • 2) Doctrine_Query::_execute("325489")

      FROM Model_Xtranslation x WHERE x.informationsobjekt_id = ? AND x.publish = 1 ORDER BY x.language

    • 3) Doctrine_Query_Abstract::execute @ /opt/dldb/application/library/DLDB/Language.php::74
    • 4) DLDB_Language::getTranslations @ /opt/dldb/application/library/DLDB/Helper/LanguageSelector.php::43
    • 5) DLDB_Helper_LanguageSelector::languageSelector_static @ /opt/dldb/application/library/DLDB/Helper/LanguageSelector.php::21
    • 6) DLDB_Helper_LanguageSelector::languageSelector @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/View/Abstract.php::349
    • 7) Zend_View_Abstract::__call @ /opt/dldb/application/modules/default/views/scripts/ort/detail.phtml::381
    • 8) ::include @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/View.php::157
    • 17) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

    SELECT * FROM xtranslation x WHERE (x.informationsobjekt_id = ? AND x.publish = 1) ORDER BY x.language -- 325489

15. 155.93ms:

    /opt/dldb/application/modules/default/views/scripts/ort/_rightsidebar_kontakt.phtml +239
    function include < [no object]

    https://www.berlin.de/ba-mitte/politik-und-verwaltung/aemter/amt-fuer-soziales/hilfe-zur-pflege/

Request-Data

Array
(
)

Testing function