- 14,45ms: Query (6,45 ms) - - Trace...
FROM Model_User u ORDER BY u.name
- 33,94ms:
/app/application/bootstrap.php +238
function require < [no object]
service.berlin.de
- 36,22ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Reisepass
- 36,24ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Reisepass
- 38,15ms: Query (0,090000000000003 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute(" (^| |
|,)Reisepass", " (^| |
|,)Reisepass")
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 -- (^| |
|,)Reisepass", " (^| |
|,)Reisepass
- 55,32ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Reisepass
- 55,34ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Reisepass
- 57,34ms: Query (0,029999999999994 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute("(^| |
|,)Reisepass", "(^| |
|,)Reisepass")
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 -- (^| |
|,)Reisepass", "(^| |
|,)Reisepass
- 88,81ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Reisepass
- 88,82ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Reisepass
- 91,03ms: Query (0,010000000000005 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute("link", " (^| |
|,)Reisepass", " (^| |
|,)Reisepass")
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", " (^| |
|,)Reisepass", " (^| |
|,)Reisepass
- 121,53ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Reisepass
- 121,55ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Reisepass
- 123,65ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute("link", "(^| |
|,)Reisepass", "(^| |
|,)Reisepass")
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", "(^| |
|,)Reisepass", "(^| |
|,)Reisepass
- 167,86ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Reisepass
- 167,88ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Reisepass
- 169,61ms: Query (0,080000000000013 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute(" (^| |
|,)Reisepass", " (^| |
|,)Reisepass")
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 -- (^| |
|,)Reisepass", " (^| |
|,)Reisepass
- 171,51ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Reisepass
- 171,53ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Reisepass
- 172,97ms: 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 -- (^| |
|,)Reisepass", "(^| |
|,)Reisepass
- 177,27ms: Query (0,02000000000001 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,11,Reisepass,2022-01-29 02:02:39
- 181,76ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- d115.messageHtml
- 183,08ms: Query (0,02000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- d115.openingTime
- 186,58ms: Query (0,0099999999999909 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
