- 9,46ms: Query (4,95 ms) - - Trace...
FROM Model_User u ORDER BY u.name
- 28,68ms:
/app/application/bootstrap.php +238
function require < [no object]
service.berlin.de
- 34,47ms: Query (0,07 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute("330132")
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 @ /app/application/modules/default/controllers/OrtController.php::296
- 5) OrtController::getOrtFromRequest @ /app/application/modules/default/controllers/OrtController.php::233
- 6) OrtController::detailAction @ /app/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php::516
- 9) Zend_Controller_Front::dispatch @ /app/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)) -- 330132
- 37,83ms: Query (0,019999999999996 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)) -- 330132
- 40,09ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
- 0) Doctrine_Connection_Statement::execute @ /app/application/library/Model/Dienstleister.php::1124
- 1) Model_Dienstleister::getParent @ /app/application/library/Model/Dienstleister.php::1097
- 2) Model_Dienstleister::adressangabe @ /app/application/library/Model/Dienstleister.php::1226
- 3) Model_Dienstleister::getStadtplanlink @ /app/vendor/lexpress/doctrine1/lib/Doctrine/Record.php::1346
- 4) Doctrine_Record::get @ /app/application/library/DLDB/Doctrine/Record.php::36
- 5) DLDB_Doctrine_Record::get @ /app/vendor/lexpress/doctrine1/lib/Doctrine/Access.php::72
- 6) Doctrine_Access::__get @ /app/application/modules/default/views/scripts/ort/detail.phtml::42
- 7) ::include @ /app/vendor/zendframework/zendframework1/library/Zend/View.php::157
- 16) Zend_Controller_Front::dispatch @ /app/public/index.php::20
SELECT * FROM dienstleister WHERE lastrevision = 1 AND publish = 1 AND id = ? -- 330718
- 43,56ms: Query (0,020000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- dienstleister.payment
- 46,48ms: 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 -- 482503
- 54,03ms: 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)) -- 330115", "330132
- 57,06ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 482503
- 58,86ms: Query (0,009999999999998 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 482503", "330115
- 63,56ms: 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)) -- 326231", "330132
- 66,79ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 482503
- 68,76ms: Query (0,029999999999987 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 482503", "326231
- 73,29ms: 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)) -- 324328", "330132
- 75,83ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 482503
- 77,63ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 482503", "324328
- 80,9ms: 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)) -- 329830", "330132
- 83,47ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 482503
- 85,22ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 482503", "329830
- 88,29ms: 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)) -- 329833", "330132
- 90,86ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 482503
- 92,77ms: Query (0,010000000000005 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 482503", "329833
- 95,72ms: 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)) -- 324325", "330132
- 98,48ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 482503
- 100,29ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 482503", "324325
- 103,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)) -- 324573", "330132
- 106,05ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 482503
- 107,78ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 482503", "324573
- 109,98ms: Query (0,049999999999997 ms) - Rows: 0 - Trace...
SELECT * FROM translation t WHERE (t.translation_id = ?)0
- 112,22ms: Query (0,11 ms) - Rows: 0 - Trace...
SELECT * FROM xtranslation x WHERE (x.informationsobjekt_id = ? AND x.publish = 1) ORDER BY x.language -- 330132
- 113,43ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xtranslation x WHERE (x.informationsobjekt_id = ? AND x.publish = 1) ORDER BY x.language -- 330132
- 115,32ms: Query (0,040000000000006 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.active
- 116,72ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.services
- 118,12ms: Query (0,030000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.locations
- 119,46ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.locationService
- 120,65ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.routes
große Karte 
