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 
  DISTINCT i0_.id_inst AS id_inst_0, 
  i1_.insttype_name AS insttype_name_1 
FROM 
  institutions i0_ 
  LEFT JOIN countries c2_ ON (
    i0_.country_code = c2_.id_country
  ) 
  LEFT JOIN insttypes i1_ ON (
    i0_.inst_type_id = i1_.id_insttype
  ) 
WHERE 
  i0_.activated = 1 
ORDER BY 
  i1_.insttype_name ASC 
LIMIT 
  10 OFFSET 230

SELECT DISTINCT i0_.id_inst AS id_inst_0, i1_.insttype_name AS insttype_name_1 FROM institutions i0_ LEFT JOIN countries c2_ ON (i0_.country_code = c2_.id_country) LEFT JOIN insttypes i1_ ON (i0_.inst_type_id = i1_.id_insttype) WHERE i0_.activated = 1 ORDER BY i1_.insttype_name ASC LIMIT 10 OFFSET 230;

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 
  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 
  i2_.insttype_name 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 (22530, 13153, 24850, 12535, 12010, 21268, 21584, 6360, 25204, 14399) ORDER BY i2_.insttype_name ASC;