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.id_office AS id_office_13,
  t0.status AS status_14,
  t0.id_company AS id_company_15,
  t0.id_user_rol AS id_user_rol_16,
  t0.id_team AS id_team_17,
  t0.team_leader AS team_leader_18,
  t0.role AS role_19,
  t0.access_key AS access_key_20,
  t0.language AS language_21,
  t0.color AS color_22,
  t0.vacations AS vacations_23,
  t0.half_days AS half_days_24,
  t0.sidebar AS sidebar_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.description AS description_28,
  t0.job_title AS job_title_29
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.id_office AS id_office_13, t0.status AS status_14, t0.id_company AS id_company_15, t0.id_user_rol AS id_user_rol_16, t0.id_team AS id_team_17, t0.team_leader AS team_leader_18, t0.role AS role_19, t0.access_key AS access_key_20, t0.language AS language_21, t0.color AS color_22, t0.vacations AS vacations_23, t0.half_days AS half_days_24, t0.sidebar AS sidebar_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.description AS description_28, t0.job_title AS job_title_29 FROM users t0 WHERE t0.email = 'maria.martinez@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.id_office AS id_office_13,
  t0.status AS status_14,
  t0.id_company AS id_company_15,
  t0.id_user_rol AS id_user_rol_16,
  t0.id_team AS id_team_17,
  t0.team_leader AS team_leader_18,
  t0.role AS role_19,
  t0.access_key AS access_key_20,
  t0.language AS language_21,
  t0.color AS color_22,
  t0.vacations AS vacations_23,
  t0.half_days AS half_days_24,
  t0.sidebar AS sidebar_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.description AS description_28,
  t0.job_title AS job_title_29
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.id_office AS id_office_13, t0.status AS status_14, t0.id_company AS id_company_15, t0.id_user_rol AS id_user_rol_16, t0.id_team AS id_team_17, t0.team_leader AS team_leader_18, t0.role AS role_19, t0.access_key AS access_key_20, t0.language AS language_21, t0.color AS color_22, t0.vacations AS vacations_23, t0.half_days AS half_days_24, t0.sidebar AS sidebar_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.description AS description_28, t0.job_title AS job_title_29 FROM users t0 WHERE t0.email = 'maria.martinez@greenpatio.es' 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,
  t29.id AS id_30,
  t29.title AS title_31,
  t29.status AS status_32,
  t29.days_block AS days_block_33,
  t29.pax AS pax_34,
  t29.description AS description_35,
  t29.description_two AS description_two_36,
  t29.contact_unregistered AS contact_unregistered_37,
  t29.name_contact_unregistered AS name_contact_unregistered_38,
  t29.phone_contact_unregistered AS phone_contact_unregistered_39,
  t29.date_start AS date_start_40,
  t29.date_end AS date_end_41,
  t29.created_at AS created_at_42,
  t29.updated_at AS updated_at_43,
  t29.client_id AS client_id_44,
  t29.proposal_id AS proposal_id_45,
  t29.created_id_id AS created_id_id_46,
  t29.updated_id_id AS updated_id_id_47,
  t29.client_contact_id AS client_contact_id_48,
  t29.reservation_id AS reservation_id_49
FROM
  reservation t0
  LEFT JOIN ht_file t29 ON t29.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, t29.id AS id_30, t29.title AS title_31, t29.status AS status_32, t29.days_block AS days_block_33, t29.pax AS pax_34, t29.description AS description_35, t29.description_two AS description_two_36, t29.contact_unregistered AS contact_unregistered_37, t29.name_contact_unregistered AS name_contact_unregistered_38, t29.phone_contact_unregistered AS phone_contact_unregistered_39, t29.date_start AS date_start_40, t29.date_end AS date_end_41, t29.created_at AS created_at_42, t29.updated_at AS updated_at_43, t29.client_id AS client_id_44, t29.proposal_id AS proposal_id_45, t29.created_id_id AS created_id_id_46, t29.updated_id_id AS updated_id_id_47, t29.client_contact_id AS client_contact_id_48, t29.reservation_id AS reservation_id_49 FROM reservation t0 LEFT JOIN ht_file t29 ON t29.reservation_id = t0.id WHERE t0.id = '10487' 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
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 FROM reservation_lounge_simple t0 WHERE t0.idReservation = '10487';

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,
  t31.id AS id_32,
  t31.lounge_other AS lounge_other_33,
  t31.date_start AS date_start_34,
  t31.hour_end AS hour_end_35,
  t31.gratitudes AS gratitudes_36,
  t31.created_at AS created_at_37,
  t31.updated_at AS updated_at_38,
  t31.pax AS pax_39,
  t31.observation AS observation_40,
  t31.type AS type_41,
  t31.reservation_service_id AS reservation_service_id_42,
  t31.lounge_gp_id AS lounge_gp_id_43,
  t31.created_id_id AS created_id_id_44,
  t31.updated_id_id AS updated_id_id_45,
  t31.ht_file_id AS ht_file_id_46
FROM
  reservation_service t0
  LEFT JOIN ht_item t31 ON t31.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, t31.id AS id_32, t31.lounge_other AS lounge_other_33, t31.date_start AS date_start_34, t31.hour_end AS hour_end_35, t31.gratitudes AS gratitudes_36, t31.created_at AS created_at_37, t31.updated_at AS updated_at_38, t31.pax AS pax_39, t31.observation AS observation_40, t31.type AS type_41, t31.reservation_service_id AS reservation_service_id_42, t31.lounge_gp_id AS lounge_gp_id_43, t31.created_id_id AS created_id_id_44, t31.updated_id_id AS updated_id_id_45, t31.ht_file_id AS ht_file_id_46 FROM reservation_service t0 LEFT JOIN ht_item t31 ON t31.reservation_service_id = t0.id WHERE t0.reservationId = '10487';

SELECT
  r0_.id AS id_0,
  r0_.title AS title_1,
  r0_.client AS client_2,
  r0_.clientContact AS clientContact_3,
  r0_.contactUnregistered AS contactUnregistered_4,
  r0_.nameContactUnregistered AS nameContactUnregistered_5,
  r0_.phoneContactUnregistered AS phoneContactUnregistered_6,
  r0_.days AS days_7,
  r0_.createdAt AS createdAt_8,
  r0_.priority AS priority_9,
  r0_.createdBy AS createdBy_10,
  r0_.supplier AS supplier_11,
  r0_.status AS status_12,
  r0_.updatedAt AS updatedAt_13,
  r0_.updatedBy AS updatedBy_14,
  r0_.daysBlock AS daysBlock_15,
  r0_.advancePayment AS advancePayment_16,
  r0_.idProposal AS idProposal_17,
  r0_.cateringName AS cateringName_18,
  r0_.boolCatering AS boolCatering_19,
  r0_.dateStart AS dateStart_20,
  r0_.dateEnd AS dateEnd_21,
  r0_.pax AS pax_22,
  r0_.deposit AS deposit_23,
  r0_.access_key AS access_key_24,
  r0_.description AS description_25,
  r0_.contract AS contract_26,
  r0_.token AS token_27
FROM
  reservation r0_
  INNER JOIN reservation_lounge_simple r1_ ON (r0_.id = r1_.idReservation)
WHERE
  (
    r0_.status = ?
    OR r0_.status = ?
  )
  AND (
    NOT (r0_.id = ?)
  )
  AND (
    (
      r1_.dateStart >= ?
      AND r1_.dateStart <= ?
    )
  )

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.client AS client_2, r0_.clientContact AS clientContact_3, r0_.contactUnregistered AS contactUnregistered_4, r0_.nameContactUnregistered AS nameContactUnregistered_5, r0_.phoneContactUnregistered AS phoneContactUnregistered_6, r0_.days AS days_7, r0_.createdAt AS createdAt_8, r0_.priority AS priority_9, r0_.createdBy AS createdBy_10, r0_.supplier AS supplier_11, r0_.status AS status_12, r0_.updatedAt AS updatedAt_13, r0_.updatedBy AS updatedBy_14, r0_.daysBlock AS daysBlock_15, r0_.advancePayment AS advancePayment_16, r0_.idProposal AS idProposal_17, r0_.cateringName AS cateringName_18, r0_.boolCatering AS boolCatering_19, r0_.dateStart AS dateStart_20, r0_.dateEnd AS dateEnd_21, r0_.pax AS pax_22, r0_.deposit AS deposit_23, r0_.access_key AS access_key_24, r0_.description AS description_25, r0_.contract AS contract_26, r0_.token AS token_27 FROM reservation r0_ INNER JOIN reservation_lounge_simple r1_ ON (r0_.id = r1_.idReservation) WHERE (r0_.status = 'Invoiced' OR r0_.status = 'Confirmed') AND (NOT (r0_.id = '10487')) AND ((r1_.dateStart >= '2024-12-02 00:00:00' AND r1_.dateStart <= '2024-12-04 23:59:00'));

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.status AS status_3,
  t0.days_block AS days_block_4,
  t0.pax AS pax_5,
  t0.description AS description_6,
  t0.description_two AS description_two_7,
  t0.contact_unregistered AS contact_unregistered_8,
  t0.name_contact_unregistered AS name_contact_unregistered_9,
  t0.phone_contact_unregistered AS phone_contact_unregistered_10,
  t0.date_start AS date_start_11,
  t0.date_end AS date_end_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.client_id AS client_id_15,
  t0.proposal_id AS proposal_id_16,
  t0.created_id_id AS created_id_id_17,
  t0.updated_id_id AS updated_id_id_18,
  t0.client_contact_id AS client_contact_id_19,
  t0.reservation_id AS reservation_id_20
FROM
  ht_file t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.status AS status_3, t0.days_block AS days_block_4, t0.pax AS pax_5, t0.description AS description_6, t0.description_two AS description_two_7, t0.contact_unregistered AS contact_unregistered_8, t0.name_contact_unregistered AS name_contact_unregistered_9, t0.phone_contact_unregistered AS phone_contact_unregistered_10, t0.date_start AS date_start_11, t0.date_end AS date_end_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.client_id AS client_id_15, t0.proposal_id AS proposal_id_16, t0.created_id_id AS created_id_id_17, t0.updated_id_id AS updated_id_id_18, t0.client_contact_id AS client_contact_id_19, t0.reservation_id AS reservation_id_20 FROM ht_file t0 WHERE t0.reservation_id = 10001;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.status AS status_3,
  t0.days_block AS days_block_4,
  t0.pax AS pax_5,
  t0.description AS description_6,
  t0.description_two AS description_two_7,
  t0.contact_unregistered AS contact_unregistered_8,
  t0.name_contact_unregistered AS name_contact_unregistered_9,
  t0.phone_contact_unregistered AS phone_contact_unregistered_10,
  t0.date_start AS date_start_11,
  t0.date_end AS date_end_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.client_id AS client_id_15,
  t0.proposal_id AS proposal_id_16,
  t0.created_id_id AS created_id_id_17,
  t0.updated_id_id AS updated_id_id_18,
  t0.client_contact_id AS client_contact_id_19,
  t0.reservation_id AS reservation_id_20
FROM
  ht_file t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.status AS status_3, t0.days_block AS days_block_4, t0.pax AS pax_5, t0.description AS description_6, t0.description_two AS description_two_7, t0.contact_unregistered AS contact_unregistered_8, t0.name_contact_unregistered AS name_contact_unregistered_9, t0.phone_contact_unregistered AS phone_contact_unregistered_10, t0.date_start AS date_start_11, t0.date_end AS date_end_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.client_id AS client_id_15, t0.proposal_id AS proposal_id_16, t0.created_id_id AS created_id_id_17, t0.updated_id_id AS updated_id_id_18, t0.client_contact_id AS client_contact_id_19, t0.reservation_id AS reservation_id_20 FROM ht_file t0 WHERE t0.reservation_id = 10246;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.status AS status_3,
  t0.days_block AS days_block_4,
  t0.pax AS pax_5,
  t0.description AS description_6,
  t0.description_two AS description_two_7,
  t0.contact_unregistered AS contact_unregistered_8,
  t0.name_contact_unregistered AS name_contact_unregistered_9,
  t0.phone_contact_unregistered AS phone_contact_unregistered_10,
  t0.date_start AS date_start_11,
  t0.date_end AS date_end_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.client_id AS client_id_15,
  t0.proposal_id AS proposal_id_16,
  t0.created_id_id AS created_id_id_17,
  t0.updated_id_id AS updated_id_id_18,
  t0.client_contact_id AS client_contact_id_19,
  t0.reservation_id AS reservation_id_20
FROM
  ht_file t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.status AS status_3, t0.days_block AS days_block_4, t0.pax AS pax_5, t0.description AS description_6, t0.description_two AS description_two_7, t0.contact_unregistered AS contact_unregistered_8, t0.name_contact_unregistered AS name_contact_unregistered_9, t0.phone_contact_unregistered AS phone_contact_unregistered_10, t0.date_start AS date_start_11, t0.date_end AS date_end_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.client_id AS client_id_15, t0.proposal_id AS proposal_id_16, t0.created_id_id AS created_id_id_17, t0.updated_id_id AS updated_id_id_18, t0.client_contact_id AS client_contact_id_19, t0.reservation_id AS reservation_id_20 FROM ht_file t0 WHERE t0.reservation_id = 10433;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.status AS status_3,
  t0.days_block AS days_block_4,
  t0.pax AS pax_5,
  t0.description AS description_6,
  t0.description_two AS description_two_7,
  t0.contact_unregistered AS contact_unregistered_8,
  t0.name_contact_unregistered AS name_contact_unregistered_9,
  t0.phone_contact_unregistered AS phone_contact_unregistered_10,
  t0.date_start AS date_start_11,
  t0.date_end AS date_end_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.client_id AS client_id_15,
  t0.proposal_id AS proposal_id_16,
  t0.created_id_id AS created_id_id_17,
  t0.updated_id_id AS updated_id_id_18,
  t0.client_contact_id AS client_contact_id_19,
  t0.reservation_id AS reservation_id_20
FROM
  ht_file t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.status AS status_3, t0.days_block AS days_block_4, t0.pax AS pax_5, t0.description AS description_6, t0.description_two AS description_two_7, t0.contact_unregistered AS contact_unregistered_8, t0.name_contact_unregistered AS name_contact_unregistered_9, t0.phone_contact_unregistered AS phone_contact_unregistered_10, t0.date_start AS date_start_11, t0.date_end AS date_end_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.client_id AS client_id_15, t0.proposal_id AS proposal_id_16, t0.created_id_id AS created_id_id_17, t0.updated_id_id AS updated_id_id_18, t0.client_contact_id AS client_contact_id_19, t0.reservation_id AS reservation_id_20 FROM ht_file t0 WHERE t0.reservation_id = 10462;

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,
  t29.id AS id_30,
  t29.title AS title_31,
  t29.status AS status_32,
  t29.days_block AS days_block_33,
  t29.pax AS pax_34,
  t29.description AS description_35,
  t29.description_two AS description_two_36,
  t29.contact_unregistered AS contact_unregistered_37,
  t29.name_contact_unregistered AS name_contact_unregistered_38,
  t29.phone_contact_unregistered AS phone_contact_unregistered_39,
  t29.date_start AS date_start_40,
  t29.date_end AS date_end_41,
  t29.created_at AS created_at_42,
  t29.updated_at AS updated_at_43,
  t29.client_id AS client_id_44,
  t29.proposal_id AS proposal_id_45,
  t29.created_id_id AS created_id_id_46,
  t29.updated_id_id AS updated_id_id_47,
  t29.client_contact_id AS client_contact_id_48,
  t29.reservation_id AS reservation_id_49
FROM
  reservation t0
  LEFT JOIN ht_file t29 ON t29.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, t29.id AS id_30, t29.title AS title_31, t29.status AS status_32, t29.days_block AS days_block_33, t29.pax AS pax_34, t29.description AS description_35, t29.description_two AS description_two_36, t29.contact_unregistered AS contact_unregistered_37, t29.name_contact_unregistered AS name_contact_unregistered_38, t29.phone_contact_unregistered AS phone_contact_unregistered_39, t29.date_start AS date_start_40, t29.date_end AS date_end_41, t29.created_at AS created_at_42, t29.updated_at AS updated_at_43, t29.client_id AS client_id_44, t29.proposal_id AS proposal_id_45, t29.created_id_id AS created_id_id_46, t29.updated_id_id AS updated_id_id_47, t29.client_contact_id AS client_contact_id_48, t29.reservation_id AS reservation_id_49 FROM reservation t0 LEFT JOIN ht_file t29 ON t29.reservation_id = t0.id WHERE t0.id = '10487' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.client AS client_2,
  a0_.priority AS priority_3,
  a0_.supplier AS supplier_4,
  a0_.status AS status_5,
  a0_.daysBlock AS daysBlock_6,
  a0_.advancePayment AS advancePayment_7,
  a0_.idProposal AS idProposal_8,
  a0_.cateringName AS cateringName_9,
  a0_.boolCatering AS boolCatering_10,
  a0_.dateStart AS dateStart_11,
  a0_.dateEnd AS dateEnd_12,
  a0_.pax AS pax_13,
  a0_.deposit AS deposit_14,
  a0_.access_key AS access_key_15,
  a0_.description AS description_16,
  a0_.destinoId AS destinoId_17,
  a0_.createdAt AS createdAt_18,
  a0_.createdId AS createdId_19,
  a0_.updatedAt AS updatedAt_20,
  a0_.updatedId AS updatedId_21,
  a0_.comments AS comments_22,
  a0_.comments_in_inv AS comments_in_inv_23,
  a0_.comments_in_pro AS comments_in_pro_24,
  a0_.xtra_field_one AS xtra_field_one_25,
  a0_.xtra_field_two AS xtra_field_two_26,
  a0_.reservation_id AS reservation_id_27
FROM
  ave_files a0_
WHERE
  (
    (
      a0_.dateStart <= ?
      AND a0_.dateEnd >= ?
    )
  )
  OR (a0_.dateEnd = ?)
  OR (
    (
      a0_.dateEnd > ?
      AND a0_.dateEnd <= ?
    )
  )
  OR (a0_.dateStart = ?)
  OR (
    (
      a0_.dateStart > ?
      AND a0_.dateStart <= ?
    )
  )
  OR (a0_.dateStart = ?)
ORDER BY
  a0_.dateStart ASC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.client AS client_2, a0_.priority AS priority_3, a0_.supplier AS supplier_4, a0_.status AS status_5, a0_.daysBlock AS daysBlock_6, a0_.advancePayment AS advancePayment_7, a0_.idProposal AS idProposal_8, a0_.cateringName AS cateringName_9, a0_.boolCatering AS boolCatering_10, a0_.dateStart AS dateStart_11, a0_.dateEnd AS dateEnd_12, a0_.pax AS pax_13, a0_.deposit AS deposit_14, a0_.access_key AS access_key_15, a0_.description AS description_16, a0_.destinoId AS destinoId_17, a0_.createdAt AS createdAt_18, a0_.createdId AS createdId_19, a0_.updatedAt AS updatedAt_20, a0_.updatedId AS updatedId_21, a0_.comments AS comments_22, a0_.comments_in_inv AS comments_in_inv_23, a0_.comments_in_pro AS comments_in_pro_24, a0_.xtra_field_one AS xtra_field_one_25, a0_.xtra_field_two AS xtra_field_two_26, a0_.reservation_id AS reservation_id_27 FROM ave_files a0_ WHERE ((a0_.dateStart <= '2024-12-02 00:00:00' AND a0_.dateEnd >= '2024-12-04 23:59:00')) OR (a0_.dateEnd = '2024-12-02 00:00:00') OR ((a0_.dateEnd > '2024-12-02 00:00:00' AND a0_.dateEnd <= '2024-12-04 23:59:00')) OR (a0_.dateStart = '2024-12-02 00:00:00') OR ((a0_.dateStart > '2024-12-02 00:00:00' AND a0_.dateStart <= '2024-12-04 23:59:00')) OR (a0_.dateStart = '2024-12-04 23:59:00') ORDER BY a0_.dateStart ASC;

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
FROM
  reservation_lounge_simple t0
WHERE
  t0.idReservation = ?
  AND t0.type IS NULL

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 FROM reservation_lounge_simple t0 WHERE t0.idReservation = 10001 AND t0.type IS NULL;