Symfony Profiler

SELECT
  interest_field_id as id,
  count(*) as num
FROM
  company_profile_interest_field_mapping as cpifm
  LEFT JOIN company_profile as cp ON cpifm.company_profile_id = cp.id
WHERE
  cp.is_visible = 1
GROUP BY
  interest_field_id

SELECT interest_field_id as id, count(*) as num FROM company_profile_interest_field_mapping as cpifm LEFT JOIN company_profile as cp ON cpifm.company_profile_id=cp.id WHERE cp.is_visible=1 GROUP BY interest_field_id;

SELECT
  interest_field_id as id,
  count(*) as num
FROM
  school_interest_field_mapping as sifm
  LEFT JOIN school as sch ON sifm.school_id = sch.id
  LEFT JOIN school_profile as sp ON sp.school_id = sch.id
WHERE
  sp.is_visible = 1
GROUP BY
  interest_field_id

SELECT interest_field_id as id, count(*) as num FROM school_interest_field_mapping as sifm LEFT JOIN school as sch ON sifm.school_id=sch.id LEFT JOIN school_profile as sp ON sp.school_id=sch.id WHERE sp.is_visible=1 GROUP BY interest_field_id;

SELECT
  interest_field_id as id,
  count(*) as num
FROM
  job_interest_field_mapping as jifm
GROUP BY
  interest_field_id

SELECT interest_field_id as id, count(*) as num FROM job_interest_field_mapping as jifm GROUP BY interest_field_id;

SELECT
  t0.id AS id_1,
  t0.interest_name AS interest_name_2,
  t0.sub_heading AS sub_heading_3
FROM
  interest_field t0
ORDER BY
  t0.interest_name ASC

SELECT t0.id AS id_1, t0.interest_name AS interest_name_2, t0.sub_heading AS sub_heading_3 FROM interest_field t0 ORDER BY t0.interest_name ASC;