- 19,41ms: Query (12,56 ms) - - Trace...
FROM Model_User u ORDER BY u.name
- 38,81ms:
/app/application/bootstrap.php +238
function require < [no object]
service.berlin.de
- 40,66ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Bürgeramt
- 40,67ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Bürgeramt
- 42,24ms: Query (0,07 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute(" (^| |
|,)Bürgeramt", " (^| |
|,)Bürgeramt")
FROM Model_Dienstleistungen m WHERE (1 AND stichworte REGEXP ? AND stichworte REGEXP ? AND 1) AND (m.publish = 1 OR m.publish IS NULL) AND (m.anzeige IN ('both','public') OR m.anzeige IS NULL) ORDER BY type, name
- 3) Doctrine_Query_Abstract::execute @ /app/application/library/DLDB/Api/V1.php::304
- 4) DLDB_Api_V1::AndOrSearch @ /app/application/modules/default/controllers/SucheController.php::60
- 5) SucheController::sucheAction @ /app/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php::516
- 8) Zend_Controller_Front::dispatch @ /app/public/index.php::20
SELECT * FROM dienstleistungen d WHERE (1 AND d.stichworte REGEXP ? AND d.stichworte REGEXP ? AND 1) AND (d.publish = 1 OR d.publish IS NULL) AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL) ORDER BY d.type, d.name -- (^| |
|,)Bürgeramt", " (^| |
|,)Bürgeramt
- 53,13ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Bürgeramt
- 53,15ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Bürgeramt
- 54,62ms: Query (0,009999999999998 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute("(^| |
|,)Bürgeramt", "(^| |
|,)Bürgeramt")
FROM Model_Dienstleistungen m WHERE (0 OR stichworte REGEXP ? OR stichworte REGEXP ? OR 0) AND (m.publish = 1 OR m.publish IS NULL) AND (m.anzeige IN ('both','public') OR m.anzeige IS NULL) ORDER BY type, name
- 3) Doctrine_Query_Abstract::execute @ /app/application/library/DLDB/Api/V1.php::333
- 4) DLDB_Api_V1::AndOrSearch @ /app/application/modules/default/controllers/SucheController.php::60
- 5) SucheController::sucheAction @ /app/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php::516
- 8) Zend_Controller_Front::dispatch @ /app/public/index.php::20
SELECT * FROM dienstleistungen d WHERE (0 OR d.stichworte REGEXP ? OR d.stichworte REGEXP ? OR 0) AND (d.publish = 1 OR d.publish IS NULL) AND (d.anzeige IN ('both', 'public') OR d.anzeige IS NULL) ORDER BY d.type, d.name -- (^| |
|,)Bürgeramt", "(^| |
|,)Bürgeramt
- 71,72ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Bürgeramt
- 71,74ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Bürgeramt
- 75,15ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute("link", " (^| |
|,)Bürgeramt", " (^| |
|,)Bürgeramt")
FROM Model_Beschreibung m LEFT JOIN m.Suchbegriffe sb LEFT JOIN m.Informationsobjekt i WHERE m.type = ? AND m.rid = i.rid AND (1 AND stichworte REGEXP ? AND stichworte REGEXP ? AND 1) AND (m.anzeige IN ('both','public') OR m.anzeige IS NULL) GROUP BY sb.verweis ORDER BY type, name
- 3) Doctrine_Query_Abstract::execute @ /app/application/library/DLDB/Api/V1.php::304
- 4) DLDB_Api_V1::AndOrSearch @ /app/application/modules/default/controllers/SucheController.php::60
- 5) SucheController::sucheAction @ /app/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php::516
- 8) Zend_Controller_Front::dispatch @ /app/public/index.php::20
SELECT * FROM beschreibung b LEFT JOIN suchbegriffe s ON b.verweis = s.verweis LEFT JOIN informationsobjekt i ON b.informationsobjekt_id = i.informationsobjekt_id WHERE (b.type = ? AND b.rid = i.rid AND (1 AND stichworte REGEXP ? AND stichworte REGEXP ? AND 1) AND (b.anzeige IN ('both', 'public') OR b.anzeige IS NULL)) GROUP BY s.verweis ORDER BY b.type, b.name -- link", " (^| |
|,)Bürgeramt", " (^| |
|,)Bürgeramt
- 101,3ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Bürgeramt
- 101,33ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Bürgeramt
- 103,37ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute("link", "(^| |
|,)Bürgeramt", "(^| |
|,)Bürgeramt")
FROM Model_Beschreibung m LEFT JOIN m.Suchbegriffe sb LEFT JOIN m.Informationsobjekt i WHERE m.type = ? AND m.rid = i.rid AND (0 OR stichworte REGEXP ? OR stichworte REGEXP ? OR 0) AND (m.anzeige IN ('both','public') OR m.anzeige IS NULL) GROUP BY sb.verweis ORDER BY type, name
- 3) Doctrine_Query_Abstract::execute @ /app/application/library/DLDB/Api/V1.php::333
- 4) DLDB_Api_V1::AndOrSearch @ /app/application/modules/default/controllers/SucheController.php::60
- 5) SucheController::sucheAction @ /app/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php::516
- 8) Zend_Controller_Front::dispatch @ /app/public/index.php::20
SELECT * FROM beschreibung b LEFT JOIN suchbegriffe s ON b.verweis = s.verweis LEFT JOIN informationsobjekt i ON b.informationsobjekt_id = i.informationsobjekt_id WHERE (b.type = ? AND b.rid = i.rid AND (0 OR stichworte REGEXP ? OR stichworte REGEXP ? OR 0) AND (b.anzeige IN ('both', 'public') OR b.anzeige IS NULL)) GROUP BY s.verweis ORDER BY b.type, b.name -- link", "(^| |
|,)Bürgeramt", "(^| |
|,)Bürgeramt
- 139,45ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Bürgeramt
- 139,47ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Bürgeramt
- 141,08ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute(" (^| |
|,)Bürgeramt", " (^| |
|,)Bürgeramt")
FROM Model_Themen m WHERE (1 AND stichworte REGEXP ? AND stichworte REGEXP ? AND 1) AND (m.publish = 1 OR m.publish IS NULL) AND (m.anzeige IN ('both','public') OR m.anzeige IS NULL) ORDER BY type, name
- 3) Doctrine_Query_Abstract::execute @ /app/application/library/DLDB/Api/V1.php::304
- 4) DLDB_Api_V1::AndOrSearch @ /app/application/modules/default/controllers/SucheController.php::60
- 5) SucheController::sucheAction @ /app/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php::516
- 8) Zend_Controller_Front::dispatch @ /app/public/index.php::20
SELECT * FROM themen t WHERE (1 AND t.stichworte REGEXP ? AND t.stichworte REGEXP ? AND 1) AND (t.publish = 1 OR t.publish IS NULL) AND (t.anzeige IN ('both', 'public') OR t.anzeige IS NULL) ORDER BY t.type, t.name -- (^| |
|,)Bürgeramt", " (^| |
|,)Bürgeramt
- 143,15ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Bürgeramt
- 143,17ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Bürgeramt
- 144,5ms: Query (0,010000000000019 ms) - Rows: 0 - Trace...
SELECT * FROM themen t WHERE (0 OR t.stichworte REGEXP ? OR t.stichworte REGEXP ? OR 0) AND (t.publish = 1 OR t.publish IS NULL) AND (t.anzeige IN ('both', 'public') OR t.anzeige IS NULL) ORDER BY t.type, t.name -- (^| |
|,)Bürgeramt", "(^| |
|,)Bürgeramt
- 149,01ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
- 6) Doctrine_Record::save @ /app/application/library/DLDB/Doctrine/Record.php::145
- 7) DLDB_Doctrine_Record::save @ /app/application/library/Model/Searchlog.php::24
- 8) Model_Searchlog::writeSearchword @ /app/application/library/DLDB/Api/V1.php::373
- 9) DLDB_Api_V1::AndOrSearch @ /app/application/modules/default/controllers/SucheController.php::60
- 10) SucheController::sucheAction @ /app/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php::516
- 13) Zend_Controller_Front::dispatch @ /app/public/index.php::20
INSERT INTO searchlog (count, found, request, ts) VALUES (?, ?, ?, ?) -- 1,12,Bürgeramt,2022-01-29 02:24:20
- 154,45ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- d115.messageHtml
- 155,92ms: Query (0,019999999999982 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- d115.openingTime
- 159,72ms: Query (0,030000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM themen t WHERE (t.isroot = ? AND t.publish = ? AND t.anzeige != ?) ORDER BY t.sortierung, t.name -- 1", "1", "hidden
