https://kas.webmax.cloud/news

Query Metrics

3 Database Queries
3 Different statements
2.56 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.29 ms
(50.56%)
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"
]
0.98 ms
(38.48%)
1
SELECT
                                                  COUNT(ID) as TOTAL                                                
                                                FROM NEWS         
                                                WHERE NEWS_ACTIVE=1
Parameters:
[]
0.28 ms
(10.96%)
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.