Query Metrics
37
Database Queries
7
Different statements
73.90 ms
Query time
0
Invalid entities
365
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 5.38 ms |
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ WHERE d0_.date >= ?
Parameters:
[
"2026-07-25 23:26:44"
]
|
| 2 | 2.55 ms |
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id
Parameters:
[] |
| 3 | 1.91 ms |
SELECT d0_.date AS date_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id ORDER BY d0_.date DESC LIMIT 1
Parameters:
[] |
| 4 | 1.52 ms |
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id
Parameters:
[] |
| 5 | 1.56 ms |
SELECT d0_.date AS date_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id ORDER BY d0_.date DESC LIMIT 1
Parameters:
[] |
| 6 | 1.28 ms |
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id
Parameters:
[] |
| 7 | 1.20 ms |
SELECT d0_.date AS date_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id ORDER BY d0_.date DESC LIMIT 1
Parameters:
[] |
| 8 | 1.14 ms |
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id
Parameters:
[] |
| 9 | 1.21 ms |
SELECT d0_.date AS date_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id ORDER BY d0_.date DESC LIMIT 1
Parameters:
[] |
| 10 | 0.45 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
Parameters:
[] |
| 11 | 2.07 ms |
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id
Parameters:
[] |
| 12 | 2.10 ms |
SELECT d0_.id AS id_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id ORDER BY d0_.date DESC LIMIT 20
Parameters:
[] |
| 13 | 33.10 ms |
SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.forclusion_date AS forclusion_date_2, d0_.draw_number AS draw_number_3, d0_.day_of_week AS day_of_week_4, d0_.draw_type AS draw_type_5, d0_.currency AS currency_6, d0_.raw AS raw_7, g1_.id AS id_8, g1_.name AS name_9, g1_.number_of_balls AS number_of_balls_10, g1_.number_of_jokers AS number_of_jokers_11, g1_.number_of_stars AS number_of_stars_12, g1_.max_number AS max_number_13, g1_.max_star_number AS max_star_number_14, g1_.days AS days_15, g1_.strategy_identifier AS strategy_identifier_16, b2_.id AS id_17, b2_.number AS number_18, b2_.position AS position_19, b2_.type AS type_20, b2_.is_complementary AS is_complementary_21, p3_.id AS id_22, p3_.rank AS rank_23, p3_.winners_france AS winners_france_24, p3_.winners_europe AS winners_europe_25, p3_.prize_amount AS prize_amount_26, p3_.currency AS currency_27, d0_.game_id AS game_id_28, b2_.draw_id AS draw_id_29, p3_.draw_id AS draw_id_30 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id LEFT JOIN ball b2_ ON d0_.id = b2_.draw_id LEFT JOIN prize p3_ ON d0_.id = p3_.draw_id WHERE d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY d0_.date DESC
Parameters:
[ 7591 7590 7589 7588 7587 7586 7585 7584 7583 7582 7581 7580 7575 7578 7576 7577 7579 7574 7573 7572 ] |
| 14 | 1.36 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7591
]
|
| 15 | 0.46 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7590
]
|
| 16 | 0.42 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7589
]
|
| 17 | 0.41 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7588
]
|
| 18 | 0.42 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7587
]
|
| 19 | 0.43 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7586
]
|
| 20 | 0.44 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7585
]
|
| 21 | 0.39 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7584
]
|
| 22 | 0.41 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7583
]
|
| 23 | 0.40 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7582
]
|
| 24 | 0.44 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7581
]
|
| 25 | 0.42 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7580
]
|
| 26 | 0.40 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7575
]
|
| 27 | 0.38 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7578
]
|
| 28 | 1.14 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7576
]
|
| 29 | 1.43 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7577
]
|
| 30 | 0.54 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7579
]
|
| 31 | 1.49 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7574
]
|
| 32 | 0.57 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7573
]
|
| 33 | 0.42 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?
Parameters:
[
7572
]
|
| 34 | 2.33 ms |
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id
Parameters:
[] |
| 35 | 1.37 ms |
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id
Parameters:
[] |
| 36 | 1.20 ms |
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id
Parameters:
[] |
| 37 | 1.17 ms |
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id
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 |
|---|---|
| App\Entity\Prize | 188 |
| App\Entity\Ball | 128 |
| App\Entity\Joker | 27 |
| App\Entity\Draw | 20 |
| App\Entity\Game | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Draw | No errors. |
| App\Entity\Game | No errors. |
| App\Entity\Sync | No errors. |
| App\Entity\Ball | No errors. |
| App\Entity\Prize | No errors. |
| App\Entity\Joker | No errors. |