Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.loungeName AS loungeName_2,
  t0.type AS type_3,
  t0.idLounge AS idLounge_4,
  t0.idPeriod AS idPeriod_5,
  t0.dateStart AS dateStart_6,
  t0.hourStart AS hourStart_7,
  t0.minStart AS minStart_8,
  t0.dateEnd AS dateEnd_9,
  t0.hourEnd AS hourEnd_10,
  t0.minEnd AS minEnd_11,
  t0.idService AS idService_12,
  t0.serviceName AS serviceName_13,
  t0.servicePrice AS servicePrice_14,
  t0.idReservation AS idReservation_15,
  t0.createdAt AS createdAt_16,
  t0.createdBy AS createdBy_17,
  t0.otherPriceSave AS otherPriceSave_18,
  t0.mounting AS mounting_19,
  t0.mountingLapse AS mountingLapse_20,
  t0.mountingDate AS mountingDate_21,
  t0.mountingHourStart AS mountingHourStart_22,
  t0.mountingMinStart AS mountingMinStart_23,
  t0.mountingHourEnd AS mountingHourEnd_24,
  t0.mountingMinEnd AS mountingMinEnd_25,
  t0.mountingPrice AS mountingPrice_26,
  t0.removalLapse AS removalLapse_27,
  t0.removalDate AS removalDate_28,
  t0.removalHourStart AS removalHourStart_29,
  t0.removalMinStart AS removalMinStart_30,
  t0.removalHourEnd AS removalHourEnd_31,
  t0.removalMinEnd AS removalMinEnd_32,
  t0.removalPrice AS removalPrice_33,
  t0.updatedAt AS updatedAt_34,
  t0.updatedBy AS updatedBy_35,
  t0.pax AS pax_36
FROM
  reservation_lounge t0
WHERE
  t0.idReservation = ?

SELECT t0.id AS id_1, t0.loungeName AS loungeName_2, t0.type AS type_3, t0.idLounge AS idLounge_4, t0.idPeriod AS idPeriod_5, t0.dateStart AS dateStart_6, t0.hourStart AS hourStart_7, t0.minStart AS minStart_8, t0.dateEnd AS dateEnd_9, t0.hourEnd AS hourEnd_10, t0.minEnd AS minEnd_11, t0.idService AS idService_12, t0.serviceName AS serviceName_13, t0.servicePrice AS servicePrice_14, t0.idReservation AS idReservation_15, t0.createdAt AS createdAt_16, t0.createdBy AS createdBy_17, t0.otherPriceSave AS otherPriceSave_18, t0.mounting AS mounting_19, t0.mountingLapse AS mountingLapse_20, t0.mountingDate AS mountingDate_21, t0.mountingHourStart AS mountingHourStart_22, t0.mountingMinStart AS mountingMinStart_23, t0.mountingHourEnd AS mountingHourEnd_24, t0.mountingMinEnd AS mountingMinEnd_25, t0.mountingPrice AS mountingPrice_26, t0.removalLapse AS removalLapse_27, t0.removalDate AS removalDate_28, t0.removalHourStart AS removalHourStart_29, t0.removalMinStart AS removalMinStart_30, t0.removalHourEnd AS removalHourEnd_31, t0.removalMinEnd AS removalMinEnd_32, t0.removalPrice AS removalPrice_33, t0.updatedAt AS updatedAt_34, t0.updatedBy AS updatedBy_35, t0.pax AS pax_36 FROM reservation_lounge t0 WHERE t0.idReservation = '11306';

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
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 FROM reservation_lounge_simple t0 WHERE t0.idReservation = '11306';

SELECT
  t0.id AS id_1,
  t0.reservationId AS reservationId_2,
  t0.supplierId AS supplierId_3,
  t0.serviceId AS serviceId_4,
  t0.serviceCatId AS serviceCatId_5,
  t0.serviceCatName AS serviceCatName_6,
  t0.name AS name_7,
  t0.price AS price_8,
  t0.currency AS currency_9,
  t0.units AS units_10,
  t0.opCommission AS opCommission_11,
  t0.commission AS commission_12,
  t0.opOver AS opOver_13,
  t0.price_over AS price_over_14,
  t0.opIva AS opIva_15,
  t0.iva AS iva_16,
  t0.pax AS pax_17,
  t0.hour AS hour_18,
  t0.dateInAt AS dateInAt_19,
  t0.dateOutAt AS dateOutAt_20,
  t0.contcolor AS contcolor_21,
  t0.`rank` AS rank_22,
  t0.assistantId AS assistantId_23,
  t0.activityId AS activityId_24,
  t0.pay AS pay_25,
  t0.createdAt AS createdAt_26,
  t0.createdId AS createdId_27,
  t0.updatedAt AS updatedAt_28,
  t0.updatedId AS updatedId_29,
  t0.toinvoice AS toinvoice_30,
  t0.viewInfo AS viewInfo_31,
  t32.id AS id_33,
  t32.lounge_other AS lounge_other_34,
  t32.date_start AS date_start_35,
  t32.hour_end AS hour_end_36,
  t32.gratitudes AS gratitudes_37,
  t32.created_at AS created_at_38,
  t32.updated_at AS updated_at_39,
  t32.pax AS pax_40,
  t32.observation AS observation_41,
  t32.type AS type_42,
  t32.reservation_service_id AS reservation_service_id_43,
  t32.lounge_gp_id AS lounge_gp_id_44,
  t32.created_id_id AS created_id_id_45,
  t32.updated_id_id AS updated_id_id_46,
  t32.ht_file_id AS ht_file_id_47
FROM
  reservation_service t0
  LEFT JOIN ht_item t32 ON t32.reservation_service_id = t0.id
WHERE
  t0.reservationId = ?

SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.supplierId AS supplierId_3, t0.serviceId AS serviceId_4, t0.serviceCatId AS serviceCatId_5, t0.serviceCatName AS serviceCatName_6, t0.name AS name_7, t0.price AS price_8, t0.currency AS currency_9, t0.units AS units_10, t0.opCommission AS opCommission_11, t0.commission AS commission_12, t0.opOver AS opOver_13, t0.price_over AS price_over_14, t0.opIva AS opIva_15, t0.iva AS iva_16, t0.pax AS pax_17, t0.hour AS hour_18, t0.dateInAt AS dateInAt_19, t0.dateOutAt AS dateOutAt_20, t0.contcolor AS contcolor_21, t0.`rank` AS rank_22, t0.assistantId AS assistantId_23, t0.activityId AS activityId_24, t0.pay AS pay_25, t0.createdAt AS createdAt_26, t0.createdId AS createdId_27, t0.updatedAt AS updatedAt_28, t0.updatedId AS updatedId_29, t0.toinvoice AS toinvoice_30, t0.viewInfo AS viewInfo_31, t32.id AS id_33, t32.lounge_other AS lounge_other_34, t32.date_start AS date_start_35, t32.hour_end AS hour_end_36, t32.gratitudes AS gratitudes_37, t32.created_at AS created_at_38, t32.updated_at AS updated_at_39, t32.pax AS pax_40, t32.observation AS observation_41, t32.type AS type_42, t32.reservation_service_id AS reservation_service_id_43, t32.lounge_gp_id AS lounge_gp_id_44, t32.created_id_id AS created_id_id_45, t32.updated_id_id AS updated_id_id_46, t32.ht_file_id AS ht_file_id_47 FROM reservation_service t0 LEFT JOIN ht_item t32 ON t32.reservation_service_id = t0.id WHERE t0.reservationId = '11306';

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,
  t31.id AS id_32,
  t31.title AS title_33,
  t31.status AS status_34,
  t31.days_block AS days_block_35,
  t31.pax AS pax_36,
  t31.description AS description_37,
  t31.description_two AS description_two_38,
  t31.contact_unregistered AS contact_unregistered_39,
  t31.name_contact_unregistered AS name_contact_unregistered_40,
  t31.phone_contact_unregistered AS phone_contact_unregistered_41,
  t31.date_start AS date_start_42,
  t31.date_end AS date_end_43,
  t31.created_at AS created_at_44,
  t31.updated_at AS updated_at_45,
  t31.client_type AS client_type_46,
  t31.client_id AS client_id_47,
  t31.proposal_id AS proposal_id_48,
  t31.created_id_id AS created_id_id_49,
  t31.updated_id_id AS updated_id_id_50,
  t31.client_contact_id AS client_contact_id_51,
  t31.reservation_id AS reservation_id_52
FROM
  reservation t0
  LEFT JOIN ht_file t31 ON t31.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, t31.id AS id_32, t31.title AS title_33, t31.status AS status_34, t31.days_block AS days_block_35, t31.pax AS pax_36, t31.description AS description_37, t31.description_two AS description_two_38, t31.contact_unregistered AS contact_unregistered_39, t31.name_contact_unregistered AS name_contact_unregistered_40, t31.phone_contact_unregistered AS phone_contact_unregistered_41, t31.date_start AS date_start_42, t31.date_end AS date_end_43, t31.created_at AS created_at_44, t31.updated_at AS updated_at_45, t31.client_type AS client_type_46, t31.client_id AS client_id_47, t31.proposal_id AS proposal_id_48, t31.created_id_id AS created_id_id_49, t31.updated_id_id AS updated_id_id_50, t31.client_contact_id AS client_contact_id_51, t31.reservation_id AS reservation_id_52 FROM reservation t0 LEFT JOIN ht_file t31 ON t31.reservation_id = t0.id WHERE t0.id = '11306' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.contractual_document AS contractual_document_2,
  t0.company_id AS company_id_3,
  t0.model_id AS model_id_4,
  t0.file_id AS file_id_5,
  t0.client_id AS client_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,
  t0.date_at AS date_at_11,
  t0.booking_data AS booking_data_12,
  t0.client_proxy AS client_proxy_13,
  t0.client_job AS client_job_14
FROM
  doc_contract t0
WHERE
  t0.model_id = ?
  AND t0.file_id = ?
  AND t0.company_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.contractual_document AS contractual_document_2, t0.company_id AS company_id_3, t0.model_id AS model_id_4, t0.file_id AS file_id_5, t0.client_id AS client_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, t0.date_at AS date_at_11, t0.booking_data AS booking_data_12, t0.client_proxy AS client_proxy_13, t0.client_job AS client_job_14 FROM doc_contract t0 WHERE t0.model_id = 17 AND t0.file_id = '11306' AND t0.company_id = 7 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,
  t31.id AS id_32,
  t31.title AS title_33,
  t31.status AS status_34,
  t31.days_block AS days_block_35,
  t31.pax AS pax_36,
  t31.description AS description_37,
  t31.description_two AS description_two_38,
  t31.contact_unregistered AS contact_unregistered_39,
  t31.name_contact_unregistered AS name_contact_unregistered_40,
  t31.phone_contact_unregistered AS phone_contact_unregistered_41,
  t31.date_start AS date_start_42,
  t31.date_end AS date_end_43,
  t31.created_at AS created_at_44,
  t31.updated_at AS updated_at_45,
  t31.client_type AS client_type_46,
  t31.client_id AS client_id_47,
  t31.proposal_id AS proposal_id_48,
  t31.created_id_id AS created_id_id_49,
  t31.updated_id_id AS updated_id_id_50,
  t31.client_contact_id AS client_contact_id_51,
  t31.reservation_id AS reservation_id_52
FROM
  reservation t0
  LEFT JOIN ht_file t31 ON t31.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, t31.id AS id_32, t31.title AS title_33, t31.status AS status_34, t31.days_block AS days_block_35, t31.pax AS pax_36, t31.description AS description_37, t31.description_two AS description_two_38, t31.contact_unregistered AS contact_unregistered_39, t31.name_contact_unregistered AS name_contact_unregistered_40, t31.phone_contact_unregistered AS phone_contact_unregistered_41, t31.date_start AS date_start_42, t31.date_end AS date_end_43, t31.created_at AS created_at_44, t31.updated_at AS updated_at_45, t31.client_type AS client_type_46, t31.client_id AS client_id_47, t31.proposal_id AS proposal_id_48, t31.created_id_id AS created_id_id_49, t31.updated_id_id AS updated_id_id_50, t31.client_contact_id AS client_contact_id_51, t31.reservation_id AS reservation_id_52 FROM reservation t0 LEFT JOIN ht_file t31 ON t31.reservation_id = t0.id WHERE t0.id = '11306' LIMIT 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
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 FROM reservation_lounge_simple t0 WHERE t0.idReservation = '11306';

SELECT
  t0.id AS id_1,
  t0.contractual_document AS contractual_document_2,
  t0.company_id AS company_id_3,
  t0.model_id AS model_id_4,
  t0.file_id AS file_id_5,
  t0.client_id AS client_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,
  t0.date_at AS date_at_11,
  t0.booking_data AS booking_data_12,
  t0.client_proxy AS client_proxy_13,
  t0.client_job AS client_job_14
FROM
  doc_contract t0
WHERE
  t0.company_id = ?
  AND t0.model_id = ?
  AND t0.file_id = ?

SELECT t0.id AS id_1, t0.contractual_document AS contractual_document_2, t0.company_id AS company_id_3, t0.model_id AS model_id_4, t0.file_id AS file_id_5, t0.client_id AS client_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, t0.date_at AS date_at_11, t0.booking_data AS booking_data_12, t0.client_proxy AS client_proxy_13, t0.client_job AS client_job_14 FROM doc_contract t0 WHERE t0.company_id = 7 AND t0.model_id = '17' AND t0.file_id = '11306';

SELECT
  t0.id AS id_1,
  t0.contractual_document AS contractual_document_2,
  t0.company_id AS company_id_3,
  t0.model_id AS model_id_4,
  t0.created_at AS created_at_5,
  t0.created_id AS created_id_6,
  t0.updated_at AS updated_at_7,
  t0.updated_id AS updated_id_8,
  t0.language AS language_9
FROM
  doc_contract_model t0
WHERE
  t0.company_id = ?
  AND t0.model_id = ?
  AND t0.language = ?

SELECT t0.id AS id_1, t0.contractual_document AS contractual_document_2, t0.company_id AS company_id_3, t0.model_id AS model_id_4, t0.created_at AS created_at_5, t0.created_id AS created_id_6, t0.updated_at AS updated_at_7, t0.updated_id AS updated_id_8, t0.language AS language_9 FROM doc_contract_model t0 WHERE t0.company_id = 7 AND t0.model_id = '17' AND t0.language = 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 = ?
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 = '4764' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.reservationId AS reservationId_2,
  t0.supplierId AS supplierId_3,
  t0.serviceId AS serviceId_4,
  t0.serviceCatId AS serviceCatId_5,
  t0.serviceCatName AS serviceCatName_6,
  t0.name AS name_7,
  t0.price AS price_8,
  t0.currency AS currency_9,
  t0.units AS units_10,
  t0.opCommission AS opCommission_11,
  t0.commission AS commission_12,
  t0.opOver AS opOver_13,
  t0.price_over AS price_over_14,
  t0.opIva AS opIva_15,
  t0.iva AS iva_16,
  t0.pax AS pax_17,
  t0.hour AS hour_18,
  t0.dateInAt AS dateInAt_19,
  t0.dateOutAt AS dateOutAt_20,
  t0.contcolor AS contcolor_21,
  t0.`rank` AS rank_22,
  t0.assistantId AS assistantId_23,
  t0.activityId AS activityId_24,
  t0.pay AS pay_25,
  t0.createdAt AS createdAt_26,
  t0.createdId AS createdId_27,
  t0.updatedAt AS updatedAt_28,
  t0.updatedId AS updatedId_29,
  t0.toinvoice AS toinvoice_30,
  t0.viewInfo AS viewInfo_31,
  t32.id AS id_33,
  t32.lounge_other AS lounge_other_34,
  t32.date_start AS date_start_35,
  t32.hour_end AS hour_end_36,
  t32.gratitudes AS gratitudes_37,
  t32.created_at AS created_at_38,
  t32.updated_at AS updated_at_39,
  t32.pax AS pax_40,
  t32.observation AS observation_41,
  t32.type AS type_42,
  t32.reservation_service_id AS reservation_service_id_43,
  t32.lounge_gp_id AS lounge_gp_id_44,
  t32.created_id_id AS created_id_id_45,
  t32.updated_id_id AS updated_id_id_46,
  t32.ht_file_id AS ht_file_id_47
FROM
  reservation_service t0
  LEFT JOIN ht_item t32 ON t32.reservation_service_id = t0.id
WHERE
  t0.reservationId = ?

SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.supplierId AS supplierId_3, t0.serviceId AS serviceId_4, t0.serviceCatId AS serviceCatId_5, t0.serviceCatName AS serviceCatName_6, t0.name AS name_7, t0.price AS price_8, t0.currency AS currency_9, t0.units AS units_10, t0.opCommission AS opCommission_11, t0.commission AS commission_12, t0.opOver AS opOver_13, t0.price_over AS price_over_14, t0.opIva AS opIva_15, t0.iva AS iva_16, t0.pax AS pax_17, t0.hour AS hour_18, t0.dateInAt AS dateInAt_19, t0.dateOutAt AS dateOutAt_20, t0.contcolor AS contcolor_21, t0.`rank` AS rank_22, t0.assistantId AS assistantId_23, t0.activityId AS activityId_24, t0.pay AS pay_25, t0.createdAt AS createdAt_26, t0.createdId AS createdId_27, t0.updatedAt AS updatedAt_28, t0.updatedId AS updatedId_29, t0.toinvoice AS toinvoice_30, t0.viewInfo AS viewInfo_31, t32.id AS id_33, t32.lounge_other AS lounge_other_34, t32.date_start AS date_start_35, t32.hour_end AS hour_end_36, t32.gratitudes AS gratitudes_37, t32.created_at AS created_at_38, t32.updated_at AS updated_at_39, t32.pax AS pax_40, t32.observation AS observation_41, t32.type AS type_42, t32.reservation_service_id AS reservation_service_id_43, t32.lounge_gp_id AS lounge_gp_id_44, t32.created_id_id AS created_id_id_45, t32.updated_id_id AS updated_id_id_46, t32.ht_file_id AS ht_file_id_47 FROM reservation_service t0 LEFT JOIN ht_item t32 ON t32.reservation_service_id = t0.id WHERE t0.reservationId = '11306';

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 = ?
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 = '4764' LIMIT 1;