GET http://myclubview.azestudio.net/c/sant-ignasi-ce/equipo/35/clasificacion

Query Metrics

19 Database Queries
5 Different statements
4.61 ms Query time
0 Invalid entities
32 Managed entities

Queries

Group similar statements

# Time Info
1 0.43 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria AS categoria_3, t0.url_fcf AS url_fcf_4, t0.url_escudo AS url_escudo_5, t0.slug_fcf AS slug_fcf_6, t0.url_equipo AS url_equipo_7, t0.url_calendario AS url_calendario_8, t0.time_updated AS time_updated_9, t0.raw_detalles AS raw_detalles_10, t0.club_id AS club_id_11 FROM equipo t0 WHERE t0.id = ?
Parameters:
[
  "35"
]
2 0.45 ms
SELECT t0.id AS id_1, t0.estado AS estado_2, t0.nombre AS nombre_3, t0.url_escudo AS url_escudo_4, t0.slug_fcf AS slug_fcf_5, t0.localizacion AS localizacion_6, t0.url_fcf AS url_fcf_7, t0.raw_equipos AS raw_equipos_8, t0.time_updated AS time_updated_9 FROM club t0 WHERE t0.slug_fcf = ? LIMIT 1
Parameters:
[
  "sant-ignasi-ce"
]
3 0.26 ms
SELECT t0.id AS id_1, t0.partidos_jugados AS partidos_jugados_2, t0.ganados AS ganados_3, t0.empatados AS empatados_4, t0.perdidos AS perdidos_5, t0.goles_favor AS goles_favor_6, t0.goles_contra AS goles_contra_7, t0.puntos AS puntos_8, t0.estado AS estado_9, t0.equipo_id AS equipo_id_10, t0.competicion_id AS competicion_id_11 FROM resultado t0 WHERE t0.equipo_id = ?
Parameters:
[
  35
]
4 0.26 ms
SELECT t0.id AS id_1, t0.partidos_jugados AS partidos_jugados_2, t0.ganados AS ganados_3, t0.empatados AS empatados_4, t0.perdidos AS perdidos_5, t0.goles_favor AS goles_favor_6, t0.goles_contra AS goles_contra_7, t0.puntos AS puntos_8, t0.estado AS estado_9, t0.equipo_id AS equipo_id_10, t0.competicion_id AS competicion_id_11 FROM resultado t0 WHERE t0.competicion_id = ? ORDER BY t0.puntos DESC, t0.goles_favor DESC
Parameters:
[
  24
]
5 0.78 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.grup AS grup_3, t0.categoria AS categoria_4, t0.url_fcf AS url_fcf_5, t0.url_clasificacion AS url_clasificacion_6, t0.raw_calendario AS raw_calendario_7, t0.raw_clasificacion AS raw_clasificacion_8, t0.time_updated AS time_updated_9 FROM competicion t0 WHERE t0.id = ?
Parameters:
[
  24
]
6 0.25 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria AS categoria_3, t0.url_fcf AS url_fcf_4, t0.url_escudo AS url_escudo_5, t0.slug_fcf AS slug_fcf_6, t0.url_equipo AS url_equipo_7, t0.url_calendario AS url_calendario_8, t0.time_updated AS time_updated_9, t0.raw_detalles AS raw_detalles_10, t0.club_id AS club_id_11 FROM equipo t0 WHERE t0.id = ?
Parameters:
[
  358
]
7 0.17 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria AS categoria_3, t0.url_fcf AS url_fcf_4, t0.url_escudo AS url_escudo_5, t0.slug_fcf AS slug_fcf_6, t0.url_equipo AS url_equipo_7, t0.url_calendario AS url_calendario_8, t0.time_updated AS time_updated_9, t0.raw_detalles AS raw_detalles_10, t0.club_id AS club_id_11 FROM equipo t0 WHERE t0.id = ?
Parameters:
[
  364
]
8 0.20 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria AS categoria_3, t0.url_fcf AS url_fcf_4, t0.url_escudo AS url_escudo_5, t0.slug_fcf AS slug_fcf_6, t0.url_equipo AS url_equipo_7, t0.url_calendario AS url_calendario_8, t0.time_updated AS time_updated_9, t0.raw_detalles AS raw_detalles_10, t0.club_id AS club_id_11 FROM equipo t0 WHERE t0.id = ?
Parameters:
[
  368
]
9 0.16 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria AS categoria_3, t0.url_fcf AS url_fcf_4, t0.url_escudo AS url_escudo_5, t0.slug_fcf AS slug_fcf_6, t0.url_equipo AS url_equipo_7, t0.url_calendario AS url_calendario_8, t0.time_updated AS time_updated_9, t0.raw_detalles AS raw_detalles_10, t0.club_id AS club_id_11 FROM equipo t0 WHERE t0.id = ?
Parameters:
[
  356
]
10 0.16 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria AS categoria_3, t0.url_fcf AS url_fcf_4, t0.url_escudo AS url_escudo_5, t0.slug_fcf AS slug_fcf_6, t0.url_equipo AS url_equipo_7, t0.url_calendario AS url_calendario_8, t0.time_updated AS time_updated_9, t0.raw_detalles AS raw_detalles_10, t0.club_id AS club_id_11 FROM equipo t0 WHERE t0.id = ?
Parameters:
[
  367
]
11 0.15 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria AS categoria_3, t0.url_fcf AS url_fcf_4, t0.url_escudo AS url_escudo_5, t0.slug_fcf AS slug_fcf_6, t0.url_equipo AS url_equipo_7, t0.url_calendario AS url_calendario_8, t0.time_updated AS time_updated_9, t0.raw_detalles AS raw_detalles_10, t0.club_id AS club_id_11 FROM equipo t0 WHERE t0.id = ?
Parameters:
[
  362
]
12 0.16 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria AS categoria_3, t0.url_fcf AS url_fcf_4, t0.url_escudo AS url_escudo_5, t0.slug_fcf AS slug_fcf_6, t0.url_equipo AS url_equipo_7, t0.url_calendario AS url_calendario_8, t0.time_updated AS time_updated_9, t0.raw_detalles AS raw_detalles_10, t0.club_id AS club_id_11 FROM equipo t0 WHERE t0.id = ?
Parameters:
[
  357
]
13 0.15 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria AS categoria_3, t0.url_fcf AS url_fcf_4, t0.url_escudo AS url_escudo_5, t0.slug_fcf AS slug_fcf_6, t0.url_equipo AS url_equipo_7, t0.url_calendario AS url_calendario_8, t0.time_updated AS time_updated_9, t0.raw_detalles AS raw_detalles_10, t0.club_id AS club_id_11 FROM equipo t0 WHERE t0.id = ?
Parameters:
[
  361
]
14 0.16 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria AS categoria_3, t0.url_fcf AS url_fcf_4, t0.url_escudo AS url_escudo_5, t0.slug_fcf AS slug_fcf_6, t0.url_equipo AS url_equipo_7, t0.url_calendario AS url_calendario_8, t0.time_updated AS time_updated_9, t0.raw_detalles AS raw_detalles_10, t0.club_id AS club_id_11 FROM equipo t0 WHERE t0.id = ?
Parameters:
[
  360
]
15 0.16 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria AS categoria_3, t0.url_fcf AS url_fcf_4, t0.url_escudo AS url_escudo_5, t0.slug_fcf AS slug_fcf_6, t0.url_equipo AS url_equipo_7, t0.url_calendario AS url_calendario_8, t0.time_updated AS time_updated_9, t0.raw_detalles AS raw_detalles_10, t0.club_id AS club_id_11 FROM equipo t0 WHERE t0.id = ?
Parameters:
[
  369
]
16 0.16 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria AS categoria_3, t0.url_fcf AS url_fcf_4, t0.url_escudo AS url_escudo_5, t0.slug_fcf AS slug_fcf_6, t0.url_equipo AS url_equipo_7, t0.url_calendario AS url_calendario_8, t0.time_updated AS time_updated_9, t0.raw_detalles AS raw_detalles_10, t0.club_id AS club_id_11 FROM equipo t0 WHERE t0.id = ?
Parameters:
[
  366
]
17 0.16 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria AS categoria_3, t0.url_fcf AS url_fcf_4, t0.url_escudo AS url_escudo_5, t0.slug_fcf AS slug_fcf_6, t0.url_equipo AS url_equipo_7, t0.url_calendario AS url_calendario_8, t0.time_updated AS time_updated_9, t0.raw_detalles AS raw_detalles_10, t0.club_id AS club_id_11 FROM equipo t0 WHERE t0.id = ?
Parameters:
[
  359
]
18 0.25 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria AS categoria_3, t0.url_fcf AS url_fcf_4, t0.url_escudo AS url_escudo_5, t0.slug_fcf AS slug_fcf_6, t0.url_equipo AS url_equipo_7, t0.url_calendario AS url_calendario_8, t0.time_updated AS time_updated_9, t0.raw_detalles AS raw_detalles_10, t0.club_id AS club_id_11 FROM equipo t0 WHERE t0.id = ?
Parameters:
[
  363
]
19 0.16 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.categoria AS categoria_3, t0.url_fcf AS url_fcf_4, t0.url_escudo AS url_escudo_5, t0.slug_fcf AS slug_fcf_6, t0.url_equipo AS url_equipo_7, t0.url_calendario AS url_calendario_8, t0.time_updated AS time_updated_9, t0.raw_detalles AS raw_detalles_10, t0.club_id AS club_id_11 FROM equipo t0 WHERE t0.id = ?
Parameters:
[
  365
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Equipo 15
App\Entity\Resultado 15
App\Entity\Club 1
App\Entity\Competicion 1

Entities Mapping

Class Mapping errors
App\Entity\Equipo No errors.
App\Entity\Club No errors.
App\Entity\Persona No errors.
App\Entity\Resultado No errors.
App\Entity\Competicion No errors.