Symfony Profiler

SELECT 
  t0.username AS username_1, 
  t0.username_canonical AS username_canonical_2, 
  t0.email AS email_3, 
  t0.email_canonical AS email_canonical_4, 
  t0.enabled AS enabled_5, 
  t0.salt AS salt_6, 
  t0.password AS password_7, 
  t0.last_login AS last_login_8, 
  t0.confirmation_token AS confirmation_token_9, 
  t0.password_requested_at AS password_requested_at_10, 
  t0.roles AS roles_11, 
  t0.id AS id_12 
FROM 
  fos_user t0 
WHERE 
  t0.username_canonical = ? 
LIMIT 
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12 FROM fos_user t0 WHERE t0.username_canonical = 'ahmedinal' LIMIT 1;

SELECT 
  i0_.id_ind AS id_ind_0, 
  i0_.title AS title_1, 
  i0_.fname AS fname_2, 
  i0_.mname AS mname_3, 
  i0_.sname AS sname_4, 
  i0_.identifier AS identifier_5, 
  i0_.reg_type AS reg_type_6, 
  i0_.use_inst_addr AS use_inst_addr_7, 
  i0_.private_address AS private_address_8, 
  i0_.addr_1 AS addr_1_9, 
  i0_.addr_2 AS addr_2_10, 
  i0_.city AS city_11, 
  i0_.state AS state_12, 
  i0_.postcode AS postcode_13, 
  i0_.country_code AS country_code_14, 
  i0_.id_nationality AS id_nationality_15, 
  i0_.gender AS gender_16, 
  i0_.tel AS tel_17, 
  i0_.fax AS fax_18, 
  i0_.email1 AS email1_19, 
  i0_.email2 AS email2_20, 
  i0_.email3 AS email3_21, 
  i0_.emailtouse AS emailtouse_22, 
  i0_.url1 AS url1_23, 
  i0_.url1Valid AS url1Valid_24, 
  i0_.url2 AS url2_25, 
  i0_.url2Valid AS url2Valid_26, 
  i0_.url3 AS url3_27, 
  i0_.url3Valid AS url3Valid_28, 
  i0_.urlsChecked AS urlsChecked_29, 
  i0_.linkedin AS linkedin_30, 
  i0_.facebook AS facebook_31, 
  i0_.twitter AS twitter_32, 
  i0_.flickr AS flickr_33, 
  i0_.other AS other_34, 
  i0_.degree AS degree_35, 
  i0_.activeng AS activeng_36, 
  i0_.activother AS activother_37, 
  i0_.jobtitle AS jobtitle_38, 
  i0_.dept AS dept_39, 
  i0_.studyregion AS studyregion_40, 
  i0_.languages AS languages_41, 
  i0_.skills AS skills_42, 
  i0_.comments AS comments_43, 
  i0_.do_not_invite AS do_not_invite_44, 
  i0_.do_no_invite_by AS do_no_invite_by_45, 
  i0_.do_no_invite_on AS do_no_invite_on_46, 
  i0_.admin_comments AS admin_comments_47, 
  i0_.id_imagefile AS id_imagefile_48, 
  i0_.id_imagefile_full AS id_imagefile_full_49, 
  i0_.receive_mail AS receive_mail_50, 
  i0_.member_alert AS member_alert_51, 
  i0_.cit_alert AS cit_alert_52, 
  i0_.f_date_ent AS f_date_ent_53, 
  i0_.l_date_upd AS l_date_upd_54, 
  i0_.created_by AS created_by_55, 
  i0_.last_edit_by AS last_edit_by_56, 
  i0_.quality_checked_by AS quality_checked_by_57, 
  i0_.quality_checked_date AS quality_checked_date_58, 
  i0_.quality_checked AS quality_checked_59, 
  i0_.is_global AS is_global_60, 
  i0_.status AS status_61, 
  i0_.statusLastChanged AS statusLastChanged_62, 
  i0_.deceased AS deceased_63, 
  i0_.deceased_date AS deceased_date_64, 
  i0_.retired AS retired_65, 
  i0_.retired_date AS retired_date_66, 
  i0_.id AS id_67, 
  p1_.id AS id_68, 
  p1_.id_ind AS id_ind_69, 
  p1_.name AS name_70, 
  p1_.path AS path_71, 
  i2_.parent_id AS parent_id_72, 
  i2_.inst_type_id AS inst_type_id_73, 
  i2_.inst_name AS inst_name_74, 
  i2_.inst_name_eng AS inst_name_eng_75, 
  i2_.inst_address AS inst_address_76, 
  i2_.addr_2 AS addr_2_77, 
  i2_.city AS city_78, 
  i2_.state AS state_79, 
  i2_.postcode AS postcode_80, 
  i2_.country_code AS country_code_81, 
  i2_.acronym AS acronym_82, 
  i2_.inst_tel AS inst_tel_83, 
  i2_.inst_fax AS inst_fax_84, 
  i2_.inst_email AS inst_email_85, 
  i2_.inst_url AS inst_url_86, 
  i2_.inst_logo AS inst_logo_87, 
  i2_.edmo_code AS edmo_code_88, 
  i2_.activities AS activities_89, 
  i2_.inst_region AS inst_region_90, 
  i2_.popularity AS popularity_91, 
  i2_.activated AS activated_92, 
  i2_.f_date_entered AS f_date_entered_93, 
  i2_.l_date_updated AS l_date_updated_94, 
  i2_.created_by AS created_by_95, 
  i2_.last_edit_by AS last_edit_by_96, 
  i2_.id_inst AS id_inst_97 
FROM 
  indiv i0_ 
  LEFT JOIN profile_images p1_ ON (p1_.id_ind = i0_.id_ind) 
  LEFT JOIN indiv_institution i3_ ON (i0_.id_ind = i3_.id_ind) 
  LEFT JOIN institutions i2_ ON (i3_.id_inst = i2_.id_inst) 
WHERE 
  i0_.id_ind = ? 
  AND i0_.status = 1

SELECT i0_.id_ind AS id_ind_0, i0_.title AS title_1, i0_.fname AS fname_2, i0_.mname AS mname_3, i0_.sname AS sname_4, i0_.identifier AS identifier_5, i0_.reg_type AS reg_type_6, i0_.use_inst_addr AS use_inst_addr_7, i0_.private_address AS private_address_8, i0_.addr_1 AS addr_1_9, i0_.addr_2 AS addr_2_10, i0_.city AS city_11, i0_.state AS state_12, i0_.postcode AS postcode_13, i0_.country_code AS country_code_14, i0_.id_nationality AS id_nationality_15, i0_.gender AS gender_16, i0_.tel AS tel_17, i0_.fax AS fax_18, i0_.email1 AS email1_19, i0_.email2 AS email2_20, i0_.email3 AS email3_21, i0_.emailtouse AS emailtouse_22, i0_.url1 AS url1_23, i0_.url1Valid AS url1Valid_24, i0_.url2 AS url2_25, i0_.url2Valid AS url2Valid_26, i0_.url3 AS url3_27, i0_.url3Valid AS url3Valid_28, i0_.urlsChecked AS urlsChecked_29, i0_.linkedin AS linkedin_30, i0_.facebook AS facebook_31, i0_.twitter AS twitter_32, i0_.flickr AS flickr_33, i0_.other AS other_34, i0_.degree AS degree_35, i0_.activeng AS activeng_36, i0_.activother AS activother_37, i0_.jobtitle AS jobtitle_38, i0_.dept AS dept_39, i0_.studyregion AS studyregion_40, i0_.languages AS languages_41, i0_.skills AS skills_42, i0_.comments AS comments_43, i0_.do_not_invite AS do_not_invite_44, i0_.do_no_invite_by AS do_no_invite_by_45, i0_.do_no_invite_on AS do_no_invite_on_46, i0_.admin_comments AS admin_comments_47, i0_.id_imagefile AS id_imagefile_48, i0_.id_imagefile_full AS id_imagefile_full_49, i0_.receive_mail AS receive_mail_50, i0_.member_alert AS member_alert_51, i0_.cit_alert AS cit_alert_52, i0_.f_date_ent AS f_date_ent_53, i0_.l_date_upd AS l_date_upd_54, i0_.created_by AS created_by_55, i0_.last_edit_by AS last_edit_by_56, i0_.quality_checked_by AS quality_checked_by_57, i0_.quality_checked_date AS quality_checked_date_58, i0_.quality_checked AS quality_checked_59, i0_.is_global AS is_global_60, i0_.status AS status_61, i0_.statusLastChanged AS statusLastChanged_62, i0_.deceased AS deceased_63, i0_.deceased_date AS deceased_date_64, i0_.retired AS retired_65, i0_.retired_date AS retired_date_66, i0_.id AS id_67, p1_.id AS id_68, p1_.id_ind AS id_ind_69, p1_.name AS name_70, p1_.path AS path_71, i2_.parent_id AS parent_id_72, i2_.inst_type_id AS inst_type_id_73, i2_.inst_name AS inst_name_74, i2_.inst_name_eng AS inst_name_eng_75, i2_.inst_address AS inst_address_76, i2_.addr_2 AS addr_2_77, i2_.city AS city_78, i2_.state AS state_79, i2_.postcode AS postcode_80, i2_.country_code AS country_code_81, i2_.acronym AS acronym_82, i2_.inst_tel AS inst_tel_83, i2_.inst_fax AS inst_fax_84, i2_.inst_email AS inst_email_85, i2_.inst_url AS inst_url_86, i2_.inst_logo AS inst_logo_87, i2_.edmo_code AS edmo_code_88, i2_.activities AS activities_89, i2_.inst_region AS inst_region_90, i2_.popularity AS popularity_91, i2_.activated AS activated_92, i2_.f_date_entered AS f_date_entered_93, i2_.l_date_updated AS l_date_updated_94, i2_.created_by AS created_by_95, i2_.last_edit_by AS last_edit_by_96, i2_.id_inst AS id_inst_97 FROM indiv i0_ LEFT JOIN profile_images p1_ ON (p1_.id_ind = i0_.id_ind) LEFT JOIN indiv_institution i3_ ON (i0_.id_ind = i3_.id_ind) LEFT JOIN institutions i2_ ON (i3_.id_inst = i2_.id_inst) WHERE i0_.id_ind = 27003 AND i0_.status = 1;

SELECT 
  i0_.meta_option AS meta_option_0, 
  i0_.meta_value AS meta_value_1 
FROM 
  indiv_meta i0_ 
WHERE 
  i0_.indiv_id = ?

SELECT i0_.meta_option AS meta_option_0, i0_.meta_value AS meta_value_1 FROM indiv_meta i0_ WHERE i0_.indiv_id = 27003;

SELECT 
  j0_.jobname AS jobname_0, 
  j0_.id_job AS id_job_1 
FROM 
  indiv_jobtype i1_ 
  LEFT JOIN jobtypes j0_ ON (j0_.id_job = i1_.id_job) 
WHERE 
  i1_.id_ind = ?

SELECT j0_.jobname AS jobname_0, j0_.id_job AS id_job_1 FROM indiv_jobtype i1_ LEFT JOIN jobtypes j0_ ON (j0_.id_job = i1_.id_job) WHERE i1_.id_ind = 27003;

SELECT 
  g0_.groupname AS groupname_0, 
  g0_.id_group AS id_group_1 
FROM 
  member_groups m1_ 
  LEFT JOIN groups g0_ ON (m1_.id_group = g0_.id_group) 
WHERE 
  m1_.id_ind = ? 
ORDER BY 
  g0_.groupname ASC

SELECT g0_.groupname AS groupname_0, g0_.id_group AS id_group_1 FROM member_groups m1_ LEFT JOIN groups g0_ ON (m1_.id_group = g0_.id_group) WHERE m1_.id_ind = 27003 ORDER BY g0_.groupname ASC;

SELECT 
  i0_.meta_option AS meta_option_0, 
  i0_.meta_value AS meta_value_1 
FROM 
  indiv_meta i0_ 
WHERE 
  i0_.indiv_id = ?

SELECT i0_.meta_option AS meta_option_0, i0_.meta_value AS meta_value_1 FROM indiv_meta i0_ WHERE i0_.indiv_id = 27003;

SELECT 
  c0_.country AS country_0 
FROM 
  countries c0_ 
WHERE 
  c0_.id_country IN (?)

SELECT c0_.country AS country_0 FROM countries c0_ WHERE c0_.id_country IN ('3');

SELECT 
  j0_.jobname AS jobname_0 
FROM 
  jobtypes j0_ 
WHERE 
  j0_.id_job IN (?)

SELECT j0_.jobname AS jobname_0 FROM jobtypes j0_ WHERE j0_.id_job IN ('Scientist researcher');

SELECT 
  t0.id_ind AS id_ind_1, 
  t0.title AS title_2, 
  t0.fname AS fname_3, 
  t0.mname AS mname_4, 
  t0.sname AS sname_5, 
  t0.identifier AS identifier_6, 
  t0.reg_type AS reg_type_7, 
  t0.use_inst_addr AS use_inst_addr_8, 
  t0.private_address AS private_address_9, 
  t0.addr_1 AS addr_1_10, 
  t0.addr_2 AS addr_2_11, 
  t0.city AS city_12, 
  t0.state AS state_13, 
  t0.postcode AS postcode_14, 
  t0.country_code AS country_code_15, 
  t0.id_nationality AS id_nationality_16, 
  t0.gender AS gender_17, 
  t0.tel AS tel_18, 
  t0.fax AS fax_19, 
  t0.email1 AS email1_20, 
  t0.email2 AS email2_21, 
  t0.email3 AS email3_22, 
  t0.emailtouse AS emailtouse_23, 
  t0.url1 AS url1_24, 
  t0.url1Valid AS url1Valid_25, 
  t0.url2 AS url2_26, 
  t0.url2Valid AS url2Valid_27, 
  t0.url3 AS url3_28, 
  t0.url3Valid AS url3Valid_29, 
  t0.urlsChecked AS urlsChecked_30, 
  t0.linkedin AS linkedin_31, 
  t0.facebook AS facebook_32, 
  t0.twitter AS twitter_33, 
  t0.flickr AS flickr_34, 
  t0.other AS other_35, 
  t0.degree AS degree_36, 
  t0.activeng AS activeng_37, 
  t0.activother AS activother_38, 
  t0.jobtitle AS jobtitle_39, 
  t0.dept AS dept_40, 
  t0.studyregion AS studyregion_41, 
  t0.languages AS languages_42, 
  t0.skills AS skills_43, 
  t0.comments AS comments_44, 
  t0.do_not_invite AS do_not_invite_45, 
  t0.do_no_invite_by AS do_no_invite_by_46, 
  t0.do_no_invite_on AS do_no_invite_on_47, 
  t0.admin_comments AS admin_comments_48, 
  t0.id_imagefile AS id_imagefile_49, 
  t0.id_imagefile_full AS id_imagefile_full_50, 
  t0.receive_mail AS receive_mail_51, 
  t0.member_alert AS member_alert_52, 
  t0.cit_alert AS cit_alert_53, 
  t0.f_date_ent AS f_date_ent_54, 
  t0.l_date_upd AS l_date_upd_55, 
  t0.created_by AS created_by_56, 
  t0.last_edit_by AS last_edit_by_57, 
  t0.quality_checked_by AS quality_checked_by_58, 
  t0.quality_checked_date AS quality_checked_date_59, 
  t0.quality_checked AS quality_checked_60, 
  t0.is_global AS is_global_61, 
  t0.status AS status_62, 
  t0.statusLastChanged AS statusLastChanged_63, 
  t0.deceased AS deceased_64, 
  t0.deceased_date AS deceased_date_65, 
  t0.retired AS retired_66, 
  t0.retired_date AS retired_date_67, 
  t0.id AS id_68 
FROM 
  indiv t0 
WHERE 
  t0.id_ind = ? 
LIMIT 
  1

SELECT t0.id_ind AS id_ind_1, t0.title AS title_2, t0.fname AS fname_3, t0.mname AS mname_4, t0.sname AS sname_5, t0.identifier AS identifier_6, t0.reg_type AS reg_type_7, t0.use_inst_addr AS use_inst_addr_8, t0.private_address AS private_address_9, t0.addr_1 AS addr_1_10, t0.addr_2 AS addr_2_11, t0.city AS city_12, t0.state AS state_13, t0.postcode AS postcode_14, t0.country_code AS country_code_15, t0.id_nationality AS id_nationality_16, t0.gender AS gender_17, t0.tel AS tel_18, t0.fax AS fax_19, t0.email1 AS email1_20, t0.email2 AS email2_21, t0.email3 AS email3_22, t0.emailtouse AS emailtouse_23, t0.url1 AS url1_24, t0.url1Valid AS url1Valid_25, t0.url2 AS url2_26, t0.url2Valid AS url2Valid_27, t0.url3 AS url3_28, t0.url3Valid AS url3Valid_29, t0.urlsChecked AS urlsChecked_30, t0.linkedin AS linkedin_31, t0.facebook AS facebook_32, t0.twitter AS twitter_33, t0.flickr AS flickr_34, t0.other AS other_35, t0.degree AS degree_36, t0.activeng AS activeng_37, t0.activother AS activother_38, t0.jobtitle AS jobtitle_39, t0.dept AS dept_40, t0.studyregion AS studyregion_41, t0.languages AS languages_42, t0.skills AS skills_43, t0.comments AS comments_44, t0.do_not_invite AS do_not_invite_45, t0.do_no_invite_by AS do_no_invite_by_46, t0.do_no_invite_on AS do_no_invite_on_47, t0.admin_comments AS admin_comments_48, t0.id_imagefile AS id_imagefile_49, t0.id_imagefile_full AS id_imagefile_full_50, t0.receive_mail AS receive_mail_51, t0.member_alert AS member_alert_52, t0.cit_alert AS cit_alert_53, t0.f_date_ent AS f_date_ent_54, t0.l_date_upd AS l_date_upd_55, t0.created_by AS created_by_56, t0.last_edit_by AS last_edit_by_57, t0.quality_checked_by AS quality_checked_by_58, t0.quality_checked_date AS quality_checked_date_59, t0.quality_checked AS quality_checked_60, t0.is_global AS is_global_61, t0.status AS status_62, t0.statusLastChanged AS statusLastChanged_63, t0.deceased AS deceased_64, t0.deceased_date AS deceased_date_65, t0.retired AS retired_66, t0.retired_date AS retired_date_67, t0.id AS id_68 FROM indiv t0 WHERE t0.id_ind = 31183 LIMIT 1;

SELECT 
  t0.id_ind AS id_ind_1, 
  t0.title AS title_2, 
  t0.fname AS fname_3, 
  t0.mname AS mname_4, 
  t0.sname AS sname_5, 
  t0.identifier AS identifier_6, 
  t0.reg_type AS reg_type_7, 
  t0.use_inst_addr AS use_inst_addr_8, 
  t0.private_address AS private_address_9, 
  t0.addr_1 AS addr_1_10, 
  t0.addr_2 AS addr_2_11, 
  t0.city AS city_12, 
  t0.state AS state_13, 
  t0.postcode AS postcode_14, 
  t0.country_code AS country_code_15, 
  t0.id_nationality AS id_nationality_16, 
  t0.gender AS gender_17, 
  t0.tel AS tel_18, 
  t0.fax AS fax_19, 
  t0.email1 AS email1_20, 
  t0.email2 AS email2_21, 
  t0.email3 AS email3_22, 
  t0.emailtouse AS emailtouse_23, 
  t0.url1 AS url1_24, 
  t0.url1Valid AS url1Valid_25, 
  t0.url2 AS url2_26, 
  t0.url2Valid AS url2Valid_27, 
  t0.url3 AS url3_28, 
  t0.url3Valid AS url3Valid_29, 
  t0.urlsChecked AS urlsChecked_30, 
  t0.linkedin AS linkedin_31, 
  t0.facebook AS facebook_32, 
  t0.twitter AS twitter_33, 
  t0.flickr AS flickr_34, 
  t0.other AS other_35, 
  t0.degree AS degree_36, 
  t0.activeng AS activeng_37, 
  t0.activother AS activother_38, 
  t0.jobtitle AS jobtitle_39, 
  t0.dept AS dept_40, 
  t0.studyregion AS studyregion_41, 
  t0.languages AS languages_42, 
  t0.skills AS skills_43, 
  t0.comments AS comments_44, 
  t0.do_not_invite AS do_not_invite_45, 
  t0.do_no_invite_by AS do_no_invite_by_46, 
  t0.do_no_invite_on AS do_no_invite_on_47, 
  t0.admin_comments AS admin_comments_48, 
  t0.id_imagefile AS id_imagefile_49, 
  t0.id_imagefile_full AS id_imagefile_full_50, 
  t0.receive_mail AS receive_mail_51, 
  t0.member_alert AS member_alert_52, 
  t0.cit_alert AS cit_alert_53, 
  t0.f_date_ent AS f_date_ent_54, 
  t0.l_date_upd AS l_date_upd_55, 
  t0.created_by AS created_by_56, 
  t0.last_edit_by AS last_edit_by_57, 
  t0.quality_checked_by AS quality_checked_by_58, 
  t0.quality_checked_date AS quality_checked_date_59, 
  t0.quality_checked AS quality_checked_60, 
  t0.is_global AS is_global_61, 
  t0.status AS status_62, 
  t0.statusLastChanged AS statusLastChanged_63, 
  t0.deceased AS deceased_64, 
  t0.deceased_date AS deceased_date_65, 
  t0.retired AS retired_66, 
  t0.retired_date AS retired_date_67, 
  t0.id AS id_68 
FROM 
  indiv t0 
WHERE 
  t0.id_ind = ? 
LIMIT 
  1

SELECT t0.id_ind AS id_ind_1, t0.title AS title_2, t0.fname AS fname_3, t0.mname AS mname_4, t0.sname AS sname_5, t0.identifier AS identifier_6, t0.reg_type AS reg_type_7, t0.use_inst_addr AS use_inst_addr_8, t0.private_address AS private_address_9, t0.addr_1 AS addr_1_10, t0.addr_2 AS addr_2_11, t0.city AS city_12, t0.state AS state_13, t0.postcode AS postcode_14, t0.country_code AS country_code_15, t0.id_nationality AS id_nationality_16, t0.gender AS gender_17, t0.tel AS tel_18, t0.fax AS fax_19, t0.email1 AS email1_20, t0.email2 AS email2_21, t0.email3 AS email3_22, t0.emailtouse AS emailtouse_23, t0.url1 AS url1_24, t0.url1Valid AS url1Valid_25, t0.url2 AS url2_26, t0.url2Valid AS url2Valid_27, t0.url3 AS url3_28, t0.url3Valid AS url3Valid_29, t0.urlsChecked AS urlsChecked_30, t0.linkedin AS linkedin_31, t0.facebook AS facebook_32, t0.twitter AS twitter_33, t0.flickr AS flickr_34, t0.other AS other_35, t0.degree AS degree_36, t0.activeng AS activeng_37, t0.activother AS activother_38, t0.jobtitle AS jobtitle_39, t0.dept AS dept_40, t0.studyregion AS studyregion_41, t0.languages AS languages_42, t0.skills AS skills_43, t0.comments AS comments_44, t0.do_not_invite AS do_not_invite_45, t0.do_no_invite_by AS do_no_invite_by_46, t0.do_no_invite_on AS do_no_invite_on_47, t0.admin_comments AS admin_comments_48, t0.id_imagefile AS id_imagefile_49, t0.id_imagefile_full AS id_imagefile_full_50, t0.receive_mail AS receive_mail_51, t0.member_alert AS member_alert_52, t0.cit_alert AS cit_alert_53, t0.f_date_ent AS f_date_ent_54, t0.l_date_upd AS l_date_upd_55, t0.created_by AS created_by_56, t0.last_edit_by AS last_edit_by_57, t0.quality_checked_by AS quality_checked_by_58, t0.quality_checked_date AS quality_checked_date_59, t0.quality_checked AS quality_checked_60, t0.is_global AS is_global_61, t0.status AS status_62, t0.statusLastChanged AS statusLastChanged_63, t0.deceased AS deceased_64, t0.deceased_date AS deceased_date_65, t0.retired AS retired_66, t0.retired_date AS retired_date_67, t0.id AS id_68 FROM indiv t0 WHERE t0.id_ind = 19983 LIMIT 1;

SELECT 
  s0_.subname AS subname_0, 
  s0_.id_sub AS id_sub_1 
FROM 
  indiv_subjects i1_ 
  LEFT JOIN subjects s0_ ON (s0_.id_sub = i1_.id_sub) 
WHERE 
  i1_.id_ind = ?

SELECT s0_.subname AS subname_0, s0_.id_sub AS id_sub_1 FROM indiv_subjects i1_ LEFT JOIN subjects s0_ ON (s0_.id_sub = i1_.id_sub) WHERE i1_.id_ind = 27003;

SELECT 
  c0_.country AS country_0 
FROM 
  countries c0_ 
WHERE 
  c0_.id_country IN (?)

SELECT c0_.country AS country_0 FROM countries c0_ WHERE c0_.id_country IN ('3');

SELECT 
  t0.country AS country_1, 
  t0.postcode_pos AS postcode_pos_2, 
  t0.postcode_spacer AS postcode_spacer_3, 
  t0.country_code AS country_code_4, 
  t0.latitude AS latitude_5, 
  t0.longitude AS longitude_6, 
  t0.id_country AS id_country_7 
FROM 
  countries t0 
WHERE 
  t0.id_country = ? 
LIMIT 
  1

SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.id_country AS id_country_7 FROM countries t0 WHERE t0.id_country = '3' LIMIT 1;

SELECT 
  r0_.name AS name_0 
FROM 
  regions r0_ 
WHERE 
  r0_.id_region IN (?)

SELECT r0_.name AS name_0 FROM regions r0_ WHERE r0_.id_region IN ('2');

SELECT 
  t0.country AS country_1, 
  t0.postcode_pos AS postcode_pos_2, 
  t0.postcode_spacer AS postcode_spacer_3, 
  t0.country_code AS country_code_4, 
  t0.latitude AS latitude_5, 
  t0.longitude AS longitude_6, 
  t0.id_country AS id_country_7 
FROM 
  countries t0 
WHERE 
  t0.id_country = ? 
LIMIT 
  1

SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.id_country AS id_country_7 FROM countries t0 WHERE t0.id_country = 3 LIMIT 1;

SELECT 
  t0.country AS country_1, 
  t0.postcode_pos AS postcode_pos_2, 
  t0.postcode_spacer AS postcode_spacer_3, 
  t0.country_code AS country_code_4, 
  t0.latitude AS latitude_5, 
  t0.longitude AS longitude_6, 
  t0.id_country AS id_country_7 
FROM 
  countries t0 
WHERE 
  t0.id_country = ? 
LIMIT 
  1

SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.id_country AS id_country_7 FROM countries t0 WHERE t0.id_country = 3 LIMIT 1;

SELECT 
  t0.country AS country_1, 
  t0.postcode_pos AS postcode_pos_2, 
  t0.postcode_spacer AS postcode_spacer_3, 
  t0.country_code AS country_code_4, 
  t0.latitude AS latitude_5, 
  t0.longitude AS longitude_6, 
  t0.id_country AS id_country_7 
FROM 
  countries t0 
WHERE 
  t0.id_country = ? 
LIMIT 
  1

SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.id_country AS id_country_7 FROM countries t0 WHERE t0.id_country = 3 LIMIT 1;

SELECT 
  t0.country AS country_1, 
  t0.postcode_pos AS postcode_pos_2, 
  t0.postcode_spacer AS postcode_spacer_3, 
  t0.country_code AS country_code_4, 
  t0.latitude AS latitude_5, 
  t0.longitude AS longitude_6, 
  t0.id_country AS id_country_7 
FROM 
  countries t0 
WHERE 
  t0.id_country = ? 
LIMIT 
  1

SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.id_country AS id_country_7 FROM countries t0 WHERE t0.id_country = 3 LIMIT 1;

SELECT 
  t0.id_ind AS id_ind_1, 
  t0.title AS title_2, 
  t0.fname AS fname_3, 
  t0.mname AS mname_4, 
  t0.sname AS sname_5, 
  t0.identifier AS identifier_6, 
  t0.reg_type AS reg_type_7, 
  t0.use_inst_addr AS use_inst_addr_8, 
  t0.private_address AS private_address_9, 
  t0.addr_1 AS addr_1_10, 
  t0.addr_2 AS addr_2_11, 
  t0.city AS city_12, 
  t0.state AS state_13, 
  t0.postcode AS postcode_14, 
  t0.country_code AS country_code_15, 
  t0.id_nationality AS id_nationality_16, 
  t0.gender AS gender_17, 
  t0.tel AS tel_18, 
  t0.fax AS fax_19, 
  t0.email1 AS email1_20, 
  t0.email2 AS email2_21, 
  t0.email3 AS email3_22, 
  t0.emailtouse AS emailtouse_23, 
  t0.url1 AS url1_24, 
  t0.url1Valid AS url1Valid_25, 
  t0.url2 AS url2_26, 
  t0.url2Valid AS url2Valid_27, 
  t0.url3 AS url3_28, 
  t0.url3Valid AS url3Valid_29, 
  t0.urlsChecked AS urlsChecked_30, 
  t0.linkedin AS linkedin_31, 
  t0.facebook AS facebook_32, 
  t0.twitter AS twitter_33, 
  t0.flickr AS flickr_34, 
  t0.other AS other_35, 
  t0.degree AS degree_36, 
  t0.activeng AS activeng_37, 
  t0.activother AS activother_38, 
  t0.jobtitle AS jobtitle_39, 
  t0.dept AS dept_40, 
  t0.studyregion AS studyregion_41, 
  t0.languages AS languages_42, 
  t0.skills AS skills_43, 
  t0.comments AS comments_44, 
  t0.do_not_invite AS do_not_invite_45, 
  t0.do_no_invite_by AS do_no_invite_by_46, 
  t0.do_no_invite_on AS do_no_invite_on_47, 
  t0.admin_comments AS admin_comments_48, 
  t0.id_imagefile AS id_imagefile_49, 
  t0.id_imagefile_full AS id_imagefile_full_50, 
  t0.receive_mail AS receive_mail_51, 
  t0.member_alert AS member_alert_52, 
  t0.cit_alert AS cit_alert_53, 
  t0.f_date_ent AS f_date_ent_54, 
  t0.l_date_upd AS l_date_upd_55, 
  t0.created_by AS created_by_56, 
  t0.last_edit_by AS last_edit_by_57, 
  t0.quality_checked_by AS quality_checked_by_58, 
  t0.quality_checked_date AS quality_checked_date_59, 
  t0.quality_checked AS quality_checked_60, 
  t0.is_global AS is_global_61, 
  t0.status AS status_62, 
  t0.statusLastChanged AS statusLastChanged_63, 
  t0.deceased AS deceased_64, 
  t0.deceased_date AS deceased_date_65, 
  t0.retired AS retired_66, 
  t0.retired_date AS retired_date_67, 
  t0.id AS id_68 
FROM 
  indiv t0 
WHERE 
  t0.id_ind = ? 
LIMIT 
  1

SELECT t0.id_ind AS id_ind_1, t0.title AS title_2, t0.fname AS fname_3, t0.mname AS mname_4, t0.sname AS sname_5, t0.identifier AS identifier_6, t0.reg_type AS reg_type_7, t0.use_inst_addr AS use_inst_addr_8, t0.private_address AS private_address_9, t0.addr_1 AS addr_1_10, t0.addr_2 AS addr_2_11, t0.city AS city_12, t0.state AS state_13, t0.postcode AS postcode_14, t0.country_code AS country_code_15, t0.id_nationality AS id_nationality_16, t0.gender AS gender_17, t0.tel AS tel_18, t0.fax AS fax_19, t0.email1 AS email1_20, t0.email2 AS email2_21, t0.email3 AS email3_22, t0.emailtouse AS emailtouse_23, t0.url1 AS url1_24, t0.url1Valid AS url1Valid_25, t0.url2 AS url2_26, t0.url2Valid AS url2Valid_27, t0.url3 AS url3_28, t0.url3Valid AS url3Valid_29, t0.urlsChecked AS urlsChecked_30, t0.linkedin AS linkedin_31, t0.facebook AS facebook_32, t0.twitter AS twitter_33, t0.flickr AS flickr_34, t0.other AS other_35, t0.degree AS degree_36, t0.activeng AS activeng_37, t0.activother AS activother_38, t0.jobtitle AS jobtitle_39, t0.dept AS dept_40, t0.studyregion AS studyregion_41, t0.languages AS languages_42, t0.skills AS skills_43, t0.comments AS comments_44, t0.do_not_invite AS do_not_invite_45, t0.do_no_invite_by AS do_no_invite_by_46, t0.do_no_invite_on AS do_no_invite_on_47, t0.admin_comments AS admin_comments_48, t0.id_imagefile AS id_imagefile_49, t0.id_imagefile_full AS id_imagefile_full_50, t0.receive_mail AS receive_mail_51, t0.member_alert AS member_alert_52, t0.cit_alert AS cit_alert_53, t0.f_date_ent AS f_date_ent_54, t0.l_date_upd AS l_date_upd_55, t0.created_by AS created_by_56, t0.last_edit_by AS last_edit_by_57, t0.quality_checked_by AS quality_checked_by_58, t0.quality_checked_date AS quality_checked_date_59, t0.quality_checked AS quality_checked_60, t0.is_global AS is_global_61, t0.status AS status_62, t0.statusLastChanged AS statusLastChanged_63, t0.deceased AS deceased_64, t0.deceased_date AS deceased_date_65, t0.retired AS retired_66, t0.retired_date AS retired_date_67, t0.id AS id_68 FROM indiv t0 WHERE t0.id_ind = 0 LIMIT 1;

SELECT 
  m0_.id_group AS id_group_0 
FROM 
  member_groups m0_ 
WHERE 
  m0_.id_ind = ?