- 45.64ms: Query (6.58 ms) - - Trace...
FROM Model_User u ORDER BY u.name
- 94.82ms: Query (0.52 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute("149013")
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)) -- 149013
- 99.17ms: 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)) -- 149013
- 111.38ms: 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 -- 389899
- 121.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)) -- 327647", "149013
- 123.5ms: Query (0.019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389899", "327647
- 129.42ms: 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)) -- 141579", "149013
- 131.66ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389899", "141579
- 136.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)) -- 141577", "149013
- 140.15ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389899", "141577
- 146.04ms: 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)) -- 302439", "149013
- 148.48ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389899", "302439
- 154.94ms: 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)) -- 141571", "149013
- 157.47ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389899", "141571
- 163.11ms: 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)) -- 327771", "149013
- 165.79ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 389899", "327771
- 168.28ms: Query (0.030000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM translation t WHERE (t.translation_id = ?)0
- 174.96ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xtranslation x WHERE (x.informationsobjekt_id = ? AND x.publish = 1) ORDER BY x.language -- 149013
große Karte
große Karte