Query Metrics
4
Database Queries
3
Different statements
4.50 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.11 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" => "/vyhledat?q=Ma%C5%A1ko%C3%A1" ] |
| 2 | 0.13 ms |
SELECT ID, WP_NAME, DATE_FORMAT(LAST_UPDATE, '%Y%m%d%H%i%s') AS PREVCACHE FROM WEBPAGES WHERE WP_LINK = :link
Parameters:
[ "link" => "poskytovani-informaci" ] |
| 3 | 3.17 ms |
SELECT ID, WHAT, NAME, LINK FROM SEARCHE WHERE SEARCHTEXT like :q
Parameters:
[ "q" => "%Maškoá%" ] |
| 4 | 0.09 ms |
SELECT ID, WHAT, NAME, LINK FROM SEARCHE WHERE SEARCHTEXT like :q
Parameters:
[ "q" => "%Maškoá%" ] |
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.