http://nba-back-cache.buenosaires.gob.ar/api/v1/buscador?texto=Mecenazgo

Query Metrics

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

Queries

Group similar statements

default connection

# Time Info
1 4.87 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 5
Parameters:
[
  ":search" => "%Mecenazgo%"
]
2 4.27 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" => "%Mecenazgo%"
]

api connection

# Time Info
1 0.79 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 area_gobierno WHERE deleted_at IS NULL AND visible = 1 AND (nombre LIKE :search OR descripcion LIKE :search) ORDER BY posicion ASC,nombre ASC LIMIT 5
Parameters:
[
  ":search" => "%Mecenazgo%"
]
2 0.51 ms
SELECT COUNT(id) AS cant FROM area_gobierno WHERE deleted_at IS NULL AND visible = 1 AND (nombre LIKE :search OR descripcion LIKE :search)
Parameters:
[
  ":search" => "%Mecenazgo%"
]

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.
App\Entity\App\AreaGobierno No errors.

log entity manager

No loaded entities.