Symfony Profiler

SELECT 
  i0_.id AS id_0, 
  1 AS sclr_1, 
  m1_.id_ind AS id_ind_2, 
  i0_.id_ind AS id_ind_3, 
  i0_.fname AS fname_4, 
  i0_.mname AS mname_5, 
  i0_.sname AS sname_6, 
  i0_.email1 AS email1_7, 
  i0_.email2 AS email2_8, 
  CONCAT(
    '/uploads/profile/profile_', i0_.id_ind, 
    '.png'
  ) AS sclr_9, 
  CONCAT(i0_.sname, ' ', i0_.fname) AS sclr_10, 
  i0_.status AS status_11, 
  i0_.deceased AS deceased_12, 
  i0_.retired AS retired_13, 
  i0_.do_not_invite AS do_not_invite_14, 
  m1_.role AS role_15, 
  c2_.country AS country_16, 
  i0_.id_nationality AS id_nationality_17 
FROM 
  indiv i0_, 
  member_groups m1_, 
  countries c2_ 
WHERE 
  m1_.id_group = 137 
  AND m1_.id_ind = i0_.id_ind 
  AND i0_.country_code = c2_.id_country 
  AND i0_.use_inst_addr <> 1

SELECT i0_.id AS id_0, 1 AS sclr_1, m1_.id_ind AS id_ind_2, i0_.id_ind AS id_ind_3, i0_.fname AS fname_4, i0_.mname AS mname_5, i0_.sname AS sname_6, i0_.email1 AS email1_7, i0_.email2 AS email2_8, CONCAT('/uploads/profile/profile_', i0_.id_ind, '.png') AS sclr_9, CONCAT(i0_.sname, ' ', i0_.fname) AS sclr_10, i0_.status AS status_11, i0_.deceased AS deceased_12, i0_.retired AS retired_13, i0_.do_not_invite AS do_not_invite_14, m1_.role AS role_15, c2_.country AS country_16, i0_.id_nationality AS id_nationality_17 FROM indiv i0_, member_groups m1_, countries c2_ WHERE m1_.id_group = 137 AND m1_.id_ind = i0_.id_ind AND i0_.country_code = c2_.id_country AND i0_.use_inst_addr <> 1;

SELECT 
  i0_.id AS id_0, 
  1 AS sclr_1, 
  m1_.id_ind AS id_ind_2, 
  i0_.id_ind AS id_ind_3, 
  i0_.fname AS fname_4, 
  i0_.mname AS mname_5, 
  i0_.sname AS sname_6, 
  i0_.email1 AS email1_7, 
  i0_.email2 AS email2_8, 
  CONCAT(
    '/uploads/profile/profile_', i0_.id_ind, 
    '.png'
  ) AS sclr_9, 
  CONCAT(i0_.sname, ' ', i0_.fname) AS sclr_10, 
  i0_.status AS status_11, 
  i0_.deceased AS deceased_12, 
  i0_.retired AS retired_13, 
  i0_.do_not_invite AS do_not_invite_14, 
  m1_.role AS role_15, 
  c2_.country AS country_16, 
  i0_.id_nationality AS id_nationality_17 
FROM 
  indiv i0_, 
  member_groups m1_, 
  institutions i3_, 
  indiv_institution i4_, 
  countries c2_ 
WHERE 
  m1_.id_group = 137 
  AND m1_.id_ind = i0_.id_ind 
  AND i3_.country_code = c2_.id_country 
  AND i0_.use_inst_addr = 1 
  AND i4_.id_ind = i0_.id_ind 
  AND i4_.id_inst = i3_.id_inst

SELECT i0_.id AS id_0, 1 AS sclr_1, m1_.id_ind AS id_ind_2, i0_.id_ind AS id_ind_3, i0_.fname AS fname_4, i0_.mname AS mname_5, i0_.sname AS sname_6, i0_.email1 AS email1_7, i0_.email2 AS email2_8, CONCAT('/uploads/profile/profile_', i0_.id_ind, '.png') AS sclr_9, CONCAT(i0_.sname, ' ', i0_.fname) AS sclr_10, i0_.status AS status_11, i0_.deceased AS deceased_12, i0_.retired AS retired_13, i0_.do_not_invite AS do_not_invite_14, m1_.role AS role_15, c2_.country AS country_16, i0_.id_nationality AS id_nationality_17 FROM indiv i0_, member_groups m1_, institutions i3_, indiv_institution i4_, countries c2_ WHERE m1_.id_group = 137 AND m1_.id_ind = i0_.id_ind AND i3_.country_code = c2_.id_country AND i0_.use_inst_addr = 1 AND i4_.id_ind = i0_.id_ind AND i4_.id_inst = i3_.id_inst;

SELECT 
  c0_.id_country AS id_country_0, 
  c0_.country AS country_1 
FROM 
  countries c0_

SELECT c0_.id_country AS id_country_0, c0_.country AS country_1 FROM countries c0_;

SELECT 
  i0_.id_ind AS id_ind_0, 
  i1_.id_inst AS id_inst_1, 
  i1_.inst_name AS inst_name_2 
FROM 
  institutions i1_, 
  indiv_institution i0_ 
WHERE 
  i0_.id_ind IN (
    11339, 10150, 20124, 20924, 7349, 20921, 
    14599, 16740, 21097, 20535, 20537, 
    20595, 20625, 20626, 20628, 20629, 
    20993, 20887, 20897, 20954, 992, 18379, 
    20534, 20590, 20591, 20623, 20533, 
    19939, 13058, 20532, 22706, 18306, 
    20550, 21840, 8843, 15720, 20630, 21001, 
    27040, 8671, 21096, 8709, 11326, 20436, 
    20548, 66276, 23613, 11050, 19995, 
    19881
  ) 
  AND i0_.id_inst = i1_.id_inst

SELECT i0_.id_ind AS id_ind_0, i1_.id_inst AS id_inst_1, i1_.inst_name AS inst_name_2 FROM institutions i1_, indiv_institution i0_ WHERE i0_.id_ind IN (11339, 10150, 20124, 20924, 7349, 20921, 14599, 16740, 21097, 20535, 20537, 20595, 20625, 20626, 20628, 20629, 20993, 20887, 20897, 20954, 992, 18379, 20534, 20590, 20591, 20623, 20533, 19939, 13058, 20532, 22706, 18306, 20550, 21840, 8843, 15720, 20630, 21001, 27040, 8671, 21096, 8709, 11326, 20436, 20548, 66276, 23613, 11050, 19995, 19881) AND i0_.id_inst = i1_.id_inst;