Dienstleistungen: Sicherheit und Notlagen

Script duration: 113.33 ms

Inline-Log

1. 43.38ms: Query (4.8 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. 77.81ms: Query (0.36999999999999 ms) - Rows: 0 - Trace...
   • 2) Doctrine_Query::_execute("sicherheit-notlagen")

     FROM Model_Themen t LEFT JOIN t.Beschreibungen h WHERE t.shortname = ? AND t.publish = 1 AND (t.anzeige IN ('both','public') OR t.anzeige IS NULL) AND (h.anzeige IN ('both','public') OR h.anzeige IS NULL)

   • 3) Doctrine_Query_Abstract::execute @ /opt/dldb/application/modules/default/controllers/DienstleistungController.php::119
   • 4) DienstleistungController::themaAction @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php::516
   • 7) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

   SELECT * FROM themen t LEFT JOIN beschreibung b ON t.rid = b.rid WHERE (t.shortname = ? AND t.publish = 1 AND (t.anzeige IN ('both', 'public') OR t.anzeige IS NULL) AND (b.anzeige IN ('both', 'public') OR b.anzeige IS NULL)) -- sicherheit-notlagen

3. 89.33ms: Query (0.010000000000005 ms) - Rows: 0 - Trace...
   • 2) Doctrine_Query::_execute("324819")

     FROM Model_Xthemen xt LEFT JOIN xt.Thema t LEFT JOIN t.ThemenDienstleistungen tdl LEFT JOIN tdl.Dienstleistung d WHERE t.anzeige != 'hidden' AND t.publish = 1 AND d.publish = 1 AND d.anzeige != 'hidden' AND xt.parent_id = ? ORDER BY d.name

   • 3) Doctrine_Query_Abstract::execute @ /opt/dldb/application/modules/default/controllers/DienstleistungController.php::143
   • 4) DienstleistungController::themaAction @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php::516
   • 7) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

   SELECT * FROM xthemen x LEFT JOIN themen t ON x.id = t.id LEFT JOIN themen_dienstleistungen t2 ON t.id = t2.id LEFT JOIN dienstleistungen d ON t2.dienstleistung_id = d.rid WHERE (t.anzeige != 'hidden' AND t.publish = 1 AND d.publish = 1 AND d.anzeige != 'hidden' AND x.parent_id = ?) ORDER BY d.name -- 324819

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

     FROM Model_ThemenDienstleistungen x LEFT JOIN x.Dienstleistung d WHERE x.id = ? AND d.anzeige != 'hidden' AND d.publish = 1 ORDER BY d.name

   • 3) Doctrine_Query_Abstract::execute @ /opt/dldb/application/modules/default/controllers/DienstleistungController.php::162
   • 4) DienstleistungController::themaAction @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php::516
   • 7) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

   SELECT * FROM themen_dienstleistungen t LEFT JOIN dienstleistungen d ON t.dienstleistung_id = d.rid WHERE (t.id = ? AND d.anzeige != 'hidden' AND d.publish = 1) ORDER BY d.name -- 324819

5. 97.69ms: Query (0.010000000000005 ms) - Rows: 0 - Trace...
   • 2) Doctrine_Query::_execute("0")

     FROM Model_Themen t WHERE t.id = ? AND (t.publish = 1 OR t.publish IS NULL) AND (t.anzeige IN ('both','public') OR t.anzeige IS NULL)

   • 3) Doctrine_Query_Abstract::execute @ /opt/dldb/application/modules/default/controllers/DienstleistungController.php::183
   • 4) DienstleistungController::themaAction @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php::516
   • 7) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

   SELECT * FROM themen t WHERE (t.id = ? AND (t.publish = 1 OR t.publish IS NULL) AND (t.anzeige IN ('both', 'public') OR t.anzeige IS NULL))0

6. 106.6ms: Query (0.019999999999996 ms) - Rows: 0 - Trace...
   • 2) Doctrine_Query::_execute("1", "1", "hidden")

     FROM Model_Themen t WHERE t.isroot = ? AND t.publish = ? AND t.anzeige != ? ORDER BY t.sortierung, t.name

   • 3) Doctrine_Query_Abstract::execute @ /opt/dldb/application/modules/default/controllers/IndexController.php::68
   • 4) IndexController::navigationAction @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php::516
   • 8) Zend_View_Abstract::__call @ /opt/dldb/application/layouts/default.phtml::212
   • 9) ::include @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/View.php::157
   • 15) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20

   SELECT * FROM themen t WHERE (t.isroot = ? AND t.publish = ? AND t.anzeige != ?) ORDER BY t.sortierung, t.name -- 1", "1", "hidden

Request-Data

Array
(
)

Testing function