GET https://chingy.cisse.ovh/results/

Query Metrics

37 Database Queries
7 Different statements
73.90 ms Query time
0 Invalid entities
365 Managed entities

Queries

Group similar statements

# 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.