- 18,16ms: Query (7,43 ms) - - Trace...
FROM Model_User u ORDER BY u.name
- 40,66ms:
/app/application/bootstrap.php +238
function require < [no object]
service.berlin.de
- 47,84ms: Query (0,079999999999998 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute("121364")
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)) -- 121364
- 53,68ms: Query (0,020000000000003 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)) -- 121364
- 58ms: Query (0,029999999999994 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- dienstleister.payment
- 61,66ms: 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 -- 483292
- 80,76ms: 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)) -- 120658", "121364
- 83,73ms: Query (0,030000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 86,6ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "120658
- 90,13ms: 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)) -- 297016", "121364
- 92,44ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "297016
- 96,38ms: 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)) -- 327074", "121364
- 98,74ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "327074
- 101,91ms: Query (0,079999999999998 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)) -- 324234", "121364
- 105,47ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "324234
- 109,36ms: Query (0,060000000000002 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)) -- 324235", "121364
- 112,39ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "324235
- 116,17ms: 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)) -- 327084", "121364
- 119,44ms: Query (0,049999999999997 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 122,07ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "327084
- 128,24ms: Query (0,059999999999974 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)) -- 121490", "121364
- 132,33ms: Query (0,030000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 135,11ms: Query (0,030000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "121490
- 141,57ms: 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)) -- 121482", "121364
- 146,08ms: Query (0,050000000000011 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 148,23ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "121482
- 152,08ms: 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)) -- 121491", "121364
- 154,29ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "121491
- 159,26ms: 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)) -- 121478", "121364
- 163,58ms: Query (0,039999999999992 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 166,09ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "121478
- 170,21ms: 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)) -- 120877", "121364
- 172,51ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "120877
- 176ms: 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)) -- 325881", "121364
- 179,5ms: Query (0,030000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 181,76ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "325881
- 185,14ms: 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)) -- 327517", "121364
- 187,49ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "327517
- 190,77ms: 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)) -- 297023", "121364
- 198,89ms: Query (0,039999999999992 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "297023
- 203,85ms: 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)) -- 121473", "121364
- 206,62ms: Query (0,030000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 208,52ms: Query (0,010000000000019 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "121473
- 211,63ms: 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)) -- 324196", "121364
- 214,43ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 217,2ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "324196
- 220,52ms: 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)) -- 121484", "121364
- 223,42ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "121484
- 226,69ms: 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)) -- 324907", "121364
- 228,68ms: Query (0,010000000000019 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "324907
- 231,72ms: 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)) -- 121479", "121364
- 233,7ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "121479
- 237,92ms: Query (0,069999999999993 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)) -- 120904", "121364
- 241,05ms: Query (0,050000000000011 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 243,26ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "120904
- 246,72ms: 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)) -- 120918", "121364
- 249,74ms: 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)) -- 483292
- 251,73ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "120918
- 254,67ms: 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)) -- 326039", "121364
- 257,47ms: Query (0,03000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 259,52ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "326039
- 262,71ms: 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)) -- 324173", "121364
- 265,53ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 267,4ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "324173
- 271,02ms: 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)) -- 120882", "121364
- 274,02ms: Query (0,020000000000039 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 276,24ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "120882
- 279,54ms: 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)) -- 329048", "121364
- 281,62ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "329048
- 284,77ms: 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)) -- 329033", "121364
- 286,84ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "329033
- 290,05ms: 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)) -- 326618", "121364
- 292,11ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "326618
- 295,9ms: 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)) -- 329045", "121364
- 297,89ms: Query (0,03000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "329045
- 300,98ms: 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)) -- 329051", "121364
- 303,91ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "329051
- 307,15ms: 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)) -- 329039", "121364
- 309,46ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "329039
- 317,84ms: Query (0,060000000000002 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)) -- 328593", "121364
- 320,6ms: Query (0,03000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "328593
- 325,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)) -- 329030", "121364
- 328,34ms: Query (0,04000000000002 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "329030
- 333,3ms: 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)) -- 329036", "121364
- 335,93ms: Query (0,029999999999973 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "329036
- 340,83ms: 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)) -- 120900", "121364
- 342,98ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "120900
- 345,97ms: 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)) -- 327897", "121364
- 348,11ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "327897
- 351,18ms: 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)) -- 121480", "121364
- 353,98ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 356,21ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "121480
- 359,37ms: 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)) -- 326043", "121364
- 361,6ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "326043
- 364,75ms: 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)) -- 120906", "121364
- 368,52ms: Query (0,020000000000039 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 370,53ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "120906
- 373,74ms: 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)) -- 324587", "121364
- 376,74ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 378,99ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "324587
- 382,94ms: 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)) -- 120905", "121364
- 385,83ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 387,86ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "120905
- 391,02ms: Query (0,010000000000048 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)) -- 324199", "121364
- 393,87ms: Query (0,029999999999973 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 396ms: Query (0,020000000000039 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "324199
- 399,1ms: 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)) -- 324200", "121364
- 401,98ms: Query (0,03000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 404ms: Query (0,020000000000039 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "324200
- 407,28ms: 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)) -- 120892", "121364
- 410,15ms: Query (0,020000000000039 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 412,08ms: Query (0,03000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "120892
- 415,25ms: 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)) -- 324169", "121364
- 419,45ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 422,34ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "324169
- 425,66ms: 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)) -- 120914", "121364
- 428,49ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 430,68ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "120914
- 433,79ms: 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", "121364
- 437,48ms: Query (0,03000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 439,73ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "121575
- 443,88ms: 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)) -- 121584", "121364
- 447,6ms: Query (0,03000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 450,14ms: Query (0,020000000000039 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "121584
- 453,54ms: 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)) -- 326033", "121364
- 457,05ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM dienstleister d WHERE (d.rid = ? AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL)) -- 483292
- 459,04ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 483292", "326033
- 460,67ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM translation t WHERE (t.translation_id = ?)0
- 462,47ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xtranslation x WHERE (x.informationsobjekt_id = ? AND x.publish = 1) ORDER BY x.language -- 121364
- 463,9ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xtranslation x WHERE (x.informationsobjekt_id = ? AND x.publish = 1) ORDER BY x.language -- 121364
- 467,94ms: Query (0,060000000000002 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.active
- 469,52ms: Query (0,020000000000039 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.services
- 470,61ms: Query (0,03000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.locations
- 471,81ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.locationService
- 472,98ms: Query (0,04000000000002 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- supportKomponente.routes
große Karte 
