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 = '5649' AND d0_.approved = 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 = '5649';

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 = '5649';

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 = '5649';

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 = '5649';

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 = '5649';

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 = '5649';

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 = '5649' 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 = '5649';