Query Metrics
5
Database Queries
5
Different statements
4.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.95 ms (47.70%) |
1 |
SELECT * FROM V_EVENTS_SLIDER
Parameters:
[] |
|
1.00 ms (24.60%) |
1 |
SELECT WP_ICON, WP_NAME, WP_LINK FROM WEBPAGES WHERE WP_FOOTER = 1 AND WP_ACTIVE = 1 ORDER BY WP_NAME
Parameters:
[] |
|
0.90 ms (22.10%) |
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" => "/" ] |
|
0.12 ms (2.87%) |
1 |
SELECT OBJECT_NAME, OBJECT_LINK, OBJECT_CULTURE, OBJECT_CLASS, OBJECT_IMG_SMALL, DATE_FORMAT(LAST_UPDATE, '%Y%m%d%H%i%s') as PREVCACHE, OBJECT_SUBTITLE FROM OBJECTS WHERE OBJECT_ACTIVE=1 AND OBJECT_SLIDER=1 ORDER BY SORT_INDEX ASC
Parameters:
[] |
|
0.11 ms (2.74%) |
1 |
SELECT OBJECT_NAME, OBJECT_LINK, OBJECT_CULTURE, OBJECT_CLASS, OBJECT_IMG_SMALL, DATE_FORMAT(LAST_UPDATE, '%Y%m%d%H%i%s') as PREVCACHE, OBJECT_SUBTITLE FROM OBJECTS WHERE OBJECT_ACTIVE=1 ORDER BY SORT_INDEX ASC
Parameters:
[] |
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.