Symfony Profiler

SELECT
  c.id AS construction_id,
  c.name AS construction_name,
  ct.id AS type_id,
  ct.name AS type_name,
  ce.id AS element_id,
  ce.code AS element_code,
  ce.name AS element_name,
  ce.count_requests AS count_requests
FROM
  constructions c
  LEFT JOIN construction_types ct ON (ct.construction_id = c.id)
  LEFT JOIN construction_elements ce ON (ce.construction_type_id = ct.id)
WHERE
  construction_type_id IN (
    SELECT
      ct.id
    FROM
      construction_types ct
    WHERE
      construction_id = 1
  )
ORDER BY
  count_requests DESC
LIMIT
  2

SELECT
                        c.id AS construction_id,
                        c.name AS construction_name,
                        ct.id AS type_id,
                        ct.name AS type_name,
                        ce.id AS element_id,
                        ce.code AS element_code,
                        ce.name AS element_name,
                        ce.count_requests AS count_requests
                    FROM constructions c
                    LEFT JOIN construction_types ct ON (ct.construction_id = c.id)
                    LEFT JOIN construction_elements ce ON (ce.construction_type_id = ct.id )
                    WHERE construction_type_id IN (
                        SELECT ct.id FROM construction_types ct WHERE construction_id = 1
                    )
                    ORDER BY count_requests DESC LIMIT 2
                ;

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

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

SELECT
  c0_.id AS id_0
FROM
  constructions c0_

SELECT c0_.id AS id_0 FROM constructions c0_;

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;