https://kas.webmax.cloud/news/1

Query Metrics

4 Database Queries
4 Different statements
3.45 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.