Query Metrics
3
Database Queries
3
Different statements
2.56 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.29 ms |
SELECT PI_MESSAGE FROM PAGEINFO WHERE ((CURDATE() BETWEEN DATE(PI_FROM) AND DATE(PI_TO)) OR (CURDATE() > DATE(PI_FROM) AND PI_TO IS NULL) OR (CURDATE() < DATE(PI_FROM) AND PI_FROM IS NULL) OR (PI_TO IS NULL AND PI_FROM IS NULL)) AND PI_ACTIVE = 1 AND (PI_URI = '*' OR PI_URI=:uri)
Parameters:
[ "uri" => "/news" ] |
| 2 | 0.98 ms |
SELECT COUNT(ID) as TOTAL FROM NEWS WHERE NEWS_ACTIVE=1
Parameters:
[] |
| 3 | 0.28 ms |
SELECT ID, NEWS_NAME, NEWS_PEREX, NEWS_TEXT, NEWS_DATE, LAST_USER, LAST_UPDATE, DATE_FORMAT(LAST_UPDATE, '%Y%m%d%h%i') as PREVCACHE, NEWS_ICON, NEWS_AUTOR, NEWS_SOURCE_IMG, NEWS_SOURCE_GAL, NEWS_HASPIC FROM NEWS WHERE NEWS_ACTIVE=1 ORDER BY NEWS_DATE DESC LIMIT :offset,:limit
Parameters:
[ "offset" => 0 "limit" => 4 ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.