GET https://chingy.cisse.ovh/analysis/game/1?type=frequency

Query Metrics

3 Database Queries
2 Different statements
168.95 ms Query time
0 Invalid entities
1 Managed entities

Queries

Group similar statements

# Time Info
1 6.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.number_of_balls AS number_of_balls_3, t0.number_of_jokers AS number_of_jokers_4, t0.number_of_stars AS number_of_stars_5, t0.max_number AS max_number_6, t0.max_star_number AS max_star_number_7, t0.days AS days_8, t0.strategy_identifier AS strategy_identifier_9 FROM game t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 96.72 ms
SELECT b0_.number AS number_0, b0_.type AS type_1, COUNT(b0_.id) AS sclr_2 FROM ball b0_ INNER JOIN draw d1_ ON b0_.draw_id = d1_.id WHERE d1_.game_id = ? GROUP BY b0_.number, b0_.type ORDER BY sclr_2 DESC
Parameters:
[
  1
]
3 66.05 ms
SELECT b0_.number AS number_0, b0_.type AS type_1, COUNT(b0_.id) AS sclr_2 FROM ball b0_ INNER JOIN draw d1_ ON b0_.draw_id = d1_.id WHERE d1_.game_id = ? GROUP BY b0_.number, b0_.type ORDER BY sclr_2 DESC
Parameters:
[
  1
]

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\Game 1

Entities Mapping

Class Mapping errors
App\Entity\Game No errors.
App\Entity\Draw No errors.
App\Entity\Sync No errors.
App\Entity\Ball No errors.