Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.startdate AS startdate_3,
  t0.enddate AS enddate_4,
  t0.location AS location_5,
  t0.isactive AS isactive_6,
  t0.placeid AS placeid_7,
  t0.locationhidden AS locationhidden_8,
  t0.creationdate AS creationdate_9,
  t0.festival_id AS festival_id_10,
  t0.description_id AS description_id_11,
  t12.id AS id_13,
  t12.route AS route_14,
  t12.festival_id AS festival_id_15,
  t12.edition_id AS edition_id_16
FROM
  bfedition t0
  LEFT JOIN bfrouting t12 ON t12.edition_id = t0.id
WHERE
  t0.festival_id = ?
ORDER BY
  t0.enddate DESC,
  t0.startdate DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.startdate AS startdate_3, t0.enddate AS enddate_4, t0.location AS location_5, t0.isactive AS isactive_6, t0.placeid AS placeid_7, t0.locationhidden AS locationhidden_8, t0.creationdate AS creationdate_9, t0.festival_id AS festival_id_10, t0.description_id AS description_id_11, t12.id AS id_13, t12.route AS route_14, t12.festival_id AS festival_id_15, t12.edition_id AS edition_id_16 FROM bfedition t0 LEFT JOIN bfrouting t12 ON t12.edition_id = t0.id WHERE t0.festival_id = 7 ORDER BY t0.enddate DESC, t0.startdate DESC;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.creationdate AS creationdate_2,
  b0_.orderfeebf AS orderfeebf_3,
  b0_.stripeaccountid AS stripeaccountid_4,
  b0_.description_id AS description_id_5,
  b0_.owner_id AS owner_id_6
FROM
  bffestival b0_
ORDER BY
  b0_.name ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.creationdate AS creationdate_2, b0_.orderfeebf AS orderfeebf_3, b0_.stripeaccountid AS stripeaccountid_4, b0_.description_id AS description_id_5, b0_.owner_id AS owner_id_6 FROM bffestival b0_ ORDER BY b0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.optionname AS optionname_2,
  t0.validitydate AS validitydate_3,
  t0.festival_id AS festival_id_4,
  t0.edition_id AS edition_id_5,
  t0.challenge_id AS challenge_id_6
FROM
  bfadmin_licences t0
WHERE
  t0.festival_id = ?

SELECT t0.id AS id_1, t0.optionname AS optionname_2, t0.validitydate AS validitydate_3, t0.festival_id AS festival_id_4, t0.edition_id AS edition_id_5, t0.challenge_id AS challenge_id_6 FROM bfadmin_licences t0 WHERE t0.festival_id = 7;

SELECT
  t0.id AS id_1,
  t0.route AS route_2,
  t0.festival_id AS festival_id_3,
  t0.edition_id AS edition_id_4
FROM
  bfrouting t0
WHERE
  t0.festival_id = ?

SELECT t0.id AS id_1, t0.route AS route_2, t0.festival_id AS festival_id_3, t0.edition_id AS edition_id_4 FROM bfrouting t0 WHERE t0.festival_id = 7;

SELECT
  t0.id AS id_1,
  t0.optionname AS optionname_2,
  t0.validitydate AS validitydate_3,
  t0.festival_id AS festival_id_4,
  t0.edition_id AS edition_id_5,
  t0.challenge_id AS challenge_id_6
FROM
  bfadmin_licences t0
WHERE
  t0.edition_id = ?

SELECT t0.id AS id_1, t0.optionname AS optionname_2, t0.validitydate AS validitydate_3, t0.festival_id AS festival_id_4, t0.edition_id AS edition_id_5, t0.challenge_id AS challenge_id_6 FROM bfadmin_licences t0 WHERE t0.edition_id = 5;