Standort: Einbürgerung und Staatsangehörigkeiten

Script duration: 125.15 ms

Inline-Log

1. 37.53ms: Query (5.62 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. 79.12ms: Query (0.38 ms) - Rows: 0 - Trace...
   • 2) Doctrine_Query::_execute("324967")

     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)) -- 324967

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

     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)) -- 324967

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

     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 -- 392249

5. 100.54ms: Query (0.030000000000001 ms) - Rows: 0 - Trace...
   • 2) Doctrine_Query::_execute("318998", "324967")

     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)) -- 318998", "324967

6. 103.19ms: Query (0.019999999999996 ms) - Rows: 0 - Trace...
   • 2) Doctrine_Query::_execute("392249", "318998")

     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 = ?) -- 392249", "318998

7. 105.45ms: Query (0.019999999999996 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

8. 111.8ms: Query (0.019999999999996 ms) - Rows: 0 - Trace...
   • 2) Doctrine_Query::_execute("324967")

     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 -- 324967

Request-Data

Array
(
)

Testing function