- 44.94ms: Query (6.42 ms) - - Trace...
FROM Model_User u ORDER BY u.name
- 86.24ms: Query (0.40000000000001 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 @ /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)) -- 122267
- 92.18ms: 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)) -- 122267
- 95.52ms: Query (0.030000000000001 ms) - Rows: 0 - Trace...
- 0) Doctrine_Connection_Statement::execute @ /opt/dldb/application/library/Model/Dienstleister.php::1103
- 1) Model_Dienstleister::getParent @ /opt/dldb/application/library/Model/Dienstleister.php::1076
- 2) Model_Dienstleister::adressangabe @ /opt/dldb/application/library/Model/Dienstleister.php::1205
- 3) Model_Dienstleister::getStadtplanlink @ /opt/dldb/vendor/lexpress/doctrine1/lib/Doctrine/Record.php::1347
- 4) Doctrine_Record::get @ /opt/dldb/application/library/DLDB/Doctrine/Record.php::36
- 5) DLDB_Doctrine_Record::get @ /opt/dldb/vendor/lexpress/doctrine1/lib/Doctrine/Access.php::72
- 6) Doctrine_Access::__get @ /opt/dldb/application/modules/default/views/scripts/ort/detail.phtml::31
- 7) ::include @ /opt/dldb/vendor/zendframework/zendframework1/library/Zend/View.php::157
- 16) Zend_Controller_Front::dispatch @ /opt/dldb/public/index.php::20
SELECT * FROM dienstleister WHERE lastrevision = 1 AND publish = 1 AND id = ? -- 324139
- 105.01ms: Query (0.02000000000001 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 -- 401303
- 129.48ms: 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)) -- 120335", "122267
- 131.66ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "120335
- 136.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)) -- 120686", "122267
- 138.27ms: Query (0.0099999999999909 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "120686
- 142.69ms: 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)) -- 120658", "122267
- 145.35ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "120658
- 150.1ms: 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)) -- 324269", "122267
- 152.67ms: Query (0.29999999999998 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "324269
- 159.32ms: 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)) -- 327044", "122267
- 165.66ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "327044
- 170.84ms: 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
- 174.54ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121701
- 182.78ms: 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)) -- 158142", "122267
- 185.93ms: Query (0.030000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "158142
- 199.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)) -- 121589", "122267
- 205.29ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121589
- 216.01ms: 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)) -- 324921", "122267
- 218.34ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "324921
- 227.97ms: 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)) -- 121593", "122267
- 230.17ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121593
- 239.51ms: 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)) -- 121627", "122267
- 241.79ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121627
- 250.41ms: 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
- 252.85ms: Query (0.02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121629
- 259.21ms: 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)) -- 324450", "122267
- 261.89ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "324450
- 266.22ms: 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)) -- 121622", "122267
- 268.28ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121622
- 275.73ms: 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)) -- 324389", "122267
- 278.09ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "324389
- 283.31ms: 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)) -- 150169", "122267
- 285.5ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "150169
- 289.97ms: 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)) -- 121543", "122267
- 292.12ms: Query (0.020000000000039 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121543
- 298.34ms: 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)) -- 120926", "122267
- 300.84ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "120926
- 308.15ms: 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)) -- 327835", "122267
- 310.25ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "327835
- 314.85ms: 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)) -- 121591", "122267
- 318.95ms: Query (0.020000000000039 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121591
- 324.78ms: 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)) -- 121469", "122267
- 327.46ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121469
- 335.42ms: 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)) -- 120877", "122267
- 338.19ms: Query (0.029999999999973 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "120877
- 345.7ms: 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)) -- 120702", "122267
- 348.5ms: Query (0.03000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "120702
- 356.37ms: 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)) -- 326215", "122267
- 359.5ms: Query (0.029999999999973 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "326215
- 364.17ms: 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
- 367.22ms: Query (0.020000000000039 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "120732
- 372ms: 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)) -- 120678", "122267
- 374.92ms: Query (0.03000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "120678
- 384.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)) -- 320303", "122267
- 388.14ms: Query (0.03000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "320303
- 396.67ms: 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)) -- 121637", "122267
- 399.82ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121637
- 408.18ms: 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
- 411.32ms: Query (0.050000000000011 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "324325
- 419.57ms: 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)) -- 120703", "122267
- 422.74ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "120703
- 428.96ms: 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)) -- 120682", "122267
- 431.87ms: Query (0.029999999999973 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "120682
- 439.82ms: 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
- 443.21ms: Query (0.029999999999973 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "324573
- 451.75ms: 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)) -- 121151", "122267
- 455.13ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121151
- 466.58ms: 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)) -- 121153", "122267
- 469.26ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121153
- 479.89ms: 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)) -- 121368", "122267
- 482.96ms: Query (0.03000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121368
- 494.56ms: 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)) -- 150177", "122267
- 502.03ms: Query (0.03000000000003 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "150177
- 511.95ms: Query (0.59000000000003 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
- 515.24ms: Query (0.040000000000077 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121615
- 526.75ms: 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)) -- 121598", "122267
- 529.74ms: Query (0.029999999999973 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121598
- 538.53ms: 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)) -- 327537", "122267
- 541.26ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "327537
- 549.82ms: 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)) -- 124556", "122267
- 553.17ms: Query (0.029999999999973 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "124556
- 560.66ms: 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)) -- 121616", "122267
- 563.28ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121616
- 571.9ms: 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)) -- 120726", "122267
- 575.67ms: Query (0.049999999999955 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "120726
- 584.99ms: 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)) -- 121634", "122267
- 587.6ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121634
- 595.97ms: Query (0.030000000000086 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
- 598.56ms: Query (0.020000000000095 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "319141
- 607.17ms: 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)) -- 120671", "122267
- 610.35ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "120671
- 618.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)) -- 120665", "122267
- 621.84ms: Query (0.030000000000086 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "120665
- 625.97ms: 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)) -- 120656", "122267
- 629.62ms: Query (0.029999999999973 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "120656
- 636.61ms: 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)) -- 121575", "122267
- 639.32ms: Query (0.020000000000095 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121575
- 647.89ms: 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)) -- 121742", "122267
- 650.7ms: Query (0.020000000000095 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121742
- 659.27ms: 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)) -- 325147", "122267
- 662.26ms: Query (0.029999999999973 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "325147
- 667.14ms: Query (0.020000000000095 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
- 670.11ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "120697
- 677.93ms: 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)) -- 121874", "122267
- 681.36ms: Query (0.029999999999973 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "121874
- 688.06ms: Query (0.030000000000086 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
- 691.67ms: Query (0.039999999999964 ms) - Rows: 0 - Trace...
SELECT * FROM xdienst x WHERE (x.dienstleister = ? AND x.dienstleistung = ?) -- 401303", "324280
- 694.66ms: Query (0.039999999999964 ms) - Rows: 0 - Trace...
SELECT * FROM translation t WHERE (t.translation_id = ?)0
- 702.2ms: Query (0.019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM xtranslation x WHERE (x.informationsobjekt_id = ? AND x.publish = 1) ORDER BY x.language -- 122267
große Karte 
