Symfony Profiler

SELECT 
  e0_.id_role AS id_role_0, 
  e0_.id_ind AS id_ind_1, 
  e0_.status AS status_2, 
  i1_.title AS title_3, 
  i1_.fname AS fname_4, 
  i1_.sname AS sname_5, 
  i1_.use_inst_addr AS use_inst_addr_6, 
  i1_.tel AS tel_7, 
  i1_.fax AS fax_8, 
  i1_.addr_1 AS addr_1_9, 
  i1_.addr_2 AS addr_2_10, 
  i1_.city AS city_11, 
  i1_.state AS state_12, 
  i1_.postcode AS postcode_13, 
  i1_.jobtitle AS jobtitle_14, 
  i1_.email1 AS email1_15, 
  i1_.email2 AS email2_16, 
  c2_.country_code AS country_code_17, 
  c2_.country AS country_18, 
  i3_.inst_name AS inst_name_19, 
  i3_.inst_name_eng AS inst_name_eng_20, 
  i1_.dept AS dept_21, 
  i3_.inst_address AS inst_address_22, 
  i3_.addr_2 AS addr_2_23, 
  i3_.city AS city_24, 
  i3_.state AS state_25, 
  i3_.postcode AS postcode_26, 
  c4_.country_code AS country_code_27, 
  c4_.country AS country_28, 
  e5_.role AS role_29, 
  e5_.ordering AS ordering_30 
FROM 
  event_participants e0_ 
  LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) 
  LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) 
  LEFT JOIN countries c2_ ON (
    c2_.id_country = i1_.country_code
  ) 
  LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) 
  LEFT JOIN countries c4_ ON (
    c4_.id_country = i3_.country_code
  ) 
  LEFT JOIN event_participantroles e5_ ON (
    e0_.id_role = e5_.id_role 
    AND e0_.id_event = e5_.id_event
  ) 
WHERE 
  e0_.id_event = ? 
  AND e0_.status IN (0, 1) 
  AND e0_.id_role = ? 
ORDER BY 
  i1_.sname ASC

SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_2, i1_.title AS title_3, i1_.fname AS fname_4, i1_.sname AS sname_5, i1_.use_inst_addr AS use_inst_addr_6, i1_.tel AS tel_7, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = '1165' AND e0_.status IN (0, 1) AND e0_.id_role = 2 ORDER BY i1_.sname ASC;

SELECT 
  e0_.role AS role_0, 
  e0_.id_role AS id_role_1, 
  e0_.ppt_ordering AS ppt_ordering_2 
FROM 
  event_participantroles e0_ 
WHERE 
  e0_.id_event = ? 
ORDER BY 
  e0_.ordering ASC

SELECT e0_.role AS role_0, e0_.id_role AS id_role_1, e0_.ppt_ordering AS ppt_ordering_2 FROM event_participantroles e0_ WHERE e0_.id_event = '1165' ORDER BY e0_.ordering ASC;

SELECT 
  t0.id_eventtype AS id_eventtype_1, 
  t0.title AS title_2, 
  t0.shorttitle AS shorttitle_3, 
  t0.summary AS summary_4, 
  t0.start_on AS start_on_5, 
  t0.end_on AS end_on_6, 
  t0.address AS address_7, 
  t0.city AS city_8, 
  t0.state AS state_9, 
  t0.postcode AS postcode_10, 
  t0.id_country AS id_country_11, 
  t0.id_inst AS id_inst_12, 
  t0.use_inst_addr AS use_inst_addr_13, 
  t0.notes AS notes_14, 
  t0.website AS website_15, 
  t0.redirect_website AS redirect_website_16, 
  t0.keywords AS keywords_17, 
  t0.created_by AS created_by_18, 
  t0.created_at AS created_at_19, 
  t0.updated_at AS updated_at_20, 
  t0.last_edit_by AS last_edit_by_21, 
  t0.is_public AS is_public_22, 
  t0.is_open AS is_open_23, 
  t0.show_travel AS show_travel_24, 
  t0.email_people AS email_people_25, 
  t0.id_contact AS id_contact_26, 
  t0.reg_online AS reg_online_27, 
  t0.status AS status_28, 
  t0.id_event AS id_event_29 
FROM 
  events t0 
WHERE 
  t0.id_event = ? 
LIMIT 
  1

SELECT t0.id_eventtype AS id_eventtype_1, t0.title AS title_2, t0.shorttitle AS shorttitle_3, t0.summary AS summary_4, t0.start_on AS start_on_5, t0.end_on AS end_on_6, t0.address AS address_7, t0.city AS city_8, t0.state AS state_9, t0.postcode AS postcode_10, t0.id_country AS id_country_11, t0.id_inst AS id_inst_12, t0.use_inst_addr AS use_inst_addr_13, t0.notes AS notes_14, t0.website AS website_15, t0.redirect_website AS redirect_website_16, t0.keywords AS keywords_17, t0.created_by AS created_by_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.last_edit_by AS last_edit_by_21, t0.is_public AS is_public_22, t0.is_open AS is_open_23, t0.show_travel AS show_travel_24, t0.email_people AS email_people_25, t0.id_contact AS id_contact_26, t0.reg_online AS reg_online_27, t0.status AS status_28, t0.id_event AS id_event_29 FROM events t0 WHERE t0.id_event = '1165' LIMIT 1;

SELECT 
  e0_.id_role AS id_role_0, 
  e0_.id_ind AS id_ind_1, 
  e0_.status AS status_2, 
  i1_.title AS title_3, 
  i1_.fname AS fname_4, 
  i1_.sname AS sname_5, 
  i1_.use_inst_addr AS use_inst_addr_6, 
  i1_.tel AS tel_7, 
  i1_.fax AS fax_8, 
  i1_.addr_1 AS addr_1_9, 
  i1_.addr_2 AS addr_2_10, 
  i1_.city AS city_11, 
  i1_.state AS state_12, 
  i1_.postcode AS postcode_13, 
  i1_.jobtitle AS jobtitle_14, 
  i1_.email1 AS email1_15, 
  i1_.email2 AS email2_16, 
  c2_.country_code AS country_code_17, 
  c2_.country AS country_18, 
  i3_.inst_name AS inst_name_19, 
  i3_.inst_name_eng AS inst_name_eng_20, 
  i1_.dept AS dept_21, 
  i3_.inst_address AS inst_address_22, 
  i3_.addr_2 AS addr_2_23, 
  i3_.city AS city_24, 
  i3_.state AS state_25, 
  i3_.postcode AS postcode_26, 
  c4_.country_code AS country_code_27, 
  c4_.country AS country_28, 
  e5_.role AS role_29, 
  e5_.ordering AS ordering_30 
FROM 
  event_participants e0_ 
  LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) 
  LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) 
  LEFT JOIN countries c2_ ON (
    c2_.id_country = i1_.country_code
  ) 
  LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) 
  LEFT JOIN countries c4_ ON (
    c4_.id_country = i3_.country_code
  ) 
  LEFT JOIN event_participantroles e5_ ON (
    e0_.id_role = e5_.id_role 
    AND e0_.id_event = e5_.id_event
  ) 
WHERE 
  e0_.id_event = ? 
  AND e0_.status IN (0, 1) 
  AND e0_.id_role IS NULL 
ORDER BY 
  i1_.sname ASC

SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_2, i1_.title AS title_3, i1_.fname AS fname_4, i1_.sname AS sname_5, i1_.use_inst_addr AS use_inst_addr_6, i1_.tel AS tel_7, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = '1165' AND e0_.status IN (0, 1) AND e0_.id_role IS NULL ORDER BY i1_.sname ASC;