Query Metrics
3
Database Queries
2
Different statements
168.95 ms
Query time
0
Invalid entities
1
Managed entities
Queries
| #▲ | 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. |