GET https://chingy.cisse.ovh/game/1

Query Metrics

45 Database Queries
7 Different statements
195.47 ms Query time
0 Invalid entities
180 Managed entities

Queries

Group similar statements

# Time Info
1 7.80 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 36.50 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, d0_.game_id AS game_id_8 FROM draw d0_ WHERE d0_.game_id = ? ORDER BY d0_.date DESC LIMIT 20
Parameters:
[
  1
]
3 7.12 ms
SELECT t0.id AS id_1, t0.last_sync_date AS last_sync_date_2, t0.last_data_date AS last_data_date_3, t0.total_records AS total_records_4, t0.last_import_records AS last_import_records_5, t0.last_import_file AS last_import_file_6, t0.status AS status_7, t0.last_error AS last_error_8, t0.processed_rows AS processed_rows_9, t0.total_rows AS total_rows_10, t0.last_processed_file AS last_processed_file_11, t0.last_file_hash AS last_file_hash_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.game_id AS game_id_15 FROM sync t0 WHERE t0.game_id = ? LIMIT 1
Parameters:
[
  1
]
4 10.77 ms
SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ WHERE d0_.game_id = ?
Parameters:
[
  1
]
5 17.29 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, d0_.game_id AS game_id_8 FROM draw d0_ WHERE d0_.game_id = ? ORDER BY d0_.date DESC LIMIT 1
Parameters:
[
  1
]
6 5.30 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  7425
]
7 3.90 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:
[
  7425
]
8 3.77 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  7424
]
9 3.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:
[
  7424
]
10 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.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  7423
]
11 3.83 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:
[
  7423
]
12 3.44 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  7422
]
13 1.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:
[
  7422
]
14 3.84 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  7421
]
15 3.22 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:
[
  7421
]
16 3.67 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  2629
]
17 1.35 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:
[
  2629
]
18 2.67 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  2630
]
19 3.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:
[
  2630
]
20 1.88 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  2631
]
21 3.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:
[
  2631
]
22 5.29 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  2632
]
23 2.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:
[
  2632
]
24 1.86 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  2633
]
25 3.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:
[
  2633
]
26 3.45 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  2634
]
27 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:
[
  2634
]
28 3.64 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  2635
]
29 2.16 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:
[
  2635
]
30 2.92 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  2636
]
31 3.61 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:
[
  2636
]
32 1.52 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  2637
]
33 3.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:
[
  2637
]
34 1.67 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  2638
]
35 2.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:
[
  2638
]
36 2.71 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  2639
]
37 3.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:
[
  2639
]
38 1.89 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  2640
]
39 3.64 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:
[
  2640
]
40 3.55 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  2641
]
41 1.82 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:
[
  2641
]
42 2.86 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  2642
]
43 3.26 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:
[
  2642
]
44 2.61 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?
Parameters:
[
  2643
]
45 2.02 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:
[
  2643
]

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\Ball 120
App\Entity\Joker 38
App\Entity\Draw 20
App\Entity\Game 1
App\Entity\Sync 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.
App\Entity\Joker No errors.
App\Entity\Prize No errors.