Symfony Profiler

SELECT
  r0_.id AS id_0,
  r0_.reporter AS reporter_1,
  r0_.partner AS partner_2,
  r0_.trade_flow AS trade_flow_3,
  r0_.commodity_code AS commodity_code_4
FROM
  reporter_partner r0_
GROUP BY
  r0_.reporter
ORDER BY
  r0_.reporter ASC

SELECT r0_.id AS id_0, r0_.reporter AS reporter_1, r0_.partner AS partner_2, r0_.trade_flow AS trade_flow_3, r0_.commodity_code AS commodity_code_4 FROM reporter_partner r0_ GROUP BY r0_.reporter ORDER BY r0_.reporter ASC;

SELECT
  r0_.id AS id_0,
  r0_.reporter AS reporter_1,
  r0_.partner AS partner_2,
  r0_.trade_flow AS trade_flow_3,
  r0_.commodity_code AS commodity_code_4
FROM
  reporter_partner r0_
GROUP BY
  r0_.partner
ORDER BY
  r0_.partner ASC

SELECT r0_.id AS id_0, r0_.reporter AS reporter_1, r0_.partner AS partner_2, r0_.trade_flow AS trade_flow_3, r0_.commodity_code AS commodity_code_4 FROM reporter_partner r0_ GROUP BY r0_.partner ORDER BY r0_.partner ASC;

SELECT
  r0_.id AS id_0,
  r0_.reporter AS reporter_1,
  r0_.partner AS partner_2,
  r0_.trade_flow AS trade_flow_3,
  r0_.commodity_code AS commodity_code_4,
  p1_.id AS id_5,
  p1_.year AS year_6,
  p1_.month AS month_7,
  p1_.value AS value_8,
  p1_.period_date AS period_date_9,
  p1_.reporter_partner_id AS reporter_partner_id_10
FROM
  reporter_partner r0_
  INNER JOIN period p1_ ON r0_.id = p1_.reporter_partner_id
WHERE
  r0_.reporter = ?
  AND r0_.partner = ?
  AND r0_.trade_flow IN (?, ?, ?)
  AND p1_.month IS NOT NULL
  AND p1_.period_date >= ?
  AND p1_.period_date <= ?
ORDER BY
  r0_.commodity_code ASC

SELECT r0_.id AS id_0, r0_.reporter AS reporter_1, r0_.partner AS partner_2, r0_.trade_flow AS trade_flow_3, r0_.commodity_code AS commodity_code_4, p1_.id AS id_5, p1_.year AS year_6, p1_.month AS month_7, p1_.value AS value_8, p1_.period_date AS period_date_9, p1_.reporter_partner_id AS reporter_partner_id_10 FROM reporter_partner r0_ INNER JOIN period p1_ ON r0_.id = p1_.reporter_partner_id WHERE r0_.reporter = 'China' AND r0_.partner = 'USA' AND r0_.trade_flow IN ('Exports', 'Imports', 'Net Trade') AND p1_.month IS NOT NULL AND p1_.period_date >= '2020-01-25 10:32:35' AND p1_.period_date <= '2020-12-25 10:32:35' ORDER BY r0_.commodity_code ASC;