Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1
FROM
  conference c0_
WHERE
  c0_.id NOT IN (
    SELECT
      c1_.id
    FROM
      conference c1_
      INNER JOIN contact_conference c2_ ON (c2_.conference_id = c1_.id)
    WHERE
      c2_.contact_id = ?
  )
GROUP BY
  c0_.name

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM conference c0_ WHERE c0_.id NOT IN (SELECT c1_.id FROM conference c1_ INNER JOIN contact_conference c2_ ON (c2_.conference_id = c1_.id) WHERE c2_.contact_id = 48431) GROUP BY c0_.name;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.lastname AS lastname_4,
  t0.firstname AS firstname_5,
  t0.email AS email_6,
  t0.is_active AS is_active_7,
  t0.role_id AS role_id_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.lastname AS lastname_4, t0.firstname AS firstname_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.role_id AS role_id_8 FROM user t0 WHERE t0.id = 415;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.role AS role_3
FROM
  role t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3 FROM role t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.fname AS fname_3,
  t0.lname AS lname_4,
  t0.email AS email_5,
  t0.valid_email AS valid_email_6,
  t0.position AS position_7,
  t0.division AS division_8,
  t0.phone1 AS phone1_9,
  t0.phone2 AS phone2_10,
  t0.corp_phone AS corp_phone_11,
  t0.linkedin_url AS linkedin_url_12,
  t0.city AS city_13,
  t0.comment AS comment_14,
  t0.lock_date AS lock_date_15,
  t0.updated_at AS updated_at_16,
  t0.missing_data AS missing_data_17,
  t0.last_import AS last_import_18,
  t0.trash AS trash_19,
  t0.last_delete AS last_delete_20,
  t0.country_id AS country_id_21,
  t0.source_id AS source_id_22,
  t0.csp_id AS csp_id_23,
  t0.csptype_id AS csptype_id_24,
  t0.lock_user AS lock_user_25
FROM
  contact t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.fname AS fname_3, t0.lname AS lname_4, t0.email AS email_5, t0.valid_email AS valid_email_6, t0.position AS position_7, t0.division AS division_8, t0.phone1 AS phone1_9, t0.phone2 AS phone2_10, t0.corp_phone AS corp_phone_11, t0.linkedin_url AS linkedin_url_12, t0.city AS city_13, t0.comment AS comment_14, t0.lock_date AS lock_date_15, t0.updated_at AS updated_at_16, t0.missing_data AS missing_data_17, t0.last_import AS last_import_18, t0.trash AS trash_19, t0.last_delete AS last_delete_20, t0.country_id AS country_id_21, t0.source_id AS source_id_22, t0.csp_id AS csp_id_23, t0.csptype_id AS csptype_id_24, t0.lock_user AS lock_user_25 FROM contact t0 WHERE t0.id = '48431' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.final_report AS final_report_5,
  t0.objective AS objective_6,
  t0.duration AS duration_7,
  t0.is_finished AS is_finished_8,
  t0.campaign_type_id AS campaign_type_id_9,
  t0.client_id AS client_id_10,
  t0.user_id AS user_id_11
FROM
  campaign t0
WHERE
  t0.id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.final_report AS final_report_5, t0.objective AS objective_6, t0.duration AS duration_7, t0.is_finished AS is_finished_8, t0.campaign_type_id AS campaign_type_id_9, t0.client_id AS client_id_10, t0.user_id AS user_id_11 FROM campaign t0 WHERE t0.id IS NULL LIMIT 1;

SELECT
  c0_.id AS id_0,
  c1_.name AS name_1,
  c0_.topic AS topic_2
FROM
  contact_conference c0_
  INNER JOIN conference c1_ ON c0_.conference_id = c1_.id
WHERE
  c0_.contact_id = ?
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c1_.name AS name_1, c0_.topic AS topic_2 FROM contact_conference c0_ INNER JOIN conference c1_ ON c0_.conference_id = c1_.id WHERE c0_.contact_id = 48431 ORDER BY c0_.id ASC;