- 44.03ms: Query (5.16 ms) - - Trace...
FROM Model_User u ORDER BY u.name
- 86.23ms: Query (0.42999999999999 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute("122953")
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)) -- 122953
- 90.55ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
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)) -- 122953
- 101.78ms: Query (0.019999999999996 ms) - Rows: 0 - Trace...
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 -- 389871
- 115.61ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
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)) -- 325661", "122953
- 119.29ms: Query (0.019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "325661
- 124.45ms: Query (0.019999999999996 ms) - Rows: 0 - Trace...
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)) -- 324713", "122953
- 127.02ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "324713
- 132.3ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
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)) -- 325685", "122953
- 134.71ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "325685
- 139.83ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
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)) -- 325687", "122953
- 143.61ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "325687
- 148.9ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
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)) -- 325831", "122953
- 151.4ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "325831
- 156.66ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
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)) -- 325827", "122953
- 159.09ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "325827
- 163.47ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
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)) -- 325325", "122953
- 166.81ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "325325
- 171.68ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
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)) -- 325821", "122953
- 174.19ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "325821
- 179.67ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
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)) -- 325333", "122953
- 182.15ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "325333
- 187.21ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
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)) -- 325407", "122953
- 190.68ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "325407
- 195.44ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
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)) -- 325409", "122953
- 197.86ms: Query (0.0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "325409
- 203.35ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
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)) -- 324161", "122953
- 205.95ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "324161
- 210.68ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
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)) -- 121494", "122953
- 213.21ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "121494
- 218.65ms: Query (0.0099999999999909 ms) - Rows: 0 - Trace...
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)) -- 325035", "122953
- 221.3ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "325035
- 227.32ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
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)) -- 325413", "122953
- 229.73ms: Query (0.010000000000019 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "325413
- 234.14ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
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)) -- 325823", "122953
- 236.61ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "325823
- 243.19ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
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)) -- 325405", "122953
- 245.87ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "325405
- 252.61ms: Query (0.030000000000001 ms) - Rows: 0 - Trace...
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)) -- 325851", "122953
- 255.11ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "325851
- 259.52ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
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)) -- 324715", "122953
- 262.37ms: Query (0.020000000000039 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "324715
- 268.12ms: Query (0.020000000000039 ms) - Rows: 0 - Trace...
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)) -- 325663", "122953
- 270.66ms: Query (0.020000000000039 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389871", "325663
- 272.62ms: Query (0.03000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM translation t WHERE (t.translation_id = ?)0
- 280.39ms: Query (0.04000000000002 ms) - Rows: 0 - Trace...
SELECT * FROM xtranslation x WHERE (x.informationsobjekt_id = ? AND x.publish = 1) ORDER BY x.language -- 122953
- 282.88ms:
/opt/dldb/application/modules/default/views/scripts/ort/_rightsidebar_kontakt.phtml +239
function include < [no object]
http://www.berlin.de/sen/finanzen/steuern/finanzaemter/prenzlauer-berg/
große Karte 
