GET https://testing.esco.net.ar/

Query Metrics

5 Database Queries
5 Different statements
3.18 ms Query time
0 Invalid entities

Queries

Group similar statements

mysql connection

# Time Info
1 0.37 ms
SELECT s0_.idsorteo AS idsorteo_0, s0_.periodo AS periodo_1, s0_.anio AS anio_2, s0_.mes AS mes_3, s0_.nrosorteo1 AS nrosorteo1_4, s0_.nrosorteo2 AS nrosorteo2_5, s0_.nrosorteo3 AS nrosorteo3_6, s0_.fechasorteo AS fechasorteo_7, s0_.sorteopor AS sorteopor_8, s0_.fechaprovisoria AS fechaprovisoria_9 FROM sorteos s0_ WHERE COALESCE(s0_.nrosorteo1, -1) = -1 ORDER BY s0_.idsorteo ASC LIMIT 1
Parameters:
[]
2 0.28 ms
SELECT s0_.idsorteo AS idsorteo_0, s0_.periodo AS periodo_1, s0_.anio AS anio_2, s0_.mes AS mes_3, s0_.nrosorteo1 AS nrosorteo1_4, s0_.nrosorteo2 AS nrosorteo2_5, s0_.nrosorteo3 AS nrosorteo3_6, s0_.fechasorteo AS fechasorteo_7, s0_.sorteopor AS sorteopor_8, s0_.fechaprovisoria AS fechaprovisoria_9 FROM sorteos s0_ WHERE COALESCE(s0_.nrosorteo1, -1) >= 0 ORDER BY s0_.periodo DESC LIMIT 1
Parameters:
[]
3 0.27 ms
SELECT s0_.anio AS anio_0 FROM sorteos s0_ GROUP BY s0_.anio ORDER BY s0_.anio DESC
Parameters:
[]
4 0.13 ms
SELECT t0.id AS id_1, t0.nombreparametro AS nombreparametro_2, t0.valor AS valor_3 FROM dc_tparamsistema t0 WHERE t0.id = ?
Parameters:
[
  9
]

mssql connection

# Time Info
1 2.13 ms
SELECT e0_.idEntidadRecaudadora AS idEntidadRecaudadora_0, e0_.link AS link_1, e0_.conBoleta AS conBoleta_2, e0_.nombreWeb AS nombreWeb_3, e0_.imagen AS imagen_4 FROM WEB.entidades_recaudadoras e0_ WHERE e0_.vigente = 1 ORDER BY e0_.conBoleta ASC, e0_.orden ASC
Parameters:
[]

Database Connections

Name Service
mssql doctrine.dbal.mssql_connection
mysql doctrine.dbal.mysql_connection

Entity Managers

Name Service
mssql doctrine.orm.mssql_entity_manager
mysql doctrine.orm.mysql_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

mssql entity manager

Class Mapping errors
App\Entity\MSSQL\EntidadesRecaudadoras No errors.

mysql entity manager

Class Mapping errors
App\Entity\MySQL\Sorteos No errors.
App\Entity\MySQL\DcTparamsistema No errors.