Query Metrics
4
Database Queries
4
Different statements
3.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.03 ms (58.75%) |
1 |
SELECT * FROM V_EVENTS_SLIDER
Parameters:
[] |
|
1.27 ms (36.65%) |
1 |
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/1" ] |
|
0.10 ms (2.92%) |
1 |
SELECT COUNT(ID) as TOTAL FROM NEWS WHERE NEWS_ACTIVE=1
Parameters:
[] |
|
0.06 ms (1.68%) |
1 |
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.