- 16,21ms: Query (8,03 ms) - - Trace...
FROM Model_User u ORDER BY u.name
- 35,22ms:
/app/application/bootstrap.php +238
function require < [no object]
service.berlin.de
- 40,93ms: Query (0,090000000000003 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute("122267")
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)) -- 122267
- 46,35ms: Query (0,029999999999994 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)) -- 122267
- 49,95ms: Query (0,029999999999994 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 = ? -- 324139
- 54,68ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- dienstleister.payment
- 59,38ms: Query (0,030000000000001 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 -- 484256
- 88,72ms: Query (0,049999999999997 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)) -- 120335", "122267
- 91,62ms: Query (0,029999999999987 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "120335
- 95,25ms: 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)) -- 120658", "122267
- 98,14ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "120658
- 101,48ms: 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)) -- 120697", "122267
- 103,92ms: Query (0,010000000000005 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "120697
- 107,41ms: Query (0,040000000000006 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)) -- 120686", "122267
- 109,69ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "120686
- 113,01ms: 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)) -- 121874", "122267
- 115,97ms: Query (0,030000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121874
- 120,51ms: Query (0,029999999999987 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)) -- 324269", "122267
- 122,88ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "324269
- 126,25ms: Query (0,029999999999987 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)) -- 297016", "122267
- 128,64ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "297016
- 131,98ms: 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)) -- 121701", "122267
- 134,63ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121701
- 139,25ms: 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)) -- 158142", "122267
- 142,11ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "158142
- 146,81ms: 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)) -- 121742", "122267
- 149,55ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121742
- 154,41ms: Query (0,039999999999992 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)) -- 325147", "122267
- 156,94ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "325147
- 161,29ms: Query (0,049999999999983 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)) -- 324921", "122267
- 163,81ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "324921
- 167,47ms: Query (0,049999999999983 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)) -- 326798", "122267
- 169,78ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "326798
- 173,13ms: 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)) -- 330115", "122267
- 175,31ms: Query (0,030000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "330115
- 178,7ms: 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)) -- 330112", "122267
- 181,25ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "330112
- 184,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)) -- 326231", "122267
- 186,87ms: Query (0,010000000000019 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "326231
- 190,43ms: 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)) -- 121589", "122267
- 192,76ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121589
- 197,51ms: 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)) -- 121627", "122267
- 200,4ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121627
- 211,51ms: Query (0,050000000000011 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)) -- 324450", "122267
- 213,99ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "324450
- 217,69ms: 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)) -- 121629", "122267
- 220,16ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121629
- 223,63ms: 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)) -- 330313", "122267
- 225,87ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "330313
- 229,62ms: Query (0,099999999999994 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)) -- 121637", "122267
- 232,52ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121637
- 237ms: 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)) -- 121598", "122267
- 240,13ms: Query (0,030000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121598
- 243,89ms: 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)) -- 327537", "122267
- 246,23ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "327537
- 249,43ms: 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)) -- 121615", "122267
- 252,04ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121615
- 261,48ms: Query (0,050000000000011 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)) -- 124556", "122267
- 264,32ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "124556
- 268,85ms: Query (0,039999999999964 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)) -- 121634", "122267
- 271,24ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121634
- 276,58ms: Query (0,029999999999973 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)) -- 121622", "122267
- 279,21ms: Query (0,020000000000039 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121622
- 284,08ms: Query (0,099999999999966 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)) -- 324389", "122267
- 286,82ms: Query (0,029999999999973 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "324389
- 291,59ms: Query (0,029999999999973 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)) -- 150169", "122267
- 294,09ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "150169
- 298,89ms: Query (0,03000000000003 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)) -- 121591", "122267
- 301,28ms: Query (0,03000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121591
- 304,7ms: Query (0,04000000000002 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)) -- 121593", "122267
- 307,6ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121593
- 311,11ms: Query (0,04000000000002 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)) -- 121616", "122267
- 313,84ms: Query (0,060000000000002 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121616
- 317,93ms: Query (0,03000000000003 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)) -- 120926", "122267
- 320,27ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "120926
- 324,81ms: Query (0,03000000000003 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)) -- 121543", "122267
- 328,55ms: Query (0,029999999999973 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121543
- 331,92ms: 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)) -- 327835", "122267
- 334,17ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "327835
- 337,87ms: Query (0,029999999999973 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)) -- 121469", "122267
- 340,24ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121469
- 343,35ms: 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)) -- 120877", "122267
- 345,86ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "120877
- 349,5ms: Query (0,039999999999964 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)) -- 120702", "122267
- 351,98ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "120702
- 355,9ms: 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)) -- 326215", "122267
- 358,09ms: Query (0,020000000000039 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "326215
- 363,07ms: Query (0,029999999999973 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)) -- 320303", "122267
- 365,21ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "320303
- 368,62ms: 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)) -- 120732", "122267
- 370,93ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "120732
- 374,35ms: Query (0,050000000000011 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)) -- 120678", "122267
- 376,71ms: Query (0,020000000000039 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "120678
- 380,14ms: Query (0,03000000000003 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)) -- 324280", "122267
- 382,65ms: Query (0,020000000000039 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "324280
- 386,76ms: Query (0,029999999999973 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", "122267
- 388,95ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "329830
- 392,5ms: Query (0,029999999999973 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", "122267
- 394,79ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "329833
- 398,26ms: Query (0,029999999999973 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", "122267
- 400,76ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "324325
- 404,22ms: Query (0,03000000000003 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)) -- 120703", "122267
- 406,31ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "120703
- 409,78ms: Query (0,050000000000011 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)) -- 327044", "122267
- 412,12ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "327044
- 415,35ms: Query (0,03000000000003 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)) -- 120682", "122267
- 417,59ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "120682
- 420,91ms: Query (0,03000000000003 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", "122267
- 423,65ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "324573
- 427,23ms: Query (0,04000000000002 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)) -- 121151", "122267
- 429,74ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121151
- 433,47ms: 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)) -- 121153", "122267
- 435,66ms: Query (0,029999999999973 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121153
- 439,04ms: Query (0,03000000000003 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)) -- 121368", "122267
- 441,28ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121368
- 444,83ms: Query (0,03000000000003 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)) -- 150177", "122267
- 447,12ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "150177
- 450,62ms: Query (0,04000000000002 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)) -- 120726", "122267
- 453,15ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "120726
- 456,45ms: Query (0,029999999999973 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)) -- 319141", "122267
- 458,8ms: Query (0,029999999999973 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "319141
- 462,12ms: 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)) -- 120671", "122267
- 464,48ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "120671
- 467,86ms: 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)) -- 120665", "122267
- 470,23ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "120665
- 474,02ms: Query (0,04000000000002 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)) -- 120656", "122267
- 476,37ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "120656
- 479,64ms: 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)) -- 121575", "122267
- 481,81ms: Query (0,029999999999973 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 484256", "121575
- 484,21ms: Query (0,060000000000002 ms) - Rows: 0 - Trace...
SELECT * FROM translation t WHERE (t.translation_id = ?)0
- 486,45ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xtranslation x WHERE (x.informationsobjekt_id = ? AND x.publish = 1) ORDER BY x.language -- 122267
- 488,41ms: Query (0,050000000000011 ms) - Rows: 0 - Trace...
SELECT * FROM xtranslation x WHERE (x.informationsobjekt_id = ? AND x.publish = 1) ORDER BY x.language -- 122267
- 491,02ms: Query (0,03000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.active
- 492,88ms: Query (0,029999999999973 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.services
- 494,49ms: Query (0,03000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.locations
- 496,06ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.locationService
- 497,64ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.routes
große Karte 
