- 12,92ms: Query (6,28 ms) - - Trace...
FROM Model_User u ORDER BY u.name
- 32,77ms:
/app/application/bootstrap.php +238
function require < [no object]
service.berlin.de
- 36,31ms: Query (0,079999999999998 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleistungen d WHERE (d.publish = 1 AND d.id = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 326457
- 39,72ms: Query (0,020000000000003 ms) - Rows: 0 - Trace...
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)) -- 324835
- 41,67ms:
/app/application/modules/default/views/scripts/dienstleistung/detail.phtml +2
function include < [no object]
422377
- 42,88ms: Query (0,030000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM beschreibung b WHERE (b.rid = ? AND (b.anzeige IN ('both', 'public') OR b.anzeige IS NULL)) ORDER BY b.rid -- 422377
- 49,31ms: Query (0,030000000000001 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute("326457")
FROM Model_Behoerden b LEFT JOIN b.Xuserort xu LEFT JOIN xu.Dienstleister d LEFT JOIN d.XDienst xd WHERE b.publish = 1 AND xd.dienstleistung = ? AND (b.anzeige IN ('both','public') OR b.anzeige IS NULL) AND (d.publish = 1 OR d.publish IS NULL) AND (d.anzeige IN ('both','public') OR d.anzeige IS NULL) GROUP BY b.id, d.id ORDER BY b.name, d.name
- 3) Doctrine_Query_Abstract::execute @ /app/application/library/Model/Dienstleistungen.php::1529
- 4) Model_Dienstleistungen::getBehoerden @ /app/application/modules/default/views/scripts/dienstleistung/detail.phtml::458
- 5) ::include @ /app/vendor/zendframework/zendframework1/library/Zend/View.php::157
- 14) Zend_Controller_Front::dispatch @ /app/public/index.php::20
SELECT * FROM behoerden b LEFT JOIN xuserort x ON b.rid = x.id LEFT JOIN dienstleister d ON x.dienstleister_id = d.id LEFT JOIN xdienst x2 ON d.rid = x2.dienstleister WHERE (b.publish = 1 AND x2.dienstleistung = ? AND (b.anzeige IN ('both', 'public') OR b.anzeige IS NULL) AND (d.publish = 1 OR d.publish IS NULL) AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) GROUP BY b.id, d.id ORDER BY b.name, d.name -- 326457
- 65,08ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM behoerden b LEFT JOIN xdlbehoerde x ON b.id = x.behoerden_id WHERE (x.id = ? AND (b.publish = 1 OR b.publish IS NULL) AND (b.anzeige IN ('both', 'public') OR b.anzeige IS NULL)) GROUP BY b.id ORDER BY b.name -- 422377
- 70,27ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- ea_id
- 73,35ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM translation t WHERE (t.translation_id = ?)0
- 75,21ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xtranslation x WHERE (x.informationsobjekt_id = ? AND x.publish = 1) ORDER BY x.language -- 326457
- 76,88ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xtranslation x WHERE (x.informationsobjekt_id = ? AND x.publish = 1) ORDER BY x.language
- 78,42ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM xtranslation x WHERE (x.informationsobjekt_id = ? AND x.publish = 1) ORDER BY x.language -- 326457
- 79,92ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.active
- 81,63ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.services
- 83,13ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.locations
- 84,77ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.locationService
- 86,12ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.routes
- 88,74ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleistungen d WHERE (d.leika LIKE ? AND d.id != ? 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 -- __001004004%", "326457
- 97,59ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM themen t WHERE (t.isroot = ? AND t.publish = ? AND t.anzeige != ?) ORDER BY t.sortierung, t.name -- 1", "1", "hidden
