Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.prefix AS prefix_2,
  t0.number AS number_3,
  t0.date_at AS date_at_4,
  t0.proposal_id AS proposal_id_5,
  t0.created_at AS created_at_6,
  t0.created_id AS created_id_7,
  t0.updated_at AS updated_at_8,
  t0.updated_id AS updated_id_9
FROM
  proposal_invoice_deposit_control t0
WHERE
  t0.proposal_id = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.prefix AS prefix_2, t0.number AS number_3, t0.date_at AS date_at_4, t0.proposal_id AS proposal_id_5, t0.created_at AS created_at_6, t0.created_id AS created_id_7, t0.updated_at AS updated_at_8, t0.updated_id AS updated_id_9 FROM proposal_invoice_deposit_control t0 WHERE t0.proposal_id = '6047' AND t0.id = '741' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.commission AS commission_4,
  t0.pax AS pax_5,
  t0.bedrooms AS bedrooms_6,
  t0.office_id AS office_id_7,
  t0.client_id AS client_id_8,
  t0.contact_id AS contact_id_9,
  t0.reference_name AS reference_name_10,
  t0.reference_id AS reference_id_11,
  t0.agent_id AS agent_id_12,
  t0.approximate_billing AS approximate_billing_13,
  t0.team_id AS team_id_14,
  t0.agent_two_id AS agent_two_id_15,
  t0.agent_commercial_id AS agent_commercial_id_16,
  t0.date_proposed_at AS date_proposed_at_17,
  t0.date_event_star_at AS date_event_star_at_18,
  t0.date_event_end_at AS date_event_end_at_19,
  t0.days_email_reminder AS days_email_reminder_20,
  t0.language AS language_21,
  t0.include_logo AS include_logo_22,
  t0.version_ppt AS version_ppt_23,
  t0.version_excel AS version_excel_24,
  t0.version_flahs AS version_flahs_25,
  t0.version_word AS version_word_26,
  t0.briefing AS briefing_27,
  t0.date_presentation_at AS date_presentation_at_28,
  t0.status AS status_29,
  t0.sent AS sent_30,
  t0.select_type AS select_type_31,
  t0.created_at AS created_at_32,
  t0.created_id AS created_id_33,
  t0.updated_at AS updated_at_34,
  t0.updated_id AS updated_id_35,
  t0.access_key AS access_key_36,
  t0.viewed_at AS viewed_at_37,
  t0.observation AS observation_38,
  t0.send_admin AS send_admin_39,
  t0.mcp AS mcp_40,
  t0.image AS image_41,
  t0.category AS category_42,
  t0.idMusic AS idMusic_43
FROM
  proposals t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.commission AS commission_4, t0.pax AS pax_5, t0.bedrooms AS bedrooms_6, t0.office_id AS office_id_7, t0.client_id AS client_id_8, t0.contact_id AS contact_id_9, t0.reference_name AS reference_name_10, t0.reference_id AS reference_id_11, t0.agent_id AS agent_id_12, t0.approximate_billing AS approximate_billing_13, t0.team_id AS team_id_14, t0.agent_two_id AS agent_two_id_15, t0.agent_commercial_id AS agent_commercial_id_16, t0.date_proposed_at AS date_proposed_at_17, t0.date_event_star_at AS date_event_star_at_18, t0.date_event_end_at AS date_event_end_at_19, t0.days_email_reminder AS days_email_reminder_20, t0.language AS language_21, t0.include_logo AS include_logo_22, t0.version_ppt AS version_ppt_23, t0.version_excel AS version_excel_24, t0.version_flahs AS version_flahs_25, t0.version_word AS version_word_26, t0.briefing AS briefing_27, t0.date_presentation_at AS date_presentation_at_28, t0.status AS status_29, t0.sent AS sent_30, t0.select_type AS select_type_31, t0.created_at AS created_at_32, t0.created_id AS created_id_33, t0.updated_at AS updated_at_34, t0.updated_id AS updated_id_35, t0.access_key AS access_key_36, t0.viewed_at AS viewed_at_37, t0.observation AS observation_38, t0.send_admin AS send_admin_39, t0.mcp AS mcp_40, t0.image AS image_41, t0.category AS category_42, t0.idMusic AS idMusic_43 FROM proposals t0 WHERE t0.id = '6047' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.company AS company_2,
  t0.id_document AS id_document_3,
  t0.registry AS registry_4,
  t0.address AS address_5,
  t0.zip_code AS zip_code_6,
  t0.telephone AS telephone_7,
  t0.fax AS fax_8,
  t0.email AS email_9,
  t0.note AS note_10,
  t0.note_sin_iva AS note_sin_iva_11,
  t0.created_at AS created_at_12,
  t0.created_id AS created_id_13,
  t0.updated_at AS updated_at_14,
  t0.updated_id AS updated_id_15,
  t0.picture AS picture_16,
  t0.priority AS priority_17,
  t0.token AS token_18
FROM
  settings_company t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.company AS company_2, t0.id_document AS id_document_3, t0.registry AS registry_4, t0.address AS address_5, t0.zip_code AS zip_code_6, t0.telephone AS telephone_7, t0.fax AS fax_8, t0.email AS email_9, t0.note AS note_10, t0.note_sin_iva AS note_sin_iva_11, t0.created_at AS created_at_12, t0.created_id AS created_id_13, t0.updated_at AS updated_at_14, t0.updated_id AS updated_id_15, t0.picture AS picture_16, t0.priority AS priority_17, t0.token AS token_18 FROM settings_company t0 WHERE t0.id = '1' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.type AS type_1,
  c0_.name AS name_2,
  c0_.title AS title_3,
  c0_.address AS address_4,
  c0_.address_number AS address_number_5,
  c0_.zip_code AS zip_code_6,
  c0_.population AS population_7,
  c0_.province AS province_8,
  c0_.region AS region_9,
  c0_.country AS country_10,
  c0_.telephone AS telephone_11,
  c0_.fax AS fax_12,
  c0_.email AS email_13,
  c0_.gds AS gds_14,
  c0_.type_document AS type_document_15,
  c0_.id_document AS id_document_16,
  c0_.observation AS observation_17,
  c0_.id_office AS id_office_18,
  c0_.created_at AS created_at_19,
  c0_.created_id AS created_id_20,
  c0_.updated_at AS updated_at_21,
  c0_.updated_id AS updated_id_22,
  c0_.status AS status_23,
  c0_.picture AS picture_24,
  c0_.group_id AS group_id_25,
  c0_.competency AS competency_26,
  c0_.action AS action_27,
  c0_.return_investment AS return_investment_28,
  c0_.is_client_in_out AS is_client_in_out_29,
  c0_.is_client_green_patio AS is_client_green_patio_30,
  c0_.is_client_av_express AS is_client_av_express_31,
  c0_.is_client_develup AS is_client_develup_32,
  c0_.typology AS typology_33,
  c1_.name AS name_34,
  r2_.name AS name_35,
  p3_.name AS name_36,
  c4_.name AS name_37
FROM
  clients c0_
  INNER JOIN countries c1_ ON (c1_.id = c0_.country)
  INNER JOIN regions r2_ ON (r2_.id = c0_.region)
  INNER JOIN provinces p3_ ON (p3_.id = c0_.province)
  INNER JOIN cities c4_ ON (c4_.id = c0_.population)
WHERE
  c0_.id = ?

SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.name AS name_2, c0_.title AS title_3, c0_.address AS address_4, c0_.address_number AS address_number_5, c0_.zip_code AS zip_code_6, c0_.population AS population_7, c0_.province AS province_8, c0_.region AS region_9, c0_.country AS country_10, c0_.telephone AS telephone_11, c0_.fax AS fax_12, c0_.email AS email_13, c0_.gds AS gds_14, c0_.type_document AS type_document_15, c0_.id_document AS id_document_16, c0_.observation AS observation_17, c0_.id_office AS id_office_18, c0_.created_at AS created_at_19, c0_.created_id AS created_id_20, c0_.updated_at AS updated_at_21, c0_.updated_id AS updated_id_22, c0_.status AS status_23, c0_.picture AS picture_24, c0_.group_id AS group_id_25, c0_.competency AS competency_26, c0_.action AS action_27, c0_.return_investment AS return_investment_28, c0_.is_client_in_out AS is_client_in_out_29, c0_.is_client_green_patio AS is_client_green_patio_30, c0_.is_client_av_express AS is_client_av_express_31, c0_.is_client_develup AS is_client_develup_32, c0_.typology AS typology_33, c1_.name AS name_34, r2_.name AS name_35, p3_.name AS name_36, c4_.name AS name_37 FROM clients c0_ INNER JOIN countries c1_ ON (c1_.id = c0_.country) INNER JOIN regions r2_ ON (r2_.id = c0_.region) INNER JOIN provinces p3_ ON (p3_.id = c0_.province) INNER JOIN cities c4_ ON (c4_.id = c0_.population) WHERE c0_.id = 5114;

SELECT
  t0.id AS id_1,
  t0.prefix AS prefix_2,
  t0.number AS number_3,
  t0.date_at AS date_at_4,
  t0.proposal_id AS proposal_id_5,
  t0.created_at AS created_at_6,
  t0.created_id AS created_id_7,
  t0.updated_at AS updated_at_8,
  t0.updated_id AS updated_id_9
FROM
  proposal_invoice_deposit_control t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.prefix AS prefix_2, t0.number AS number_3, t0.date_at AS date_at_4, t0.proposal_id AS proposal_id_5, t0.created_at AS created_at_6, t0.created_id AS created_id_7, t0.updated_at AS updated_at_8, t0.updated_id AS updated_id_9 FROM proposal_invoice_deposit_control t0 WHERE t0.id = 741 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.control_id AS control_id_2,
  t0.name AS name_3,
  t0.amount AS amount_4,
  t0.iva AS iva_5,
  t0.proposal_id AS proposal_id_6,
  t0.created_at AS created_at_7,
  t0.created_id AS created_id_8,
  t0.updated_at AS updated_at_9,
  t0.updated_id AS updated_id_10
FROM
  proposal_invoice_deposit_items t0
WHERE
  t0.proposal_id = ?
  AND t0.control_id = ?

SELECT t0.id AS id_1, t0.control_id AS control_id_2, t0.name AS name_3, t0.amount AS amount_4, t0.iva AS iva_5, t0.proposal_id AS proposal_id_6, t0.created_at AS created_at_7, t0.created_id AS created_id_8, t0.updated_at AS updated_at_9, t0.updated_id AS updated_id_10 FROM proposal_invoice_deposit_items t0 WHERE t0.proposal_id = '6047' AND t0.control_id = 741;