Symfony Profiler

SELECT 
  d0_.doc_code AS doc_code_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.id_docstatus AS id_docstatus_2, 
  d0_.title AS title_3, 
  d0_.summary AS summary_4, 
  d0_.author_text AS author_text_5, 
  d0_.published_on AS published_on_6, 
  d0_.notes AS notes_7, 
  d0_.keywords AS keywords_8, 
  d0_.created_at AS created_at_9, 
  d0_.updated_at AS updated_at_10, 
  d0_.id_creator AS id_creator_11, 
  d0_.last_edit_by AS last_edit_by_12, 
  d0_.url AS url_13, 
  d0_.id_doctype AS id_doctype_14, 
  d1_.doctypename AS doctypename_15 
FROM 
  documents d0_ 
  LEFT JOIN doctypes d1_ ON (d0_.id_doctype = d1_.id_doctype) 
WHERE 
  d0_.id_doc = ? 
  AND d0_.approved = 1

SELECT d0_.doc_code AS doc_code_0, d0_.id_doc AS id_doc_1, d0_.id_docstatus AS id_docstatus_2, d0_.title AS title_3, d0_.summary AS summary_4, d0_.author_text AS author_text_5, d0_.published_on AS published_on_6, d0_.notes AS notes_7, d0_.keywords AS keywords_8, d0_.created_at AS created_at_9, d0_.updated_at AS updated_at_10, d0_.id_creator AS id_creator_11, d0_.last_edit_by AS last_edit_by_12, d0_.url AS url_13, d0_.id_doctype AS id_doctype_14, d1_.doctypename AS doctypename_15 FROM documents d0_ LEFT JOIN doctypes d1_ ON (d0_.id_doctype = d1_.id_doctype) WHERE d0_.id_doc = '18583' AND d0_.approved = 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 
  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 
  DISTINCT e0_.id_event AS id_event_0, 
  e0_.title AS title_1 
FROM 
  events e0_ 
  LEFT JOIN event_backgrounddocs e1_ ON (e0_.id_event = e1_.id_event) 
WHERE 
  e1_.id_doc = ?

SELECT DISTINCT e0_.id_event AS id_event_0, e0_.title AS title_1 FROM events e0_ LEFT JOIN event_backgrounddocs e1_ ON (e0_.id_event = e1_.id_event) WHERE e1_.id_doc = '18583';

SELECT 
  DISTINCT e0_.id_event AS id_event_0, 
  e0_.title AS title_1 
FROM 
  events e0_ 
  LEFT JOIN agendaitem_documents a1_ ON (e0_.id_event = a1_.id_event) 
WHERE 
  a1_.id_doc = ?

SELECT DISTINCT e0_.id_event AS id_event_0, e0_.title AS title_1 FROM events e0_ LEFT JOIN agendaitem_documents a1_ ON (e0_.id_event = a1_.id_event) WHERE a1_.id_doc = '18583';

SELECT 
  DISTINCT e0_.id_event AS id_event_0, 
  e0_.title AS title_1 
FROM 
  events e0_ 
  LEFT JOIN event_otherdocs e1_ ON (e0_.id_event = e1_.id_event) 
WHERE 
  e1_.id_doc = ?

SELECT DISTINCT e0_.id_event AS id_event_0, e0_.title AS title_1 FROM events e0_ LEFT JOIN event_otherdocs e1_ ON (e0_.id_event = e1_.id_event) WHERE e1_.id_doc = '18583';

SELECT 
  DISTINCT e0_.id_event AS id_event_0, 
  e0_.title AS title_1 
FROM 
  events e0_ 
  LEFT JOIN event_presentations e1_ ON (e0_.id_event = e1_.id_event) 
WHERE 
  e1_.id_doc = ?

SELECT DISTINCT e0_.id_event AS id_event_0, e0_.title AS title_1 FROM events e0_ LEFT JOIN event_presentations e1_ ON (e0_.id_event = e1_.id_event) WHERE e1_.id_doc = '18583';

SELECT 
  DISTINCT e0_.id_event AS id_event_0, 
  e0_.title AS title_1 
FROM 
  events e0_ 
  LEFT JOIN event_reports e1_ ON (e0_.id_event = e1_.id_event) 
WHERE 
  e1_.id_doc = ?

SELECT DISTINCT e0_.id_event AS id_event_0, e0_.title AS title_1 FROM events e0_ LEFT JOIN event_reports e1_ ON (e0_.id_event = e1_.id_event) WHERE e1_.id_doc = '18583';

SELECT 
  d0_.id_group AS id_group_0, 
  g1_.groupname AS groupname_1 
FROM 
  document_groups d0_ 
  LEFT JOIN groups g1_ ON (d0_.id_group = g1_.id_group) 
WHERE 
  d0_.id_doc = ?

SELECT d0_.id_group AS id_group_0, g1_.groupname AS groupname_1 FROM document_groups d0_ LEFT JOIN groups g1_ ON (d0_.id_group = g1_.id_group) WHERE d0_.id_doc = '18583';

SELECT 
  d0_.id_doclist AS id_doclist_0, 
  d0_.title AS title_1 
FROM 
  doclist_documents d1_ 
  LEFT JOIN doclists d0_ ON (d0_.id_doclist = d1_.id_doclist) 
WHERE 
  d1_.id_doc = ? 
ORDER BY 
  d0_.title ASC

SELECT d0_.id_doclist AS id_doclist_0, d0_.title AS title_1 FROM doclist_documents d1_ LEFT JOIN doclists d0_ ON (d0_.id_doclist = d1_.id_doclist) WHERE d1_.id_doc = '18583' ORDER BY d0_.title ASC;

SELECT 
  d0_.id_doclist AS id_doclist_0, 
  CONCAT(g1_.groupname, ' - ', d0_.title) AS sclr_1 
FROM 
  doclists d0_ 
  LEFT JOIN doclist_groups d2_ ON (d0_.id_doclist = d2_.id_doclist) 
  LEFT JOIN groups g1_ ON (d2_.id_group = g1_.id_group) 
WHERE 
  g1_.groupname <> '' 
ORDER BY 
  g1_.groupname ASC, 
  d0_.title ASC

SELECT d0_.id_doclist AS id_doclist_0, CONCAT(g1_.groupname, ' - ', d0_.title) AS sclr_1 FROM doclists d0_ LEFT JOIN doclist_groups d2_ ON (d0_.id_doclist = d2_.id_doclist) LEFT JOIN groups g1_ ON (d2_.id_group = g1_.id_group) WHERE g1_.groupname <> '' ORDER BY g1_.groupname ASC, d0_.title ASC;

SELECT 
  d0_.id_fileformat AS id_fileformat_0, 
  d0_.version AS version_1, 
  l1_.languagename AS languagename_2, 
  d0_.id_file AS id_file_3, 
  f2_.filename AS filename_4, 
  f2_.url AS url_5, 
  f2_.size AS size_6, 
  f2_.content AS content_7, 
  f2_.path AS path_8 
FROM 
  document_files d0_ 
  LEFT JOIN files f2_ ON (f2_.id_file = d0_.id_file) 
  LEFT JOIN languages l1_ ON (
    f2_.id_language = l1_.id_language
  ) 
WHERE 
  d0_.id_doc = ?

SELECT d0_.id_fileformat AS id_fileformat_0, d0_.version AS version_1, l1_.languagename AS languagename_2, d0_.id_file AS id_file_3, f2_.filename AS filename_4, f2_.url AS url_5, f2_.size AS size_6, f2_.content AS content_7, f2_.path AS path_8 FROM document_files d0_ LEFT JOIN files f2_ ON (f2_.id_file = d0_.id_file) LEFT JOIN languages l1_ ON (f2_.id_language = l1_.id_language) WHERE d0_.id_doc = '18583';