- 10,63ms: Query (6,3 ms) - - Trace...
FROM Model_User u ORDER BY u.name
- 30,13ms:
/app/application/bootstrap.php +238
function require < [no object]
service.berlin.de
- 32,04ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Gewerbe
- 32,05ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Gewerbe
- 33,68ms: Query (0,07 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute(" (^| |
|,)Gewerbe", " (^| |
|,)Gewerbe")
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 -- (^| |
|,)Gewerbe", " (^| |
|,)Gewerbe
- 50,08ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Gewerbe
- 50,09ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Gewerbe
- 51,52ms: Query (0,009999999999998 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute("(^| |
|,)Gewerbe", "(^| |
|,)Gewerbe")
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 -- (^| |
|,)Gewerbe", "(^| |
|,)Gewerbe
- 81,33ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Gewerbe
- 81,34ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Gewerbe
- 83,65ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute("link", " (^| |
|,)Gewerbe", " (^| |
|,)Gewerbe")
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", " (^| |
|,)Gewerbe", " (^| |
|,)Gewerbe
- 113,11ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Gewerbe
- 113,13ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Gewerbe
- 114,88ms: Query (0,019999999999996 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute("link", "(^| |
|,)Gewerbe", "(^| |
|,)Gewerbe")
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", "(^| |
|,)Gewerbe", "(^| |
|,)Gewerbe
- 159,84ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Gewerbe
- 159,85ms:
/app/application/library/DLDB/Api/V1.php +294
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ? (^| |
|,)Gewerbe
- 161,13ms: Query (0,0099999999999909 ms) - Rows: 0 - Trace...
- 2) Doctrine_Query::_execute(" (^| |
|,)Gewerbe", " (^| |
|,)Gewerbe")
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 -- (^| |
|,)Gewerbe", " (^| |
|,)Gewerbe
- 163,06ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Gewerbe
- 163,07ms:
/app/application/library/DLDB/Api/V1.php +323
DLDB_Api_V1::AndOrSearch < DLDB_Api_V1
stichworte REGEXP ?(^| |
|,)Gewerbe
- 164,33ms: Query (0,0099999999999909 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 -- (^| |
|,)Gewerbe", "(^| |
|,)Gewerbe
- 172,5ms: 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,50,Gewerbe,2022-01-29 03:26:05
- 177,34ms: Query (0,010000000000019 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- d115.messageHtml
- 178,69ms: Query (0,030000000000001 ms) - Rows: 0 - Trace...
SELECT * FROM settings s WHERE (s.name = ?) -- d115.openingTime
- 181,58ms: 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
