Symfony Profiler

SELECT
  t0.country AS country_1,
  t0.postcode_pos AS postcode_pos_2,
  t0.postcode_spacer AS postcode_spacer_3,
  t0.country_code AS country_code_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.unesco_member AS unesco_member_7,
  t0.ioc_member AS ioc_member_8,
  t0.is_executive AS is_executive_9,
  t0.id_country AS id_country_10
FROM
  countries t0

SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.unesco_member AS unesco_member_7, t0.ioc_member AS ioc_member_8, t0.is_executive AS is_executive_9, t0.id_country AS id_country_10 FROM countries t0;

SELECT
  count(i0_.id_ind) AS sclr_0
FROM
  indiv i0_
WHERE
  i0_.status = 1
  AND i0_.deceased <> 1

SELECT count(i0_.id_ind) AS sclr_0 FROM indiv i0_ WHERE i0_.status = 1 AND i0_.deceased <> 1;

SELECT
  t0.country AS country_1,
  t0.postcode_pos AS postcode_pos_2,
  t0.postcode_spacer AS postcode_spacer_3,
  t0.country_code AS country_code_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.unesco_member AS unesco_member_7,
  t0.ioc_member AS ioc_member_8,
  t0.is_executive AS is_executive_9,
  t0.id_country AS id_country_10
FROM
  countries t0

SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.unesco_member AS unesco_member_7, t0.ioc_member AS ioc_member_8, t0.is_executive AS is_executive_9, t0.id_country AS id_country_10 FROM countries t0;

SELECT
  count('i.idInd') AS sclr_0,
  c0_.country AS country_1
FROM
  indiv i1_
  LEFT JOIN countries c0_ ON (
    i1_.country_code = c0_.id_country
  )
WHERE
  i1_.status = 1
  AND i1_.deceased <> 1
  AND i1_.use_inst_addr <> 1
  AND c0_.id_country IS NOT NULL
GROUP BY
  i1_.country_code

SELECT count('i.idInd') AS sclr_0, c0_.country AS country_1 FROM indiv i1_ LEFT JOIN countries c0_ ON (i1_.country_code = c0_.id_country) WHERE i1_.status = 1 AND i1_.deceased <> 1 AND i1_.use_inst_addr <> 1 AND c0_.id_country IS NOT NULL GROUP BY i1_.country_code;

SELECT
  count('i.idInd') AS sclr_0,
  c0_.country AS country_1
FROM
  indiv i1_
  LEFT JOIN indiv_institution i2_ ON (i1_.id_ind = i2_.id_ind)
  LEFT JOIN institutions i3_ ON (i2_.id_inst = i3_.id_inst)
  LEFT JOIN countries c0_ ON (
    i3_.country_code = c0_.id_country
  )
WHERE
  i1_.status = 1
  AND i1_.deceased <> 1
  AND i1_.use_inst_addr = 1
  AND c0_.id_country IS NOT NULL
GROUP BY
  i3_.country_code

SELECT count('i.idInd') AS sclr_0, c0_.country AS country_1 FROM indiv i1_ LEFT JOIN indiv_institution i2_ ON (i1_.id_ind = i2_.id_ind) LEFT JOIN institutions i3_ ON (i2_.id_inst = i3_.id_inst) LEFT JOIN countries c0_ ON (i3_.country_code = c0_.id_country) WHERE i1_.status = 1 AND i1_.deceased <> 1 AND i1_.use_inst_addr = 1 AND c0_.id_country IS NOT NULL GROUP BY i3_.country_code;

SELECT
  t0.country AS country_1,
  t0.postcode_pos AS postcode_pos_2,
  t0.postcode_spacer AS postcode_spacer_3,
  t0.country_code AS country_code_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.unesco_member AS unesco_member_7,
  t0.ioc_member AS ioc_member_8,
  t0.is_executive AS is_executive_9,
  t0.id_country AS id_country_10
FROM
  countries t0

SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.unesco_member AS unesco_member_7, t0.ioc_member AS ioc_member_8, t0.is_executive AS is_executive_9, t0.id_country AS id_country_10 FROM countries t0;

SELECT
  count('i.idInd') AS sclr_0,
  c0_.country AS country_1,
  i1_.gender AS gender_2
FROM
  indiv i1_
  LEFT JOIN countries c0_ ON (
    i1_.country_code = c0_.id_country
  )
WHERE
  i1_.status = 1
  AND i1_.deceased <> 1
  AND i1_.use_inst_addr <> 1
  AND c0_.id_country IS NOT NULL
GROUP BY
  i1_.country_code,
  i1_.gender

SELECT count('i.idInd') AS sclr_0, c0_.country AS country_1, i1_.gender AS gender_2 FROM indiv i1_ LEFT JOIN countries c0_ ON (i1_.country_code = c0_.id_country) WHERE i1_.status = 1 AND i1_.deceased <> 1 AND i1_.use_inst_addr <> 1 AND c0_.id_country IS NOT NULL GROUP BY i1_.country_code, i1_.gender;

SELECT
  count('i.idInd') AS sclr_0,
  c0_.country AS country_1,
  i1_.gender AS gender_2
FROM
  indiv i1_
  LEFT JOIN indiv_institution i2_ ON (i1_.id_ind = i2_.id_ind)
  LEFT JOIN institutions i3_ ON (i2_.id_inst = i3_.id_inst)
  LEFT JOIN countries c0_ ON (
    i3_.country_code = c0_.id_country
  )
WHERE
  i1_.status = 1
  AND i1_.deceased <> 1
  AND i1_.use_inst_addr = 1
  AND c0_.id_country IS NOT NULL
GROUP BY
  i3_.country_code,
  i1_.gender

SELECT count('i.idInd') AS sclr_0, c0_.country AS country_1, i1_.gender AS gender_2 FROM indiv i1_ LEFT JOIN indiv_institution i2_ ON (i1_.id_ind = i2_.id_ind) LEFT JOIN institutions i3_ ON (i2_.id_inst = i3_.id_inst) LEFT JOIN countries c0_ ON (i3_.country_code = c0_.id_country) WHERE i1_.status = 1 AND i1_.deceased <> 1 AND i1_.use_inst_addr = 1 AND c0_.id_country IS NOT NULL GROUP BY i3_.country_code, i1_.gender;

SELECT
  count(i0_.id_inst) AS sclr_0
FROM
  institutions i0_
WHERE
  i0_.activated = 1

SELECT count(i0_.id_inst) AS sclr_0 FROM institutions i0_ WHERE i0_.activated = 1;

SELECT
  count(e0_.id_event) AS sclr_0
FROM
  events e0_
WHERE
  e0_.status = 1

SELECT count(e0_.id_event) AS sclr_0 FROM events e0_ WHERE e0_.status = 1;

SELECT
  count(d0_.id_doc) AS sclr_0
FROM
  documents d0_
WHERE
  d0_.approved = 1

SELECT count(d0_.id_doc) AS sclr_0 FROM documents d0_ WHERE d0_.approved = 1;

SELECT
  g0_.id_group AS id_group_0,
  g0_.groupname AS groupname_1,
  g0_.description AS description_2
FROM
groups
  g0_
WHERE
  g0_.has_site = 1
ORDER BY
  g0_.groupname ASC

SELECT g0_.id_group AS id_group_0, g0_.groupname AS groupname_1, g0_.description AS description_2 FROM groups g0_ WHERE g0_.has_site = 1 ORDER BY g0_.groupname ASC;