- 12,72ms: Query (7,16 ms) - - Trace...
FROM Model_User u ORDER BY u.name
- 34,18ms:
/app/application/bootstrap.php +238
function require < [no object]
service.berlin.de
- 37,08ms: Query (0,060000000000002 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)) -- 326463
- 40,09ms: Query (0,009999999999998 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,55ms:
/app/application/modules/default/views/scripts/dienstleistung/detail.phtml +2
function include < [no object]
422356
- 42,59ms: Query (0,020000000000003 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 -- 422356
- 48,28ms: Query (0,030000000000001 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute("326463")
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 -- 326463
- 65,13ms: Query (0,030000000000001 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 -- 422356
- 70,26ms: Query (0,030000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- ea_id
- 73,19ms: Query (0,040000000000006 ms) - Rows: 0 - Trace...
SELECT * FROM translation t WHERE (t.translation_id = ?)0
- 75,27ms: Query (0,010000000000005 ms) - Rows: 0 - Trace...
SELECT * FROM xtranslation x WHERE (x.informationsobjekt_id = ? AND x.publish = 1) ORDER BY x.language -- 326463
- 76,62ms: Query (0,010000000000005 ms) - Rows: 0 - Trace...
SELECT * FROM xtranslation x WHERE (x.informationsobjekt_id = ? AND x.publish = 1) ORDER BY x.language
- 77,83ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM xtranslation x WHERE (x.informationsobjekt_id = ? AND x.publish = 1) ORDER BY x.language -- 326463
- 79,23ms: Query (0,039999999999992 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.active
- 80,47ms: Query (0,030000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.services
- 81,67ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.locations
- 82,83ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.locationService
- 83,93ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.routes
- 86,26ms: 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%", "326463
- 95,11ms: Query (0,030000000000001 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
