Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3
FROM
  price_groups t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0;

SELECT
  m0_.manufacturers_id AS manufacturers_id_0,
  m0_.manufacturers_code AS manufacturers_code_1,
  m0_.manufacturers_name AS manufacturers_name_2,
  m0_.manufacturers_image AS manufacturers_image_3,
  m0_.date_added AS date_added_4,
  m0_.last_modified AS last_modified_5,
  m0_.manufacturers_statuts AS manufacturers_statuts_6,
  m0_.manufacturers_order AS manufacturers_order_7,
  m0_.manufacturers_locked_price AS manufacturers_locked_price_8,
  m0_.manufacturers_welcome AS manufacturers_welcome_9,
  m0_.manufacturers_export AS manufacturers_export_10,
  m0_.manufacturers_no_soleil AS manufacturers_no_soleil_11
FROM
  manufacturers m0_
  INNER JOIN products p1_ ON (
    p1_.manufacturers_id = m0_.manufacturers_id
  )
WHERE
  m0_.manufacturers_statuts = 1
  AND p1_.products_status = 1
  AND p1_.products_parent_id IS NULL
GROUP BY
  m0_.manufacturers_id
ORDER BY
  m0_.manufacturers_name ASC

SELECT m0_.manufacturers_id AS manufacturers_id_0, m0_.manufacturers_code AS manufacturers_code_1, m0_.manufacturers_name AS manufacturers_name_2, m0_.manufacturers_image AS manufacturers_image_3, m0_.date_added AS date_added_4, m0_.last_modified AS last_modified_5, m0_.manufacturers_statuts AS manufacturers_statuts_6, m0_.manufacturers_order AS manufacturers_order_7, m0_.manufacturers_locked_price AS manufacturers_locked_price_8, m0_.manufacturers_welcome AS manufacturers_welcome_9, m0_.manufacturers_export AS manufacturers_export_10, m0_.manufacturers_no_soleil AS manufacturers_no_soleil_11 FROM manufacturers m0_ INNER JOIN products p1_ ON (p1_.manufacturers_id = m0_.manufacturers_id) WHERE m0_.manufacturers_statuts = 1 AND p1_.products_status = 1 AND p1_.products_parent_id IS NULL GROUP BY m0_.manufacturers_id ORDER BY m0_.manufacturers_name ASC;