Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c1_.id AS id_2,
  c1_.name AS name_3,
  c2_.id AS id_4,
  c2_.code AS code_5,
  c2_.name AS name_6,
  h3_.title AS title_7
FROM
  constructions c0_
  LEFT JOIN construction_types c1_ ON (c1_.construction_id = c0_.id)
  LEFT JOIN construction_elements c2_ ON (
    c2_.construction_type_id = c1_.id
  )
  LEFT JOIN hotspots h3_ ON (h3_.code = c2_.hotspot)
WHERE
  h3_.title LIKE ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c1_.id AS id_2, c1_.name AS name_3, c2_.id AS id_4, c2_.code AS code_5, c2_.name AS name_6, h3_.title AS title_7 FROM constructions c0_ LEFT JOIN construction_types c1_ ON (c1_.construction_id = c0_.id) LEFT JOIN construction_elements c2_ ON (c2_.construction_type_id = c1_.id) LEFT JOIN hotspots h3_ ON (h3_.code = c2_.hotspot) WHERE h3_.title LIKE '%gaube%';

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  constructions t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM constructions t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.construction_id AS construction_id_3
FROM
  construction_types t0
WHERE
  t0.construction_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.construction_id AS construction_id_3 FROM construction_types t0 WHERE t0.construction_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.construction_id AS construction_id_3
FROM
  construction_types t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.construction_id AS construction_id_3 FROM construction_types t0;