Symfony Profiler

SELECT 
  p0_.id AS id_0, 
  p0_.name AS name_1, 
  p0_.slug AS slug_2, 
  p0_.address1 AS address1_3, 
  p0_.address2 AS address2_4, 
  p0_.city AS city_5, 
  p0_.postcode AS postcode_6, 
  p0_.launch_at AS launch_at_7, 
  p0_.website AS website_8, 
  p0_.is_eis_application_complete AS is_eis_application_complete_9, 
  p0_.companies_house_url AS companies_house_url_10, 
  p0_.mtm AS mtm_11, 
  p0_.share_issue_date_at AS share_issue_date_at_12, 
  p0_.fund_raise_percent AS fund_raise_percent_13, 
  p0_.pref_share_interest_rate AS pref_share_interest_rate_14, 
  p0_.pref_share_link AS pref_share_link_15, 
  p0_.max_percent_equity_in_excess_pref_shares AS max_percent_equity_in_excess_pref_shares_16, 
  p0_.ducalian_and_harcourt_inns_fees AS ducalian_and_harcourt_inns_fees_17, 
  p0_.bank_sort_code AS bank_sort_code_18, 
  p0_.bank_account_number AS bank_account_number_19, 
  p0_.bank_account_name AS bank_account_name_20, 
  p0_.pref_share_form AS pref_share_form_21, 
  p0_.is_sag_managed AS is_sag_managed_22, 
  p0_.company_number AS company_number_23, 
  p0_.legal_company_name AS legal_company_name_24, 
  p0_.director1_id AS director1_id_25, 
  p0_.director2_id AS director2_id_26, 
  p0_.director3_id AS director3_id_27, 
  p0_.director4_id AS director4_id_28 
FROM 
  pub p0_ 
WHERE 
  p0_.slug <> ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.address1 AS address1_3, p0_.address2 AS address2_4, p0_.city AS city_5, p0_.postcode AS postcode_6, p0_.launch_at AS launch_at_7, p0_.website AS website_8, p0_.is_eis_application_complete AS is_eis_application_complete_9, p0_.companies_house_url AS companies_house_url_10, p0_.mtm AS mtm_11, p0_.share_issue_date_at AS share_issue_date_at_12, p0_.fund_raise_percent AS fund_raise_percent_13, p0_.pref_share_interest_rate AS pref_share_interest_rate_14, p0_.pref_share_link AS pref_share_link_15, p0_.max_percent_equity_in_excess_pref_shares AS max_percent_equity_in_excess_pref_shares_16, p0_.ducalian_and_harcourt_inns_fees AS ducalian_and_harcourt_inns_fees_17, p0_.bank_sort_code AS bank_sort_code_18, p0_.bank_account_number AS bank_account_number_19, p0_.bank_account_name AS bank_account_name_20, p0_.pref_share_form AS pref_share_form_21, p0_.is_sag_managed AS is_sag_managed_22, p0_.company_number AS company_number_23, p0_.legal_company_name AS legal_company_name_24, p0_.director1_id AS director1_id_25, p0_.director2_id AS director2_id_26, p0_.director3_id AS director3_id_27, p0_.director4_id AS director4_id_28 FROM pub p0_ WHERE p0_.slug <> 'xxx';

SELECT 
  t0.id AS id_1, 
  t0.pub_id AS pub_id_2 
FROM 
  fundraise t0 
WHERE 
  t0.pub_id = ?

SELECT t0.id AS id_1, t0.pub_id AS pub_id_2 FROM fundraise t0 WHERE t0.pub_id = 1;