Symfony Profiler

SELECT 
  i0_.id_inst AS id_inst_0, 
  i0_.parent_id AS parent_id_1, 
  i0_.inst_type_id AS inst_type_id_2, 
  i0_.inst_name AS inst_name_3, 
  i0_.inst_name_eng AS inst_name_eng_4, 
  i0_.country_code AS country_code_5, 
  c1_.country AS country_6, 
  i2_.insttype_name AS insttype_name_7 
FROM 
  institutions i0_ 
  LEFT JOIN countries c1_ ON (
    i0_.country_code = c1_.id_country
  ) 
  LEFT JOIN insttypes i2_ ON (
    i0_.inst_type_id = i2_.id_insttype
  ) 
WHERE 
  i0_.activated = 1

SELECT i0_.id_inst AS id_inst_0, i0_.parent_id AS parent_id_1, i0_.inst_type_id AS inst_type_id_2, i0_.inst_name AS inst_name_3, i0_.inst_name_eng AS inst_name_eng_4, i0_.country_code AS country_code_5, c1_.country AS country_6, i2_.insttype_name AS insttype_name_7 FROM institutions i0_ LEFT JOIN countries c1_ ON (i0_.country_code = c1_.id_country) LEFT JOIN insttypes i2_ ON (i0_.inst_type_id = i2_.id_insttype) WHERE i0_.activated = 1;

SELECT 
  count(DISTINCT i0_.id_inst) AS sclr_0 
FROM 
  institutions i0_ 
  LEFT JOIN countries c1_ ON (
    i0_.country_code = c1_.id_country
  ) 
  LEFT JOIN insttypes i2_ ON (
    i0_.inst_type_id = i2_.id_insttype
  ) 
WHERE 
  i0_.activated = 1

SELECT count(DISTINCT i0_.id_inst) AS sclr_0 FROM institutions i0_ LEFT JOIN countries c1_ ON (i0_.country_code = c1_.id_country) LEFT JOIN insttypes i2_ ON (i0_.inst_type_id = i2_.id_insttype) WHERE i0_.activated = 1;

SELECT 
  DISTINCT i0_.id_inst AS id_inst_0, 
  i0_.id_inst AS id_inst_1 
FROM 
  institutions i0_ 
  LEFT JOIN countries c1_ ON (
    i0_.country_code = c1_.id_country
  ) 
  LEFT JOIN insttypes i2_ ON (
    i0_.inst_type_id = i2_.id_insttype
  ) 
WHERE 
  i0_.activated = 1 
ORDER BY 
  i0_.id_inst ASC 
LIMIT 
  10 OFFSET 2760

SELECT DISTINCT i0_.id_inst AS id_inst_0, i0_.id_inst AS id_inst_1 FROM institutions i0_ LEFT JOIN countries c1_ ON (i0_.country_code = c1_.id_country) LEFT JOIN insttypes i2_ ON (i0_.inst_type_id = i2_.id_insttype) WHERE i0_.activated = 1 ORDER BY i0_.id_inst ASC LIMIT 10 OFFSET 2760;

SELECT 
  i0_.id_inst AS id_inst_0, 
  i0_.parent_id AS parent_id_1, 
  i0_.inst_type_id AS inst_type_id_2, 
  i0_.inst_name AS inst_name_3, 
  i0_.inst_name_eng AS inst_name_eng_4, 
  i0_.country_code AS country_code_5, 
  c1_.country AS country_6, 
  i2_.insttype_name AS insttype_name_7 
FROM 
  institutions i0_ 
  LEFT JOIN countries c1_ ON (
    i0_.country_code = c1_.id_country
  ) 
  LEFT JOIN insttypes i2_ ON (
    i0_.inst_type_id = i2_.id_insttype
  ) 
WHERE 
  i0_.activated = 1 
  AND i0_.id_inst IN (?) 
ORDER BY 
  i0_.id_inst ASC

SELECT i0_.id_inst AS id_inst_0, i0_.parent_id AS parent_id_1, i0_.inst_type_id AS inst_type_id_2, i0_.inst_name AS inst_name_3, i0_.inst_name_eng AS inst_name_eng_4, i0_.country_code AS country_code_5, c1_.country AS country_6, i2_.insttype_name AS insttype_name_7 FROM institutions i0_ LEFT JOIN countries c1_ ON (i0_.country_code = c1_.id_country) LEFT JOIN insttypes i2_ ON (i0_.inst_type_id = i2_.id_insttype) WHERE i0_.activated = 1 AND i0_.id_inst IN (15879, 15880, 15882, 15884, 15885, 15886, 15887, 15888, 15889, 15890) ORDER BY i0_.id_inst ASC;