Symfony Profiler

SELECT 
  DISTINCT i0_.id_inst AS id_inst_0, 
  i0_.inst_name AS inst_name_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_.inst_name ASC 
LIMIT 
  10 OFFSET 1700

SELECT DISTINCT i0_.id_inst AS id_inst_0, i0_.inst_name AS inst_name_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_.inst_name ASC LIMIT 10 OFFSET 1700;

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 
  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_.inst_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 (24737, 18949, 18971, 10197, 15792, 14425, 21285, 22889, 15670, 12154) ORDER BY i0_.inst_name ASC;