http://nba-back-cache.buenosaires.gob.ar/api/v1/buscador/tramites-servicios/1?texto=Ac486pt

Query Metrics

2 Database Queries
2 Different statements
15.47 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 8.32 ms
SELECT nombre AS titulo,descripcion AS sintesis,REGEXP_REPLACE(REGEXP_REPLACE(CONCAT('BASE_URL', link), '^BASE_URL\/', 'https://buenosaires.gob.ar/'), '^BASE_URL', '') AS link FROM tramite WHERE deleted_at IS NULL AND activo = 1 AND (nombre LIKE :search OR descripcion LIKE :search) ORDER BY posicion ASC,nombre ASC LIMIT 25
Parameters:
[
  ":search" => "%Ac486pt%"
]
2 7.15 ms
SELECT COUNT(id) AS cant FROM tramite WHERE deleted_at IS NULL AND activo = 1 AND (nombre LIKE :search OR descripcion LIKE :search)
Parameters:
[
  ":search" => "%Ac486pt%"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
api doctrine.dbal.api_connection
log doctrine.dbal.log_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
api doctrine.orm.api_entity_manager
log doctrine.orm.log_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\App\Tramite No errors.

api entity manager

Class Mapping errors
App\Entity\App\Tramite No errors.

log entity manager

No loaded entities.