GET https://game.devme.eu/fixtures

Query Metrics

41 Database Queries
3 Different statements
20.30 ms Query time
0 Invalid entities
53 Managed entities

Grouped Statements

Show all queries

Time Count Info
8.81 ms
(43.40%)
20
SELECT t0.id AS id_1, t0.sid AS sid_2, t0.name AS name_3, t0.main_color AS main_color_4, t0.secondary_color AS secondary_color_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.league_id AS league_id_8, t0.image_id AS image_id_9, t0.hover_image_id AS hover_image_id_10, t11.id AS id_12, t11.played AS played_13, t11.won AS won_14, t11.draw AS draw_15, t11.lost AS lost_16, t11.`for` AS for_17, t11.against AS against_18, t11.points AS points_19, t11.form AS form_20, t11.created_at AS created_at_21, t11.updated_at AS updated_at_22, t11.league_id AS league_id_23, t11.team_id AS team_id_24 FROM teams t0 LEFT JOIN rankings t11 ON t11.team_id = t0.id WHERE t0.id = ?
Parameters:
[
  19
]
6.61 ms
(32.55%)
20
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.deleted AS deleted_6 FROM admin_media t0 WHERE t0.id = ?
Parameters:
[
  60
]
4.88 ms
(24.06%)
1
SELECT t0.id AS id_1, t0.home_score AS home_score_2, t0.away_score AS away_score_3, t0.date_time AS date_time_4, t0.phase AS phase_5, t0.sid AS sid_6, t0.result AS result_7, t0.rewarded AS rewarded_8, t0.opened_at AS opened_at_9, t0.expired_at AS expired_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.league_id AS league_id_13, t0.home_id AS home_id_14, t0.away_id AS away_id_15 FROM fixtures t0
Parameters:
[]

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
AdminBundle\Entity\Media 21
AppBundle\Entity\Team 20
AppBundle\Entity\Game 10
AppBundle\Entity\League 1
AppBundle\Entity\Ranking 1

Entities Mapping

Class Mapping errors
AppBundle\Entity\Game No errors.
AppBundle\Entity\League No errors.
AppBundle\Entity\Team No errors.
AdminBundle\Entity\Media No errors.
AppBundle\Entity\Ranking No errors.