Query Metrics
3
Database Queries
3
Different statements
0.88 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.39 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.birth_date AS birth_date_4, t0.id_ffn AS id_ffn_5, t0.last_competition_date_update AS last_competition_date_update_6, t0.country_id AS country_id_7, t0.club_id AS club_id_8, t0.gender_id AS gender_id_9 FROM swimmer t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
50
]
|
||||||||||||||||||||||||||
| 2 | 0.24 ms |
SELECT r.id, r.heat, r.final_time, r.reaction_time, r.place, r.place_heat, r.lane, r.date_race, ra.id AS id_race, ra.name AS name_race, ra.short_name AS short_name_race, ra.relay AS relay_race, rt.id AS id_result_type, rt.name AS name_result_type, ca.id AS id_category, ca.name AS name_category, c.name AS name_competition, c.short_name, cor.name AS name_country_result, ci.id AS id_city, ci.name AS name_city, co.name AS name_country, ct.id AS id_competition_type, ct.name AS name_competition_type, cd.id AS id_competition_discipline, cd.name AS name_competition_discipline, ps.id AS id_pool_size, CONCAT(ps.size, ps.metric) AS name_pool_size, cl.id AS id_club, cl.name AS name_club, di.name AS name_disqualification, GROUP_CONCAT(CONCAT(rsp.distance,'-',rsp.split_time_modified) ORDER BY rsp.distance SEPARATOR '/') AS splits FROM result r INNER JOIN race_gender rg ON (r.race_gender_id = rg.id) INNER JOIN race ra ON (rg.race_id = ra.id) INNER JOIN stroke st ON (ra.stroke_id = st.id) INNER JOIN result_type rt ON (r.result_type_id = rt.id) INNER JOIN result_swimmer rs ON (rs.result_id = r.id) INNER JOIN competition_swimmer cs ON (rs.competition_swimmer_id = cs.id) INNER JOIN competition c ON (r.competition_id = c.id) INNER JOIN city ci ON (c.city_id = ci.id) INNER JOIN competition_type ct ON (c.competition_type_id = ct.id) INNER JOIN competition_discipline cd ON (c.competition_discipline_id = cd.id) INNER JOIN pool_size ps ON (c.pool_size_id = ps.id) INNER JOIN country cor ON (r.country_id = cor.id) INNER JOIN result_swimmer_split rsp ON (rsp.result_swimmer_id = rs.id) LEFT JOIN country co ON (ci.country_id = co.id) LEFT JOIN category ca ON (r.category_id = ca.id) LEFT JOIN club cl ON (r.club_id = cl.id) LEFT JOIN disqualification di ON (r.disqualification_id = di.id) WHERE cs.swimmer_id = :idSwimmer GROUP BY r.id, r.heat, r.final_time, r.reaction_time, r.place, r.place_heat, r.lane, r.date_race, ra.id, ra.name, ra.short_name, ra.relay, rt.id, rt.name, ca.id, ca.name, c.name, c.short_name, cor.name, ci.id, ci.name, co.name, ct.id, ct.name, cd.id, cd.name, ps.id, ps.size, ps.metric, cl.id, cl.name, di.name ORDER BY ra.relay ASC, st.order_display ASC, ra.distance ASC, rt.order_display ASC, r.date_race DESC;
Parameters:
[ "idSwimmer" => 50 ]
|
||||||||||||||||||||||||||
| 3 | 0.25 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c1_.id AS id_2, c1_.name AS name_3, COUNT(c2_.id) AS sclr_4 FROM competition c2_ INNER JOIN competition_type c0_ ON c2_.competition_type_id = c0_.id INNER JOIN competition_discipline c1_ ON c2_.competition_discipline_id = c1_.id GROUP BY c0_.id, c0_.name, c1_.id, c1_.name ORDER BY c1_.id ASC, c0_.id ASC
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 |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Swimmer | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Club | No errors. |
| App\Entity\Gender | No errors. |
| App\Entity\Result | No errors. |
| App\Entity\Competition | No errors. |
| App\Entity\CompetitionType | No errors. |
| App\Entity\CompetitionDiscipline | No errors. |