http://nba-back-cache.buenosaires.gob.ar/api/v1/buscador?texto=Validar%20mi%20identidad

Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
7.41 ms
(37.21%)
1
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" => "%Validar%mi%identidad%"
]
6.33 ms
(31.79%)
1
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" => "%Validar%mi%identidad%"
]

api connection

Time Count Info
3.26 ms
(16.37%)
1
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" => "%Validar%mi%identidad%"
]
2.91 ms
(14.63%)
1
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" => "%Validar%mi%identidad%"
]

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.