Redirect 301 redirect from GET @app_results_index (6fb996)

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

Query Metrics

37 Database Queries
7 Different statements
164.73 ms Query time
0 Invalid entities
366 Managed entities

Queries

Group similar statements

# Time Info
1 15.45 ms
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ WHERE d0_.date >= ?
Parameters:
[
  "2026-03-29 00:24:13"
]
2 7.35 ms
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id
Parameters:
[]
3 4.31 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 3.68 ms
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id
Parameters:
[]
5 3.37 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 2.60 ms
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id
Parameters:
[]
7 2.84 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 2.54 ms
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id
Parameters:
[]
9 2.80 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 3.23 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 5.18 ms
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id
Parameters:
[]
12 5.19 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 64.07 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:
[
  7506
  7505
  7504
  7503
  7502
  7501
  7500
  7499
  7498
  7497
  7496
  7495
  7494
  7493
  7492
  7491
  7490
  7489
  7488
  7487
]
14 2.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:
[
  7506
]
15 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:
[
  7505
]
16 0.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:
[
  7504
]
17 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:
[
  7503
]
18 1.47 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:
[
  7502
]
19 1.65 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:
[
  7501
]
20 1.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:
[
  7500
]
21 2.19 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:
[
  7499
]
22 1.97 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:
[
  7498
]
23 1.78 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:
[
  7497
]
24 0.45 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:
[
  7496
]
25 2.25 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:
[
  7495
]
26 1.62 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:
[
  7494
]
27 1.59 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:
[
  7493
]
28 1.55 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:
[
  7492
]
29 1.53 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:
[
  7491
]
30 1.74 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:
[
  7490
]
31 1.53 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:
[
  7489
]
32 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:
[
  7488
]
33 1.60 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:
[
  7487
]
34 3.97 ms
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id
Parameters:
[]
35 2.86 ms
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id
Parameters:
[]
36 3.70 ms
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id
Parameters:
[]
37 2.18 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 28
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.