Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.domain AS domain_1,
  s0_.locale AS locale_2,
  s0_.map_locale AS map_locale_3,
  s0_.map_provider AS map_provider_4,
  s0_.map_key AS map_key_5,
  s0_.currency AS currency_6,
  s0_.google_analytics_id AS google_analytics_id_7,
  s0_.latitude AS latitude_8,
  s0_.longitude AS longitude_9,
  s0_.booking_aid AS booking_aid_10,
  s0_.hotel_link AS hotel_link_11,
  s0_.hotel_partner AS hotel_partner_12,
  s0_.rentacar_link AS rentacar_link_13,
  s0_.rome2rio_domain AS rome2rio_domain_14,
  c1_.id AS id_15,
  c1_.title AS title_16,
  c1_.latitude AS latitude_17,
  c1_.longitude AS longitude_18,
  c1_.locale AS locale_19,
  s0_.site_country_id AS site_country_id_20,
  c1_.continentId AS continentId_21
FROM
  site s0_
  LEFT JOIN country c1_ ON s0_.site_country_id = c1_.id
ORDER BY
  s0_.id ASC
LIMIT
  30

SELECT s0_.id AS id_0, s0_.domain AS domain_1, s0_.locale AS locale_2, s0_.map_locale AS map_locale_3, s0_.map_provider AS map_provider_4, s0_.map_key AS map_key_5, s0_.currency AS currency_6, s0_.google_analytics_id AS google_analytics_id_7, s0_.latitude AS latitude_8, s0_.longitude AS longitude_9, s0_.booking_aid AS booking_aid_10, s0_.hotel_link AS hotel_link_11, s0_.hotel_partner AS hotel_partner_12, s0_.rentacar_link AS rentacar_link_13, s0_.rome2rio_domain AS rome2rio_domain_14, c1_.id AS id_15, c1_.title AS title_16, c1_.latitude AS latitude_17, c1_.longitude AS longitude_18, c1_.locale AS locale_19, s0_.site_country_id AS site_country_id_20, c1_.continentId AS continentId_21 FROM site s0_ LEFT JOIN country c1_ ON s0_.site_country_id = c1_.id ORDER BY s0_.id ASC LIMIT 30;

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  site s0_
  LEFT JOIN country c1_ ON s0_.site_country_id = c1_.id

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM site s0_ LEFT JOIN country c1_ ON s0_.site_country_id = c1_.id;