Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.web_ident AS web_ident_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.map AS map_5,
  t0.custom_styles AS custom_styles_6,
  t0.start AS start_7,
  t0.end AS end_8,
  t0.catch_options AS catch_options_9,
  t0.status_id AS status_id_10
FROM
  fishing_race_race t0
WHERE
  t0.web_ident = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.web_ident AS web_ident_2, t0.name AS name_3, t0.description AS description_4, t0.map AS map_5, t0.custom_styles AS custom_styles_6, t0.start AS start_7, t0.end AS end_8, t0.catch_options AS catch_options_9, t0.status_id AS status_id_10 FROM fishing_race_race t0 WHERE t0.web_ident = '6' LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.logo AS logo_2,
  f0_.map AS map_3,
  f0_.id AS id_4,
  f0_.name AS name_5,
  f0_.logo AS logo_6,
  f0_.map AS map_7,
  f0_.status_id AS status_id_8
FROM
  fishing_race_area f0_
  INNER JOIN fishing_race_race_area f1_ ON f0_.id = f1_.area_id
WHERE
  f0_.id = ?
  AND f1_.race_id = ?
  AND f1_.status_id = ?

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.logo AS logo_2, f0_.map AS map_3, f0_.id AS id_4, f0_.name AS name_5, f0_.logo AS logo_6, f0_.map AS map_7, f0_.status_id AS status_id_8 FROM fishing_race_area f0_ INNER JOIN fishing_race_race_area f1_ ON f0_.id = f1_.area_id WHERE f0_.id = 11 AND f1_.race_id = 6 AND f1_.status_id = 1;

SELECT
  f0_.id AS id_0,
  f0_.number AS number_1,
  f0_.name AS name_2,
  f0_.description AS description_3,
  f0_.created AS created_4,
  f0_.status_id AS status_id_5,
  f0_.race_id AS race_id_6,
  f0_.area_pier_id AS area_pier_id_7
FROM
  fishing_race_team f0_
  LEFT JOIN __view_fishing_race_team_result t1_ ON f0_.id = t1_.team_id
WHERE
  f0_.race_id = ?
  AND f0_.status_id = ?
ORDER BY
  t1_.weight DESC
LIMIT
  1

SELECT f0_.id AS id_0, f0_.number AS number_1, f0_.name AS name_2, f0_.description AS description_3, f0_.created AS created_4, f0_.status_id AS status_id_5, f0_.race_id AS race_id_6, f0_.area_pier_id AS area_pier_id_7 FROM fishing_race_team f0_ LEFT JOIN __view_fishing_race_team_result t1_ ON f0_.id = t1_.team_id WHERE f0_.race_id = 6 AND f0_.status_id = 1 ORDER BY t1_.weight DESC LIMIT 1;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 445;

SELECT
  f0_.id AS id_0,
  f0_.number AS number_1,
  f0_.name AS name_2,
  f0_.description AS description_3,
  f0_.created AS created_4,
  f0_.status_id AS status_id_5,
  f0_.race_id AS race_id_6,
  f0_.area_pier_id AS area_pier_id_7
FROM
  fishing_race_team f0_
  INNER JOIN fishing_race_area_pier f1_ ON f0_.area_pier_id = f1_.id
  LEFT JOIN __view_fishing_race_team_result t2_ ON f0_.id = t2_.team_id
WHERE
  f1_.area_id = ?
  AND f0_.race_id = ?
  AND f0_.status_id = ?
GROUP BY
  f0_.id
ORDER BY
  t2_.weight DESC

SELECT f0_.id AS id_0, f0_.number AS number_1, f0_.name AS name_2, f0_.description AS description_3, f0_.created AS created_4, f0_.status_id AS status_id_5, f0_.race_id AS race_id_6, f0_.area_pier_id AS area_pier_id_7 FROM fishing_race_team f0_ INNER JOIN fishing_race_area_pier f1_ ON f0_.area_pier_id = f1_.id LEFT JOIN __view_fishing_race_team_result t2_ ON f0_.id = t2_.team_id WHERE f1_.area_id = 11 AND f0_.race_id = 6 AND f0_.status_id = 1 GROUP BY f0_.id ORDER BY t2_.weight DESC;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 504;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 502;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 509;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 498;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 503;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 495;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 497;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 507;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 511;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 501;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 505;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 506;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 500;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 508;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 499;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 510;

SELECT
  t0.weight AS weight_1,
  t0.team_id AS team_id_2
FROM
  __view_fishing_race_team_result t0
WHERE
  t0.team_id = ?

SELECT t0.weight AS weight_1, t0.team_id AS team_id_2 FROM __view_fishing_race_team_result t0 WHERE t0.team_id = 496;

select
  count(distinct frrc.id) as total_count
from
  fishing_race_team frt
  join fishing_race_area_pier frap on frap.id = frt.area_pier_id
  join fishing_race_catch frrc on frrc.team_id = frt.id
where
  frt.race_id = :race_id
  and frap.area_id = :area_id
  and frrc.status_id < 100
  and frt.status_id < 100

select count(distinct frrc.id) as total_count from fishing_race_team frt join fishing_race_area_pier frap on frap.id = frt.area_pier_id join fishing_race_catch frrc on frrc.team_id = frt.id where frt.race_id = 6 and frap.area_id = 11 and frrc.status_id < 100 and frt.status_id < 100;

select
  sum(frrc.weight) as weight_sum
from
  fishing_race_team frt
  join fishing_race_area_pier frap on frap.id = frt.area_pier_id
  join fishing_race_catch frrc on frrc.team_id = frt.id
where
  frt.race_id = :race_id
  and frap.area_id = :area_id
  and frrc.status_id < 100
  and frt.status_id < 100

select sum(frrc.weight) as weight_sum from fishing_race_team frt join fishing_race_area_pier frap on frap.id = frt.area_pier_id join fishing_race_catch frrc on frrc.team_id = frt.id where frt.race_id = 6 and frap.area_id = 11 and frrc.status_id < 100 and frt.status_id < 100;

select
  frrc.*,
  frap.name as pier_name,
  fra.name as area_name,
  frt.name as team_name
from
  fishing_race_team frt
  join fishing_race_area_pier frap on frap.id = frt.area_pier_id
  join fishing_race_area fra on fra.id = frap.area_id
  join fishing_race_catch frrc on frrc.team_id = frt.id
where
  frt.race_id = :race_id
  and frap.area_id = :area_id
  and frrc.status_id < 100
  and frt.status_id < 100
order by
  frrc.weight desc
limit
  1

select frrc.*, frap.name as pier_name, fra.name as area_name, frt.name as team_name from fishing_race_team frt join fishing_race_area_pier frap on frap.id = frt.area_pier_id join fishing_race_area fra on fra.id = frap.area_id join fishing_race_catch frrc on frrc.team_id = frt.id where frt.race_id = 6 and frap.area_id = 11 and frrc.status_id < 100 and frt.status_id < 100 order by frrc.weight desc limit 1;

select
  sum(frrc.weight > 30) as over_30,
  sum(frrc.weight > 25) as over_25,
  sum(frrc.weight > 20) as over_20,
  sum(frrc.weight > 15) as over_15
from
  fishing_race_team frt
  join fishing_race_area_pier frap on frap.id = frt.area_pier_id
  join fishing_race_area fra on fra.id = frap.area_id
  join fishing_race_catch frrc on frrc.team_id = frt.id
where
  frt.race_id = :race_id
  and frap.area_id = :area_id
  and frrc.status_id < 100
  and frt.status_id < 100

select sum(frrc.weight > 30) as over_30, sum(frrc.weight > 25) as over_25, sum(frrc.weight > 20) as over_20, sum(frrc.weight > 15) as over_15 from fishing_race_team frt join fishing_race_area_pier frap on frap.id = frt.area_pier_id join fishing_race_area fra on fra.id = frap.area_id join fishing_race_catch frrc on frrc.team_id = frt.id where frt.race_id = 6 and frap.area_id = 11 and frrc.status_id < 100 and frt.status_id < 100;

select
  avg(frrc.weight) as weight_sum
from
  fishing_race_team frt
  join fishing_race_area_pier frap on frap.id = frt.area_pier_id
  join fishing_race_catch frrc on frrc.team_id = frt.id
where
  frt.race_id = :race_id
  and frap.area_id = :area_id
  and frrc.status_id < 100

select avg(frrc.weight) as weight_sum from fishing_race_team frt join fishing_race_area_pier frap on frap.id = frt.area_pier_id join fishing_race_catch frrc on frrc.team_id = frt.id where frt.race_id = 6 and frap.area_id = 11 and frrc.status_id < 100;