Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.picture AS picture_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.movil_password AS movil_password_6,
  t0.pass_gmail AS pass_gmail_7,
  t0.firm_gmail AS firm_gmail_8,
  t0.name AS name_9,
  t0.last_name AS last_name_10,
  t0.telephone AS telephone_11,
  t0.mobile AS mobile_12,
  t0.status AS status_13,
  t0.team_leader AS team_leader_14,
  t0.role AS role_15,
  t0.access_key AS access_key_16,
  t0.language AS language_17,
  t0.color AS color_18,
  t0.sidebar AS sidebar_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.description AS description_22,
  t0.job_title AS job_title_23,
  t0.id_office AS id_office_24,
  t0.id_company AS id_company_25,
  t0.id_user_rol AS id_user_rol_26,
  t0.id_team AS id_team_27
FROM
  users t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.picture AS picture_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.movil_password AS movil_password_6, t0.pass_gmail AS pass_gmail_7, t0.firm_gmail AS firm_gmail_8, t0.name AS name_9, t0.last_name AS last_name_10, t0.telephone AS telephone_11, t0.mobile AS mobile_12, t0.status AS status_13, t0.team_leader AS team_leader_14, t0.role AS role_15, t0.access_key AS access_key_16, t0.language AS language_17, t0.color AS color_18, t0.sidebar AS sidebar_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.description AS description_22, t0.job_title AS job_title_23, t0.id_office AS id_office_24, t0.id_company AS id_company_25, t0.id_user_rol AS id_user_rol_26, t0.id_team AS id_team_27 FROM users t0 WHERE t0.email = 'gabriela.bracho@greenpatio.es' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.picture AS picture_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.movil_password AS movil_password_6,
  t0.pass_gmail AS pass_gmail_7,
  t0.firm_gmail AS firm_gmail_8,
  t0.name AS name_9,
  t0.last_name AS last_name_10,
  t0.telephone AS telephone_11,
  t0.mobile AS mobile_12,
  t0.status AS status_13,
  t0.team_leader AS team_leader_14,
  t0.role AS role_15,
  t0.access_key AS access_key_16,
  t0.language AS language_17,
  t0.color AS color_18,
  t0.sidebar AS sidebar_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.description AS description_22,
  t0.job_title AS job_title_23,
  t0.id_office AS id_office_24,
  t0.id_company AS id_company_25,
  t0.id_user_rol AS id_user_rol_26,
  t0.id_team AS id_team_27
FROM
  users t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.picture AS picture_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.movil_password AS movil_password_6, t0.pass_gmail AS pass_gmail_7, t0.firm_gmail AS firm_gmail_8, t0.name AS name_9, t0.last_name AS last_name_10, t0.telephone AS telephone_11, t0.mobile AS mobile_12, t0.status AS status_13, t0.team_leader AS team_leader_14, t0.role AS role_15, t0.access_key AS access_key_16, t0.language AS language_17, t0.color AS color_18, t0.sidebar AS sidebar_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.description AS description_22, t0.job_title AS job_title_23, t0.id_office AS id_office_24, t0.id_company AS id_company_25, t0.id_user_rol AS id_user_rol_26, t0.id_team AS id_team_27 FROM users t0 WHERE t0.email = 'gabriela.bracho@greenpatio.es' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.billing_series AS billing_series_3,
  t0.is_main AS is_main_4,
  t0.rectifying_billing_series AS rectifying_billing_series_5,
  t0.iva AS iva_6
FROM
  space t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.billing_series AS billing_series_3, t0.is_main AS is_main_4, t0.rectifying_billing_series AS rectifying_billing_series_5, t0.iva AS iva_6 FROM space t0 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.clientContact AS clientContact_3,
  t0.contactUnregistered AS contactUnregistered_4,
  t0.nameContactUnregistered AS nameContactUnregistered_5,
  t0.phoneContactUnregistered AS phoneContactUnregistered_6,
  t0.days AS days_7,
  t0.createdAt AS createdAt_8,
  t0.priority AS priority_9,
  t0.createdBy AS createdBy_10,
  t0.supplier AS supplier_11,
  t0.status AS status_12,
  t0.updatedAt AS updatedAt_13,
  t0.updatedBy AS updatedBy_14,
  t0.daysBlock AS daysBlock_15,
  t0.dateStart AS dateStart_16,
  t0.dateEnd AS dateEnd_17,
  t0.pax AS pax_18,
  t0.access_key AS access_key_19,
  t0.description AS description_20,
  t0.contract AS contract_21,
  t0.token AS token_22,
  t0.comAvGp AS comAvGp_23,
  t0.comHtGp AS comHtGp_24,
  t0.sucoe AS sucoe_25,
  t0.client_id AS client_id_26,
  t27.id AS id_28,
  t27.title AS title_29,
  t27.status AS status_30,
  t27.days_block AS days_block_31,
  t27.pax AS pax_32,
  t27.description AS description_33,
  t27.description_two AS description_two_34,
  t27.contact_unregistered AS contact_unregistered_35,
  t27.name_contact_unregistered AS name_contact_unregistered_36,
  t27.phone_contact_unregistered AS phone_contact_unregistered_37,
  t27.date_start AS date_start_38,
  t27.date_end AS date_end_39,
  t27.created_at AS created_at_40,
  t27.updated_at AS updated_at_41,
  t27.client_type AS client_type_42,
  t27.client_id AS client_id_43,
  t27.created_id_id AS created_id_id_44,
  t27.updated_id_id AS updated_id_id_45,
  t27.client_contact_id AS client_contact_id_46,
  t27.reservation_id AS reservation_id_47,
  t48.id AS id_49,
  t48.title AS title_50,
  t48.client AS client_51,
  t48.priority AS priority_52,
  t48.supplier AS supplier_53,
  t48.status AS status_54,
  t48.daysBlock AS daysBlock_55,
  t48.advancePayment AS advancePayment_56,
  t48.idProposal AS idProposal_57,
  t48.cateringName AS cateringName_58,
  t48.boolCatering AS boolCatering_59,
  t48.dateStart AS dateStart_60,
  t48.dateEnd AS dateEnd_61,
  t48.pax AS pax_62,
  t48.deposit AS deposit_63,
  t48.access_key AS access_key_64,
  t48.description AS description_65,
  t48.destinoId AS destinoId_66,
  t48.createdAt AS createdAt_67,
  t48.createdId AS createdId_68,
  t48.updatedAt AS updatedAt_69,
  t48.updatedId AS updatedId_70,
  t48.comments AS comments_71,
  t48.comments_in_inv AS comments_in_inv_72,
  t48.comments_in_pro AS comments_in_pro_73,
  t48.xtra_field_one AS xtra_field_one_74,
  t48.xtra_field_two AS xtra_field_two_75,
  t48.reservation_id AS reservation_id_76
FROM
  reservation t0
  LEFT JOIN ht_file t27 ON t27.reservation_id = t0.id
  LEFT JOIN ave_files t48 ON t48.reservation_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.clientContact AS clientContact_3, t0.contactUnregistered AS contactUnregistered_4, t0.nameContactUnregistered AS nameContactUnregistered_5, t0.phoneContactUnregistered AS phoneContactUnregistered_6, t0.days AS days_7, t0.createdAt AS createdAt_8, t0.priority AS priority_9, t0.createdBy AS createdBy_10, t0.supplier AS supplier_11, t0.status AS status_12, t0.updatedAt AS updatedAt_13, t0.updatedBy AS updatedBy_14, t0.daysBlock AS daysBlock_15, t0.dateStart AS dateStart_16, t0.dateEnd AS dateEnd_17, t0.pax AS pax_18, t0.access_key AS access_key_19, t0.description AS description_20, t0.contract AS contract_21, t0.token AS token_22, t0.comAvGp AS comAvGp_23, t0.comHtGp AS comHtGp_24, t0.sucoe AS sucoe_25, t0.client_id AS client_id_26, t27.id AS id_28, t27.title AS title_29, t27.status AS status_30, t27.days_block AS days_block_31, t27.pax AS pax_32, t27.description AS description_33, t27.description_two AS description_two_34, t27.contact_unregistered AS contact_unregistered_35, t27.name_contact_unregistered AS name_contact_unregistered_36, t27.phone_contact_unregistered AS phone_contact_unregistered_37, t27.date_start AS date_start_38, t27.date_end AS date_end_39, t27.created_at AS created_at_40, t27.updated_at AS updated_at_41, t27.client_type AS client_type_42, t27.client_id AS client_id_43, t27.created_id_id AS created_id_id_44, t27.updated_id_id AS updated_id_id_45, t27.client_contact_id AS client_contact_id_46, t27.reservation_id AS reservation_id_47, t48.id AS id_49, t48.title AS title_50, t48.client AS client_51, t48.priority AS priority_52, t48.supplier AS supplier_53, t48.status AS status_54, t48.daysBlock AS daysBlock_55, t48.advancePayment AS advancePayment_56, t48.idProposal AS idProposal_57, t48.cateringName AS cateringName_58, t48.boolCatering AS boolCatering_59, t48.dateStart AS dateStart_60, t48.dateEnd AS dateEnd_61, t48.pax AS pax_62, t48.deposit AS deposit_63, t48.access_key AS access_key_64, t48.description AS description_65, t48.destinoId AS destinoId_66, t48.createdAt AS createdAt_67, t48.createdId AS createdId_68, t48.updatedAt AS updatedAt_69, t48.updatedId AS updatedId_70, t48.comments AS comments_71, t48.comments_in_inv AS comments_in_inv_72, t48.comments_in_pro AS comments_in_pro_73, t48.xtra_field_one AS xtra_field_one_74, t48.xtra_field_two AS xtra_field_two_75, t48.reservation_id AS reservation_id_76 FROM reservation t0 LEFT JOIN ht_file t27 ON t27.reservation_id = t0.id LEFT JOIN ave_files t48 ON t48.reservation_id = t0.id WHERE t0.id = 15887;

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.created_at AS created_at_11,
  t0.created_id AS created_id_12,
  t0.updated_at AS updated_at_13,
  t0.updated_id AS updated_id_14,
  t0.picture AS picture_15,
  t0.token AS token_16,
  t0.sage_company AS sage_company_17,
  t0.sage_group AS sage_group_18,
  t0.comision AS comision_19,
  t0.priority AS priority_20,
  t0.business_type AS business_type_21,
  t0.state AS state_22,
  t0.supplier_id AS supplier_id_23
FROM
  settings_company t0
WHERE
  t0.business_type = ?
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.created_at AS created_at_11, t0.created_id AS created_id_12, t0.updated_at AS updated_at_13, t0.updated_id AS updated_id_14, t0.picture AS picture_15, t0.token AS token_16, t0.sage_company AS sage_company_17, t0.sage_group AS sage_group_18, t0.comision AS comision_19, t0.priority AS priority_20, t0.business_type AS business_type_21, t0.state AS state_22, t0.supplier_id AS supplier_id_23 FROM settings_company t0 WHERE t0.business_type = 'venues' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.reservationId AS reservationId_2,
  t0.isDone AS isDone_3,
  t0.description AS description_4,
  t0.amount AS amount_5,
  t0.date AS date_6,
  t0.created_id AS created_id_7,
  t0.created_at AS created_at_8,
  t0.updated_id AS updated_id_9,
  t0.updated_at AS updated_at_10,
  t0.proforma_deposit_id AS proforma_deposit_id_11
FROM
  reservation_deposit t0
WHERE
  t0.reservationId = ?
  AND t0.isDone = ?

SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.isDone AS isDone_3, t0.description AS description_4, t0.amount AS amount_5, t0.date AS date_6, t0.created_id AS created_id_7, t0.created_at AS created_at_8, t0.updated_id AS updated_id_9, t0.updated_at AS updated_at_10, t0.proforma_deposit_id AS proforma_deposit_id_11 FROM reservation_deposit t0 WHERE t0.reservationId = 15887 AND t0.isDone = 1;

SELECT
  t0.id AS id_1,
  t0.loungeName AS loungeName_2,
  t0.idLounge AS idLounge_3,
  t0.dateStart AS dateStart_4,
  t0.dateEnd AS dateEnd_5,
  t0.servicePrice AS servicePrice_6,
  t0.idReservation AS idReservation_7,
  t0.pax AS pax_8,
  t0.type AS type_9,
  t0.createdAt AS createdAt_10,
  t0.createdBy AS createdBy_11,
  t0.updatedAt AS updatedAt_12,
  t0.updatedBy AS updatedBy_13,
  t0.hourStart AS hourStart_14,
  t0.minStart AS minStart_15,
  t0.hourEnd AS hourEnd_16,
  t0.minEnd AS minEnd_17,
  t0.rankQuote AS rankQuote_18,
  t0.op_iva AS op_iva_19,
  t0.iva AS iva_20,
  t0.loungeDescription AS loungeDescription_21,
  t0.importantDescription AS importantDescription_22,
  t0.importantDescGeneralText AS importantDescGeneralText_23,
  t0.importantDescSchedules AS importantDescSchedules_24,
  t0.importantDescParking AS importantDescParking_25,
  t0.language AS language_26,
  t0.sent_to_sage AS sent_to_sage_27,
  t0.sage_iva AS sage_iva_28,
  t0.sage_article_id AS sage_article_id_29
FROM
  reservation_lounge_simple t0
WHERE
  t0.idReservation = ?

SELECT t0.id AS id_1, t0.loungeName AS loungeName_2, t0.idLounge AS idLounge_3, t0.dateStart AS dateStart_4, t0.dateEnd AS dateEnd_5, t0.servicePrice AS servicePrice_6, t0.idReservation AS idReservation_7, t0.pax AS pax_8, t0.type AS type_9, t0.createdAt AS createdAt_10, t0.createdBy AS createdBy_11, t0.updatedAt AS updatedAt_12, t0.updatedBy AS updatedBy_13, t0.hourStart AS hourStart_14, t0.minStart AS minStart_15, t0.hourEnd AS hourEnd_16, t0.minEnd AS minEnd_17, t0.rankQuote AS rankQuote_18, t0.op_iva AS op_iva_19, t0.iva AS iva_20, t0.loungeDescription AS loungeDescription_21, t0.importantDescription AS importantDescription_22, t0.importantDescGeneralText AS importantDescGeneralText_23, t0.importantDescSchedules AS importantDescSchedules_24, t0.importantDescParking AS importantDescParking_25, t0.language AS language_26, t0.sent_to_sage AS sent_to_sage_27, t0.sage_iva AS sage_iva_28, t0.sage_article_id AS sage_article_id_29 FROM reservation_lounge_simple t0 WHERE t0.idReservation = 15887;

SELECT
  t0.id AS id_1,
  t0.loungeName AS loungeName_2,
  t0.idLounge AS idLounge_3,
  t0.dateStart AS dateStart_4,
  t0.dateEnd AS dateEnd_5,
  t0.servicePrice AS servicePrice_6,
  t0.idReservation AS idReservation_7,
  t0.pax AS pax_8,
  t0.type AS type_9,
  t0.createdAt AS createdAt_10,
  t0.createdBy AS createdBy_11,
  t0.updatedAt AS updatedAt_12,
  t0.updatedBy AS updatedBy_13,
  t0.hourStart AS hourStart_14,
  t0.minStart AS minStart_15,
  t0.hourEnd AS hourEnd_16,
  t0.minEnd AS minEnd_17,
  t0.rankQuote AS rankQuote_18,
  t0.op_iva AS op_iva_19,
  t0.iva AS iva_20,
  t0.loungeDescription AS loungeDescription_21,
  t0.importantDescription AS importantDescription_22,
  t0.importantDescGeneralText AS importantDescGeneralText_23,
  t0.importantDescSchedules AS importantDescSchedules_24,
  t0.importantDescParking AS importantDescParking_25,
  t0.language AS language_26,
  t0.sent_to_sage AS sent_to_sage_27,
  t0.sage_iva AS sage_iva_28,
  t0.sage_article_id AS sage_article_id_29
FROM
  reservation_lounge_simple t0
WHERE
  t0.idReservation = ?

SELECT t0.id AS id_1, t0.loungeName AS loungeName_2, t0.idLounge AS idLounge_3, t0.dateStart AS dateStart_4, t0.dateEnd AS dateEnd_5, t0.servicePrice AS servicePrice_6, t0.idReservation AS idReservation_7, t0.pax AS pax_8, t0.type AS type_9, t0.createdAt AS createdAt_10, t0.createdBy AS createdBy_11, t0.updatedAt AS updatedAt_12, t0.updatedBy AS updatedBy_13, t0.hourStart AS hourStart_14, t0.minStart AS minStart_15, t0.hourEnd AS hourEnd_16, t0.minEnd AS minEnd_17, t0.rankQuote AS rankQuote_18, t0.op_iva AS op_iva_19, t0.iva AS iva_20, t0.loungeDescription AS loungeDescription_21, t0.importantDescription AS importantDescription_22, t0.importantDescGeneralText AS importantDescGeneralText_23, t0.importantDescSchedules AS importantDescSchedules_24, t0.importantDescParking AS importantDescParking_25, t0.language AS language_26, t0.sent_to_sage AS sent_to_sage_27, t0.sage_iva AS sage_iva_28, t0.sage_article_id AS sage_article_id_29 FROM reservation_lounge_simple t0 WHERE t0.idReservation = 15887;

SELECT
  t0.id AS id_1,
  t0.master AS master_2,
  t0.number AS number_3,
  t0.prefix AS prefix_4,
  t0.dateAt AS dateAt_5,
  t0.type AS type_6,
  t0.reservationId AS reservationId_7,
  t0.totalNet AS totalNet_8,
  t0.vat AS vat_9,
  t0.total AS total_10,
  t0.balance AS balance_11,
  t0.createdAt AS createdAt_12,
  t0.createdId AS createdId_13,
  t0.updatedAt AS updatedAt_14,
  t0.updatedId AS updatedId_15,
  t0.client_name AS client_name_16,
  t0.client_address AS client_address_17,
  t0.client_document AS client_document_18,
  t0.client_type AS client_type_19,
  t20.id AS id_21,
  t20.sage_delivery_number AS sage_delivery_number_22,
  t20.sage_invoice_number AS sage_invoice_number_23,
  t20.sage_almacen AS sage_almacen_24,
  t20.factured AS factured_25,
  t20.is_rectificative AS is_rectificative_26,
  t20.sent_to_sage AS sent_to_sage_27,
  t20.sync_date AS sync_date_28,
  t20.factured_at AS factured_at_29,
  t20.created_at AS created_at_30,
  t20.updated_at AS updated_at_31,
  t20.last_error AS last_error_32,
  t20.letter AS letter_33,
  t20.pdf AS pdf_34,
  t20.client_id AS client_id_35,
  t20.rectifies_id AS rectifies_id_36,
  t20.sage_company_id AS sage_company_id_37,
  t20.reservation_invoice_id AS reservation_invoice_id_38,
  t20.reservation_invoice_rec_id AS reservation_invoice_rec_id_39,
  t40.id AS id_41,
  t40.prefix AS prefix_42,
  t40.number AS number_43,
  t40.date_at AS date_at_44,
  t40.reservation_id AS reservation_id_45,
  t40.name AS name_46,
  t40.amount AS amount_47,
  t40.iva AS iva_48,
  t40.total AS total_49,
  t40.created_at AS created_at_50,
  t40.created_id AS created_id_51,
  t40.updated_at AS updated_at_52,
  t40.updated_id AS updated_id_53,
  t40.sage_iva AS sage_iva_54,
  t40.reservation_invoice_id AS reservation_invoice_id_55
FROM
  reservation_invoice t0
  LEFT JOIN delivery_note t20 ON t20.reservation_invoice_id = t0.id
  LEFT JOIN reservation_proforma_deposit t40 ON t40.reservation_invoice_id = t0.id
WHERE
  t0.reservationId = ?

SELECT t0.id AS id_1, t0.master AS master_2, t0.number AS number_3, t0.prefix AS prefix_4, t0.dateAt AS dateAt_5, t0.type AS type_6, t0.reservationId AS reservationId_7, t0.totalNet AS totalNet_8, t0.vat AS vat_9, t0.total AS total_10, t0.balance AS balance_11, t0.createdAt AS createdAt_12, t0.createdId AS createdId_13, t0.updatedAt AS updatedAt_14, t0.updatedId AS updatedId_15, t0.client_name AS client_name_16, t0.client_address AS client_address_17, t0.client_document AS client_document_18, t0.client_type AS client_type_19, t20.id AS id_21, t20.sage_delivery_number AS sage_delivery_number_22, t20.sage_invoice_number AS sage_invoice_number_23, t20.sage_almacen AS sage_almacen_24, t20.factured AS factured_25, t20.is_rectificative AS is_rectificative_26, t20.sent_to_sage AS sent_to_sage_27, t20.sync_date AS sync_date_28, t20.factured_at AS factured_at_29, t20.created_at AS created_at_30, t20.updated_at AS updated_at_31, t20.last_error AS last_error_32, t20.letter AS letter_33, t20.pdf AS pdf_34, t20.client_id AS client_id_35, t20.rectifies_id AS rectifies_id_36, t20.sage_company_id AS sage_company_id_37, t20.reservation_invoice_id AS reservation_invoice_id_38, t20.reservation_invoice_rec_id AS reservation_invoice_rec_id_39, t40.id AS id_41, t40.prefix AS prefix_42, t40.number AS number_43, t40.date_at AS date_at_44, t40.reservation_id AS reservation_id_45, t40.name AS name_46, t40.amount AS amount_47, t40.iva AS iva_48, t40.total AS total_49, t40.created_at AS created_at_50, t40.created_id AS created_id_51, t40.updated_at AS updated_at_52, t40.updated_id AS updated_id_53, t40.sage_iva AS sage_iva_54, t40.reservation_invoice_id AS reservation_invoice_id_55 FROM reservation_invoice t0 LEFT JOIN delivery_note t20 ON t20.reservation_invoice_id = t0.id LEFT JOIN reservation_proforma_deposit t40 ON t40.reservation_invoice_id = t0.id WHERE t0.reservationId = 15887;

SELECT
  t0.id AS id_1,
  t0.master AS master_2,
  t0.number AS number_3,
  t0.prefix AS prefix_4,
  t0.dateAt AS dateAt_5,
  t0.type AS type_6,
  t0.reservationId AS reservationId_7,
  t0.totalNet AS totalNet_8,
  t0.vat AS vat_9,
  t0.total AS total_10,
  t0.balance AS balance_11,
  t0.createdAt AS createdAt_12,
  t0.createdId AS createdId_13,
  t0.updatedAt AS updatedAt_14,
  t0.updatedId AS updatedId_15,
  t0.invoiceToRec AS invoiceToRec_16,
  t0.client_name AS client_name_17,
  t0.client_address AS client_address_18,
  t0.client_document AS client_document_19,
  t0.client_type AS client_type_20,
  t21.id AS id_22,
  t21.sage_delivery_number AS sage_delivery_number_23,
  t21.sage_invoice_number AS sage_invoice_number_24,
  t21.sage_almacen AS sage_almacen_25,
  t21.factured AS factured_26,
  t21.is_rectificative AS is_rectificative_27,
  t21.sent_to_sage AS sent_to_sage_28,
  t21.sync_date AS sync_date_29,
  t21.factured_at AS factured_at_30,
  t21.created_at AS created_at_31,
  t21.updated_at AS updated_at_32,
  t21.last_error AS last_error_33,
  t21.letter AS letter_34,
  t21.pdf AS pdf_35,
  t21.client_id AS client_id_36,
  t21.rectifies_id AS rectifies_id_37,
  t21.sage_company_id AS sage_company_id_38,
  t21.reservation_invoice_id AS reservation_invoice_id_39,
  t21.reservation_invoice_rec_id AS reservation_invoice_rec_id_40
FROM
  reservation_invoice_rec t0
  LEFT JOIN delivery_note t21 ON t21.reservation_invoice_rec_id = t0.id
WHERE
  t0.reservationId = ?

SELECT t0.id AS id_1, t0.master AS master_2, t0.number AS number_3, t0.prefix AS prefix_4, t0.dateAt AS dateAt_5, t0.type AS type_6, t0.reservationId AS reservationId_7, t0.totalNet AS totalNet_8, t0.vat AS vat_9, t0.total AS total_10, t0.balance AS balance_11, t0.createdAt AS createdAt_12, t0.createdId AS createdId_13, t0.updatedAt AS updatedAt_14, t0.updatedId AS updatedId_15, t0.invoiceToRec AS invoiceToRec_16, t0.client_name AS client_name_17, t0.client_address AS client_address_18, t0.client_document AS client_document_19, t0.client_type AS client_type_20, t21.id AS id_22, t21.sage_delivery_number AS sage_delivery_number_23, t21.sage_invoice_number AS sage_invoice_number_24, t21.sage_almacen AS sage_almacen_25, t21.factured AS factured_26, t21.is_rectificative AS is_rectificative_27, t21.sent_to_sage AS sent_to_sage_28, t21.sync_date AS sync_date_29, t21.factured_at AS factured_at_30, t21.created_at AS created_at_31, t21.updated_at AS updated_at_32, t21.last_error AS last_error_33, t21.letter AS letter_34, t21.pdf AS pdf_35, t21.client_id AS client_id_36, t21.rectifies_id AS rectifies_id_37, t21.sage_company_id AS sage_company_id_38, t21.reservation_invoice_id AS reservation_invoice_id_39, t21.reservation_invoice_rec_id AS reservation_invoice_rec_id_40 FROM reservation_invoice_rec t0 LEFT JOIN delivery_note t21 ON t21.reservation_invoice_rec_id = t0.id WHERE t0.reservationId = 15887;

SELECT
  t0.id AS id_1,
  t0.loungeName AS loungeName_2,
  t0.idLounge AS idLounge_3,
  t0.dateStart AS dateStart_4,
  t0.dateEnd AS dateEnd_5,
  t0.servicePrice AS servicePrice_6,
  t0.idReservation AS idReservation_7,
  t0.pax AS pax_8,
  t0.type AS type_9,
  t0.createdAt AS createdAt_10,
  t0.createdBy AS createdBy_11,
  t0.updatedAt AS updatedAt_12,
  t0.updatedBy AS updatedBy_13,
  t0.hourStart AS hourStart_14,
  t0.minStart AS minStart_15,
  t0.hourEnd AS hourEnd_16,
  t0.minEnd AS minEnd_17,
  t0.rankQuote AS rankQuote_18,
  t0.op_iva AS op_iva_19,
  t0.iva AS iva_20,
  t0.loungeDescription AS loungeDescription_21,
  t0.importantDescription AS importantDescription_22,
  t0.importantDescGeneralText AS importantDescGeneralText_23,
  t0.importantDescSchedules AS importantDescSchedules_24,
  t0.importantDescParking AS importantDescParking_25,
  t0.language AS language_26,
  t0.sent_to_sage AS sent_to_sage_27,
  t0.sage_iva AS sage_iva_28,
  t0.sage_article_id AS sage_article_id_29
FROM
  reservation_lounge_simple t0
WHERE
  t0.idReservation = ?

SELECT t0.id AS id_1, t0.loungeName AS loungeName_2, t0.idLounge AS idLounge_3, t0.dateStart AS dateStart_4, t0.dateEnd AS dateEnd_5, t0.servicePrice AS servicePrice_6, t0.idReservation AS idReservation_7, t0.pax AS pax_8, t0.type AS type_9, t0.createdAt AS createdAt_10, t0.createdBy AS createdBy_11, t0.updatedAt AS updatedAt_12, t0.updatedBy AS updatedBy_13, t0.hourStart AS hourStart_14, t0.minStart AS minStart_15, t0.hourEnd AS hourEnd_16, t0.minEnd AS minEnd_17, t0.rankQuote AS rankQuote_18, t0.op_iva AS op_iva_19, t0.iva AS iva_20, t0.loungeDescription AS loungeDescription_21, t0.importantDescription AS importantDescription_22, t0.importantDescGeneralText AS importantDescGeneralText_23, t0.importantDescSchedules AS importantDescSchedules_24, t0.importantDescParking AS importantDescParking_25, t0.language AS language_26, t0.sent_to_sage AS sent_to_sage_27, t0.sage_iva AS sage_iva_28, t0.sage_article_id AS sage_article_id_29 FROM reservation_lounge_simple t0 WHERE t0.idReservation = 15887;

SELECT
  t0.id AS id_1,
  t0.loungeName AS loungeName_2,
  t0.idLounge AS idLounge_3,
  t0.dateStart AS dateStart_4,
  t0.dateEnd AS dateEnd_5,
  t0.servicePrice AS servicePrice_6,
  t0.idReservation AS idReservation_7,
  t0.pax AS pax_8,
  t0.type AS type_9,
  t0.createdAt AS createdAt_10,
  t0.createdBy AS createdBy_11,
  t0.updatedAt AS updatedAt_12,
  t0.updatedBy AS updatedBy_13,
  t0.hourStart AS hourStart_14,
  t0.minStart AS minStart_15,
  t0.hourEnd AS hourEnd_16,
  t0.minEnd AS minEnd_17,
  t0.rankQuote AS rankQuote_18,
  t0.op_iva AS op_iva_19,
  t0.iva AS iva_20,
  t0.loungeDescription AS loungeDescription_21,
  t0.importantDescription AS importantDescription_22,
  t0.importantDescGeneralText AS importantDescGeneralText_23,
  t0.importantDescSchedules AS importantDescSchedules_24,
  t0.importantDescParking AS importantDescParking_25,
  t0.language AS language_26,
  t0.sent_to_sage AS sent_to_sage_27,
  t0.sage_iva AS sage_iva_28,
  t0.sage_article_id AS sage_article_id_29
FROM
  reservation_lounge_simple t0
WHERE
  t0.idReservation = ?

SELECT t0.id AS id_1, t0.loungeName AS loungeName_2, t0.idLounge AS idLounge_3, t0.dateStart AS dateStart_4, t0.dateEnd AS dateEnd_5, t0.servicePrice AS servicePrice_6, t0.idReservation AS idReservation_7, t0.pax AS pax_8, t0.type AS type_9, t0.createdAt AS createdAt_10, t0.createdBy AS createdBy_11, t0.updatedAt AS updatedAt_12, t0.updatedBy AS updatedBy_13, t0.hourStart AS hourStart_14, t0.minStart AS minStart_15, t0.hourEnd AS hourEnd_16, t0.minEnd AS minEnd_17, t0.rankQuote AS rankQuote_18, t0.op_iva AS op_iva_19, t0.iva AS iva_20, t0.loungeDescription AS loungeDescription_21, t0.importantDescription AS importantDescription_22, t0.importantDescGeneralText AS importantDescGeneralText_23, t0.importantDescSchedules AS importantDescSchedules_24, t0.importantDescParking AS importantDescParking_25, t0.language AS language_26, t0.sent_to_sage AS sent_to_sage_27, t0.sage_iva AS sage_iva_28, t0.sage_article_id AS sage_article_id_29 FROM reservation_lounge_simple t0 WHERE t0.idReservation = 15887;