Symfony Profiler

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
FROM
  reservation_invoice t0
WHERE
  t0.id = ?
LIMIT
  1

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 FROM reservation_invoice t0 WHERE t0.id = '1118' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.client AS client_3,
  t0.clientContact AS clientContact_4,
  t0.contactUnregistered AS contactUnregistered_5,
  t0.nameContactUnregistered AS nameContactUnregistered_6,
  t0.phoneContactUnregistered AS phoneContactUnregistered_7,
  t0.days AS days_8,
  t0.createdAt AS createdAt_9,
  t0.priority AS priority_10,
  t0.createdBy AS createdBy_11,
  t0.supplier AS supplier_12,
  t0.status AS status_13,
  t0.updatedAt AS updatedAt_14,
  t0.updatedBy AS updatedBy_15,
  t0.daysBlock AS daysBlock_16,
  t0.advancePayment AS advancePayment_17,
  t0.idProposal AS idProposal_18,
  t0.cateringName AS cateringName_19,
  t0.boolCatering AS boolCatering_20,
  t0.dateStart AS dateStart_21,
  t0.dateEnd AS dateEnd_22,
  t0.pax AS pax_23,
  t0.deposit AS deposit_24,
  t0.access_key AS access_key_25,
  t0.description AS description_26,
  t0.contract AS contract_27,
  t0.token AS token_28,
  t0.comAvGp AS comAvGp_29,
  t0.comHtGp AS comHtGp_30,
  t0.infoFormWeb AS infoFormWeb_31,
  t32.id AS id_33,
  t32.title AS title_34,
  t32.status AS status_35,
  t32.days_block AS days_block_36,
  t32.pax AS pax_37,
  t32.description AS description_38,
  t32.description_two AS description_two_39,
  t32.contact_unregistered AS contact_unregistered_40,
  t32.name_contact_unregistered AS name_contact_unregistered_41,
  t32.phone_contact_unregistered AS phone_contact_unregistered_42,
  t32.date_start AS date_start_43,
  t32.date_end AS date_end_44,
  t32.created_at AS created_at_45,
  t32.updated_at AS updated_at_46,
  t32.client_type AS client_type_47,
  t32.client_id AS client_id_48,
  t32.proposal_id AS proposal_id_49,
  t32.created_id_id AS created_id_id_50,
  t32.updated_id_id AS updated_id_id_51,
  t32.client_contact_id AS client_contact_id_52,
  t32.reservation_id AS reservation_id_53
FROM
  reservation t0
  LEFT JOIN ht_file t32 ON t32.reservation_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.client AS client_3, t0.clientContact AS clientContact_4, t0.contactUnregistered AS contactUnregistered_5, t0.nameContactUnregistered AS nameContactUnregistered_6, t0.phoneContactUnregistered AS phoneContactUnregistered_7, t0.days AS days_8, t0.createdAt AS createdAt_9, t0.priority AS priority_10, t0.createdBy AS createdBy_11, t0.supplier AS supplier_12, t0.status AS status_13, t0.updatedAt AS updatedAt_14, t0.updatedBy AS updatedBy_15, t0.daysBlock AS daysBlock_16, t0.advancePayment AS advancePayment_17, t0.idProposal AS idProposal_18, t0.cateringName AS cateringName_19, t0.boolCatering AS boolCatering_20, t0.dateStart AS dateStart_21, t0.dateEnd AS dateEnd_22, t0.pax AS pax_23, t0.deposit AS deposit_24, t0.access_key AS access_key_25, t0.description AS description_26, t0.contract AS contract_27, t0.token AS token_28, t0.comAvGp AS comAvGp_29, t0.comHtGp AS comHtGp_30, t0.infoFormWeb AS infoFormWeb_31, t32.id AS id_33, t32.title AS title_34, t32.status AS status_35, t32.days_block AS days_block_36, t32.pax AS pax_37, t32.description AS description_38, t32.description_two AS description_two_39, t32.contact_unregistered AS contact_unregistered_40, t32.name_contact_unregistered AS name_contact_unregistered_41, t32.phone_contact_unregistered AS phone_contact_unregistered_42, t32.date_start AS date_start_43, t32.date_end AS date_end_44, t32.created_at AS created_at_45, t32.updated_at AS updated_at_46, t32.client_type AS client_type_47, t32.client_id AS client_id_48, t32.proposal_id AS proposal_id_49, t32.created_id_id AS created_id_id_50, t32.updated_id_id AS updated_id_id_51, t32.client_contact_id AS client_contact_id_52, t32.reservation_id AS reservation_id_53 FROM reservation t0 LEFT JOIN ht_file t32 ON t32.reservation_id = t0.id WHERE t0.id = 11708 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.reservationId AS reservationId_2,
  t0.invoiceId AS invoiceId_3,
  t0.itemType AS itemType_4,
  t0.lngControlId AS lngControlId_5,
  t0.lngLoungeName AS lngLoungeName_6,
  t0.lngIdLounge AS lngIdLounge_7,
  t0.lngDateStart AS lngDateStart_8,
  t0.lngDateEnd AS lngDateEnd_9,
  t0.lngServicePrice AS lngServicePrice_10,
  t0.lngPax AS lngPax_11,
  t0.lngType AS lngType_12,
  t0.lngHourStart AS lngHourStart_13,
  t0.lngMinStart AS lngMinStart_14,
  t0.lngHourEnd AS lngHourEnd_15,
  t0.lngMinEnd AS lngMinEnd_16,
  t0.lng_op_iva AS lng_op_iva_17,
  t0.lng_iva AS lng_iva_18,
  t0.srvControlId AS srvControlId_19,
  t0.srvSupplierId AS srvSupplierId_20,
  t0.srvServiceId AS srvServiceId_21,
  t0.srvServiceCatId AS srvServiceCatId_22,
  t0.srvServiceCatName AS srvServiceCatName_23,
  t0.srvName AS srvName_24,
  t0.srvPrice AS srvPrice_25,
  t0.srvCurrency AS srvCurrency_26,
  t0.srvUnits AS srvUnits_27,
  t0.srvOpCommission AS srvOpCommission_28,
  t0.srvCommission AS srvCommission_29,
  t0.srvOpOver AS srvOpOver_30,
  t0.srvOver AS srvOver_31,
  t0.srvOpIva AS srvOpIva_32,
  t0.srvIva AS srvIva_33,
  t0.srvPax AS srvPax_34,
  t0.srvHour AS srvHour_35,
  t0.srvDateInAt AS srvDateInAt_36,
  t0.srvDateOutAt AS srvDateOutAt_37,
  t0.srvContcolor AS srvContcolor_38,
  t0.srvRank AS srvRank_39,
  t0.srvAssistantId AS srvAssistantId_40,
  t0.srvActivityId AS srvActivityId_41,
  t0.srvPay AS srvPay_42,
  t0.payControlId AS payControlId_43,
  t0.payAmount AS payAmount_44,
  t0.payDatePayAt AS payDatePayAt_45,
  t0.payWayToPay AS payWayToPay_46,
  t0.payVat AS payVat_47,
  t0.payAmountTotal AS payAmountTotal_48,
  t0.createdAt AS createdAt_49,
  t0.createdId AS createdId_50,
  t0.updatedAt AS updatedAt_51,
  t0.updatedId AS updatedId_52
FROM
  reservation_invoice_items t0
WHERE
  t0.reservationId = ?
  AND t0.invoiceId = ?

SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.invoiceId AS invoiceId_3, t0.itemType AS itemType_4, t0.lngControlId AS lngControlId_5, t0.lngLoungeName AS lngLoungeName_6, t0.lngIdLounge AS lngIdLounge_7, t0.lngDateStart AS lngDateStart_8, t0.lngDateEnd AS lngDateEnd_9, t0.lngServicePrice AS lngServicePrice_10, t0.lngPax AS lngPax_11, t0.lngType AS lngType_12, t0.lngHourStart AS lngHourStart_13, t0.lngMinStart AS lngMinStart_14, t0.lngHourEnd AS lngHourEnd_15, t0.lngMinEnd AS lngMinEnd_16, t0.lng_op_iva AS lng_op_iva_17, t0.lng_iva AS lng_iva_18, t0.srvControlId AS srvControlId_19, t0.srvSupplierId AS srvSupplierId_20, t0.srvServiceId AS srvServiceId_21, t0.srvServiceCatId AS srvServiceCatId_22, t0.srvServiceCatName AS srvServiceCatName_23, t0.srvName AS srvName_24, t0.srvPrice AS srvPrice_25, t0.srvCurrency AS srvCurrency_26, t0.srvUnits AS srvUnits_27, t0.srvOpCommission AS srvOpCommission_28, t0.srvCommission AS srvCommission_29, t0.srvOpOver AS srvOpOver_30, t0.srvOver AS srvOver_31, t0.srvOpIva AS srvOpIva_32, t0.srvIva AS srvIva_33, t0.srvPax AS srvPax_34, t0.srvHour AS srvHour_35, t0.srvDateInAt AS srvDateInAt_36, t0.srvDateOutAt AS srvDateOutAt_37, t0.srvContcolor AS srvContcolor_38, t0.srvRank AS srvRank_39, t0.srvAssistantId AS srvAssistantId_40, t0.srvActivityId AS srvActivityId_41, t0.srvPay AS srvPay_42, t0.payControlId AS payControlId_43, t0.payAmount AS payAmount_44, t0.payDatePayAt AS payDatePayAt_45, t0.payWayToPay AS payWayToPay_46, t0.payVat AS payVat_47, t0.payAmountTotal AS payAmountTotal_48, t0.createdAt AS createdAt_49, t0.createdId AS createdId_50, t0.updatedAt AS updatedAt_51, t0.updatedId AS updatedId_52 FROM reservation_invoice_items t0 WHERE t0.reservationId = 11708 AND t0.invoiceId = '1118';

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.priority = ?
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.priority = '2' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.name AS name_3,
  t0.title AS title_4,
  t0.address AS address_5,
  t0.address_number AS address_number_6,
  t0.zip_code AS zip_code_7,
  t0.population AS population_8,
  t0.province AS province_9,
  t0.region AS region_10,
  t0.country AS country_11,
  t0.telephone AS telephone_12,
  t0.fax AS fax_13,
  t0.email AS email_14,
  t0.gds AS gds_15,
  t0.type_document AS type_document_16,
  t0.id_document AS id_document_17,
  t0.observation AS observation_18,
  t0.id_office AS id_office_19,
  t0.created_at AS created_at_20,
  t0.created_id AS created_id_21,
  t0.updated_at AS updated_at_22,
  t0.updated_id AS updated_id_23,
  t0.status AS status_24,
  t0.picture AS picture_25,
  t0.group_id AS group_id_26,
  t0.competency AS competency_27,
  t0.action AS action_28,
  t0.return_investment AS return_investment_29,
  t0.is_client_in_out AS is_client_in_out_30,
  t0.is_client_green_patio AS is_client_green_patio_31,
  t0.is_client_av_express AS is_client_av_express_32,
  t0.is_client_develup AS is_client_develup_33,
  t0.typology AS typology_34
FROM
  clients t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.title AS title_4, t0.address AS address_5, t0.address_number AS address_number_6, t0.zip_code AS zip_code_7, t0.population AS population_8, t0.province AS province_9, t0.region AS region_10, t0.country AS country_11, t0.telephone AS telephone_12, t0.fax AS fax_13, t0.email AS email_14, t0.gds AS gds_15, t0.type_document AS type_document_16, t0.id_document AS id_document_17, t0.observation AS observation_18, t0.id_office AS id_office_19, t0.created_at AS created_at_20, t0.created_id AS created_id_21, t0.updated_at AS updated_at_22, t0.updated_id AS updated_id_23, t0.status AS status_24, t0.picture AS picture_25, t0.group_id AS group_id_26, t0.competency AS competency_27, t0.action AS action_28, t0.return_investment AS return_investment_29, t0.is_client_in_out AS is_client_in_out_30, t0.is_client_green_patio AS is_client_green_patio_31, t0.is_client_av_express AS is_client_av_express_32, t0.is_client_develup AS is_client_develup_33, t0.typology AS typology_34 FROM clients t0 WHERE t0.id = '4888';

SELECT
  t0.id AS id_1,
  t0.region_id AS region_id_2,
  t0.country_id AS country_id_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.name AS name_6,
  t0.province_id AS province_id_7,
  t0.zipcode AS zipcode_8
FROM
  cities t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.region_id AS region_id_2, t0.country_id AS country_id_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.name AS name_6, t0.province_id AS province_id_7, t0.zipcode AS zipcode_8 FROM cities t0 WHERE t0.id = '713549' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.country_id AS country_id_4
FROM
  regions t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.country_id AS country_id_4 FROM regions t0 WHERE t0.id = '969' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3
FROM
  countries t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM countries t0 WHERE t0.id = '62' LIMIT 1;

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
FROM
  reservation_invoice t0
WHERE
  t0.id = ?
LIMIT
  1

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 FROM reservation_invoice t0 WHERE t0.id = '1118' LIMIT 1;

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
FROM
  reservation_invoice_rec t0
WHERE
  t0.invoiceToRec = ?
LIMIT
  1

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 FROM reservation_invoice_rec t0 WHERE t0.invoiceToRec = '1118' LIMIT 1;

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
FROM
  reservation_invoice t0
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 FROM reservation_invoice t0 WHERE t0.reservationId = 11708;

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
FROM
  reservation_invoice_rec t0
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 FROM reservation_invoice_rec t0 WHERE t0.reservationId = 11708;

SELECT
  t0.id AS id_1,
  t0.prefix AS prefix_2,
  t0.dateAt AS dateAt_3,
  t0.reservationId AS reservationId_4,
  t0.createdAt AS createdAt_5,
  t0.createdId AS createdId_6,
  t0.updatedAt AS updatedAt_7,
  t0.updatedId AS updatedId_8,
  t0.items AS items_9,
  t0.accessKey AS accessKey_10
FROM
  reservation_proforma t0
WHERE
  t0.reservationId = ?

SELECT t0.id AS id_1, t0.prefix AS prefix_2, t0.dateAt AS dateAt_3, t0.reservationId AS reservationId_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8, t0.items AS items_9, t0.accessKey AS accessKey_10 FROM reservation_proforma t0 WHERE t0.reservationId = 11708;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.client AS client_3,
  t0.clientContact AS clientContact_4,
  t0.contactUnregistered AS contactUnregistered_5,
  t0.nameContactUnregistered AS nameContactUnregistered_6,
  t0.phoneContactUnregistered AS phoneContactUnregistered_7,
  t0.days AS days_8,
  t0.createdAt AS createdAt_9,
  t0.priority AS priority_10,
  t0.createdBy AS createdBy_11,
  t0.supplier AS supplier_12,
  t0.status AS status_13,
  t0.updatedAt AS updatedAt_14,
  t0.updatedBy AS updatedBy_15,
  t0.daysBlock AS daysBlock_16,
  t0.advancePayment AS advancePayment_17,
  t0.idProposal AS idProposal_18,
  t0.cateringName AS cateringName_19,
  t0.boolCatering AS boolCatering_20,
  t0.dateStart AS dateStart_21,
  t0.dateEnd AS dateEnd_22,
  t0.pax AS pax_23,
  t0.deposit AS deposit_24,
  t0.access_key AS access_key_25,
  t0.description AS description_26,
  t0.contract AS contract_27,
  t0.token AS token_28,
  t0.comAvGp AS comAvGp_29,
  t0.comHtGp AS comHtGp_30,
  t0.infoFormWeb AS infoFormWeb_31,
  t32.id AS id_33,
  t32.title AS title_34,
  t32.status AS status_35,
  t32.days_block AS days_block_36,
  t32.pax AS pax_37,
  t32.description AS description_38,
  t32.description_two AS description_two_39,
  t32.contact_unregistered AS contact_unregistered_40,
  t32.name_contact_unregistered AS name_contact_unregistered_41,
  t32.phone_contact_unregistered AS phone_contact_unregistered_42,
  t32.date_start AS date_start_43,
  t32.date_end AS date_end_44,
  t32.created_at AS created_at_45,
  t32.updated_at AS updated_at_46,
  t32.client_type AS client_type_47,
  t32.client_id AS client_id_48,
  t32.proposal_id AS proposal_id_49,
  t32.created_id_id AS created_id_id_50,
  t32.updated_id_id AS updated_id_id_51,
  t32.client_contact_id AS client_contact_id_52,
  t32.reservation_id AS reservation_id_53
FROM
  reservation t0
  LEFT JOIN ht_file t32 ON t32.reservation_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.client AS client_3, t0.clientContact AS clientContact_4, t0.contactUnregistered AS contactUnregistered_5, t0.nameContactUnregistered AS nameContactUnregistered_6, t0.phoneContactUnregistered AS phoneContactUnregistered_7, t0.days AS days_8, t0.createdAt AS createdAt_9, t0.priority AS priority_10, t0.createdBy AS createdBy_11, t0.supplier AS supplier_12, t0.status AS status_13, t0.updatedAt AS updatedAt_14, t0.updatedBy AS updatedBy_15, t0.daysBlock AS daysBlock_16, t0.advancePayment AS advancePayment_17, t0.idProposal AS idProposal_18, t0.cateringName AS cateringName_19, t0.boolCatering AS boolCatering_20, t0.dateStart AS dateStart_21, t0.dateEnd AS dateEnd_22, t0.pax AS pax_23, t0.deposit AS deposit_24, t0.access_key AS access_key_25, t0.description AS description_26, t0.contract AS contract_27, t0.token AS token_28, t0.comAvGp AS comAvGp_29, t0.comHtGp AS comHtGp_30, t0.infoFormWeb AS infoFormWeb_31, t32.id AS id_33, t32.title AS title_34, t32.status AS status_35, t32.days_block AS days_block_36, t32.pax AS pax_37, t32.description AS description_38, t32.description_two AS description_two_39, t32.contact_unregistered AS contact_unregistered_40, t32.name_contact_unregistered AS name_contact_unregistered_41, t32.phone_contact_unregistered AS phone_contact_unregistered_42, t32.date_start AS date_start_43, t32.date_end AS date_end_44, t32.created_at AS created_at_45, t32.updated_at AS updated_at_46, t32.client_type AS client_type_47, t32.client_id AS client_id_48, t32.proposal_id AS proposal_id_49, t32.created_id_id AS created_id_id_50, t32.updated_id_id AS updated_id_id_51, t32.client_contact_id AS client_contact_id_52, t32.reservation_id AS reservation_id_53 FROM reservation t0 LEFT JOIN ht_file t32 ON t32.reservation_id = t0.id WHERE t0.id = 11708 LIMIT 1;