https://pereira.sym.jumo.idp.lu/

Query Metrics

12 Database Queries
11 Different statements
2.15 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.05 ms
(0.00%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.has_title AS has_title_4, t0.section AS section_5, t0.sub_section AS sub_section_6, t0.image_section AS image_section_7 FROM block_title_description t0 WHERE t0.section = ? AND t0.sub_section = ? LIMIT 1
Parameters:
[
  "about"
  "description"
]
0.17 ms
(0.00%)
1
SELECT y0_.id AS id_0, y0_.section AS section_1, y0_.sub_section AS sub_section_2, y0_.name AS name_3, y0_.race_img AS race_img_4, i1_.id AS id_5, i1_.url AS url_6, i1_.name AS name_7, i1_.link AS link_8, y0_.race_id AS race_id_9, i1_.year_id AS year_id_10 FROM year y0_ INNER JOIN image i1_ ON y0_.id = i1_.year_id WHERE y0_.section = ? AND y0_.sub_section LIKE ?
Parameters:
[
  "gallery"
  "2026-01-01%"
]
0.15 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.button_link AS button_link_4, t0.has_button AS has_button_5, t0.block_title_description_id AS block_title_description_id_6, t0.year_id AS year_id_7, t0.race_id AS race_id_8 FROM line_table t0 WHERE t0.block_title_description_id = ?
Parameters:
[
  2
]
0.15 ms
(0.00%)
1
SELECT y0_.section AS section_0, y0_.sub_section AS sub_section_1, y0_.name AS name_2, y0_.id AS id_3, i1_.name AS name_4, i1_.id AS id_5, i1_.url AS url_6 FROM year y0_ INNER JOIN image i1_ ON y0_.id = i1_.year_id WHERE y0_.section = ? GROUP BY y0_.sub_section ORDER BY y0_.sub_section DESC
Parameters:
[
  "gallery"
]
0.14 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.section AS section_2, t0.sub_section AS sub_section_3, t0.name AS name_4, t0.race_img AS race_img_5, t0.race_id AS race_id_6 FROM year t0 WHERE t0.section = ? LIMIT 1
Parameters:
[
  "sponsors"
]
0.11 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.name AS name_3, t0.link AS link_4, t0.year_id AS year_id_5 FROM image t0 WHERE t0.year_id = ?
Parameters:
[
  3
]
0.09 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.section AS section_2, t0.sub_section AS sub_section_3, t0.name AS name_4, t0.race_img AS race_img_5, t0.race_id AS race_id_6 FROM year t0 WHERE t0.section = ?
Parameters:
[
  "results"
]
0.07 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.button_link AS button_link_4, t0.has_button AS has_button_5, t0.block_title_description_id AS block_title_description_id_6, t0.year_id AS year_id_7, t0.race_id AS race_id_8 FROM line_table t0 WHERE t0.year_id = ?
Parameters:
[
  5
]
0.07 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.section AS section_2, t0.sub_section AS sub_section_3, t0.name AS name_4, t0.race_img AS race_img_5, t0.race_id AS race_id_6 FROM year t0 WHERE t0.race_id = ?
Parameters:
[
  1
]
0.07 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.country AS country_2, t0.at_date AS at_date_3, t0.image AS image_4, t0.is_valid AS is_valid_5, t0.racing_name AS racing_name_6, t0.background_image AS background_image_7 FROM next_race t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.06 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.car_img AS car_img_4, t0.technical_file AS technical_file_5, t0.video AS video_6 FROM race t0
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.

Entities Mapping

Class Mapping errors
App\Entity\BlockTitleDescription No errors.
App\Entity\Year No errors.
App\Entity\NextRace No errors.
App\Entity\Race No errors.
App\Entity\LineTable
  • The association App\Entity\LineTable#race refers to the inverse side field App\Entity\Race#lineTables which does not exist.
App\Entity\Image No errors.
App\Entity\YearImage No errors.