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 = 'fernanda.ortiz@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 = 'fernanda.ortiz@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.name AS name_2,
  t0.created_id AS created_id_3,
  t0.created_at AS created_at_4,
  t0.updated_id AS updated_id_5,
  t0.updated_at AS updated_at_6,
  t0.meters AS meters_7,
  t0.length AS length_8,
  t0.width AS width_9,
  t0.height AS height_10,
  t0.cap_school AS cap_school_11,
  t0.cap_theater AS cap_theater_12,
  t0.cap_cocktail AS cap_cocktail_13,
  t0.cap_banquet AS cap_banquet_14,
  t0.cap_imperial AS cap_imperial_15,
  t0.rank_lounge AS rank_lounge_16,
  t0.combo AS combo_17,
  t0.importantDescription AS importantDescription_18,
  t0.importantDescGeneralText AS importantDescGeneralText_19,
  t0.importantDescSchedules AS importantDescSchedules_20,
  t0.importantDescParking AS importantDescParking_21,
  t0.space_id AS space_id_22
FROM
  reservation_lounge_details t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_id AS created_id_3, t0.created_at AS created_at_4, t0.updated_id AS updated_id_5, t0.updated_at AS updated_at_6, t0.meters AS meters_7, t0.length AS length_8, t0.width AS width_9, t0.height AS height_10, t0.cap_school AS cap_school_11, t0.cap_theater AS cap_theater_12, t0.cap_cocktail AS cap_cocktail_13, t0.cap_banquet AS cap_banquet_14, t0.cap_imperial AS cap_imperial_15, t0.rank_lounge AS rank_lounge_16, t0.combo AS combo_17, t0.importantDescription AS importantDescription_18, t0.importantDescGeneralText AS importantDescGeneralText_19, t0.importantDescSchedules AS importantDescSchedules_20, t0.importantDescParking AS importantDescParking_21, t0.space_id AS space_id_22 FROM reservation_lounge_details t0 WHERE t0.id = '12' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_id AS created_id_3,
  t0.created_at AS created_at_4,
  t0.updated_id AS updated_id_5,
  t0.updated_at AS updated_at_6,
  t0.meters AS meters_7,
  t0.length AS length_8,
  t0.width AS width_9,
  t0.height AS height_10,
  t0.cap_school AS cap_school_11,
  t0.cap_theater AS cap_theater_12,
  t0.cap_cocktail AS cap_cocktail_13,
  t0.cap_banquet AS cap_banquet_14,
  t0.cap_imperial AS cap_imperial_15,
  t0.rank_lounge AS rank_lounge_16,
  t0.combo AS combo_17,
  t0.importantDescription AS importantDescription_18,
  t0.importantDescGeneralText AS importantDescGeneralText_19,
  t0.importantDescSchedules AS importantDescSchedules_20,
  t0.importantDescParking AS importantDescParking_21,
  t0.space_id AS space_id_22
FROM
  reservation_lounge_details t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_id AS created_id_3, t0.created_at AS created_at_4, t0.updated_id AS updated_id_5, t0.updated_at AS updated_at_6, t0.meters AS meters_7, t0.length AS length_8, t0.width AS width_9, t0.height AS height_10, t0.cap_school AS cap_school_11, t0.cap_theater AS cap_theater_12, t0.cap_cocktail AS cap_cocktail_13, t0.cap_banquet AS cap_banquet_14, t0.cap_imperial AS cap_imperial_15, t0.rank_lounge AS rank_lounge_16, t0.combo AS combo_17, t0.importantDescription AS importantDescription_18, t0.importantDescGeneralText AS importantDescGeneralText_19, t0.importantDescSchedules AS importantDescSchedules_20, t0.importantDescParking AS importantDescParking_21, t0.space_id AS space_id_22 FROM reservation_lounge_details t0 WHERE t0.id = 12 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,
  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.idLounge = ?
  AND t0.idReservation = ?
  AND t0.rankQuote = ?
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, 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.idLounge = 12 AND t0.idReservation = '14386' AND t0.rankQuote = '2' 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,
  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.idLounge = ?
  AND t0.idReservation = ?
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, 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.idLounge = 12 AND t0.idReservation = '14386' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.important_description AS important_description_3,
  t0.important_desc_general_text AS important_desc_general_text_4,
  t0.important_desc_schedules AS important_desc_schedules_5,
  t0.important_desc_parking AS important_desc_parking_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.lounge_id AS lounge_id_9,
  t0.created_id_id AS created_id_id_10,
  t0.updated_id_id AS updated_id_id_11
FROM
  reservation_lounge_web_description t0
WHERE
  t0.lounge_id = ?
  AND t0.language = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.language AS language_2, t0.important_description AS important_description_3, t0.important_desc_general_text AS important_desc_general_text_4, t0.important_desc_schedules AS important_desc_schedules_5, t0.important_desc_parking AS important_desc_parking_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.lounge_id AS lounge_id_9, t0.created_id_id AS created_id_id_10, t0.updated_id_id AS updated_id_id_11 FROM reservation_lounge_web_description t0 WHERE t0.lounge_id = 12 AND t0.language = 2 LIMIT 1;

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

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

SELECT
  t0.id AS id_1,
  t0.sage_code AS sage_code_2,
  t0.name AS name_3,
  t0.iva AS iva_4,
  t0.sync_date AS sync_date_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.settings_company_id AS settings_company_id_8
FROM
  sage_vat_rates t0
WHERE
  t0.sage_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.sage_code AS sage_code_2, t0.name AS name_3, t0.iva AS iva_4, t0.sync_date AS sync_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.settings_company_id AS settings_company_id_8 FROM sage_vat_rates t0 WHERE t0.sage_code = '03' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.sage_code AS sage_code_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.active AS active_5,
  t0.sent_to_sage AS sent_to_sage_6,
  t0.sync_date AS sync_date_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.discharge_date AS discharge_date_10,
  t0.family_id AS family_id_11,
  t0.subfamily_id AS subfamily_id_12,
  t0.vat_type_id AS vat_type_id_13,
  t0.settings_company_id AS settings_company_id_14
FROM
  sage_article t0
WHERE
  t0.vat_type_id = ?
  AND t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.sage_code AS sage_code_2, t0.name AS name_3, t0.description AS description_4, t0.active AS active_5, t0.sent_to_sage AS sent_to_sage_6, t0.sync_date AS sync_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.discharge_date AS discharge_date_10, t0.family_id AS family_id_11, t0.subfamily_id AS subfamily_id_12, t0.vat_type_id AS vat_type_id_13, t0.settings_company_id AS settings_company_id_14 FROM sage_article t0 WHERE t0.vat_type_id = 4 AND t0.name = 'GP Imprenta E.Completo Exclusiva + Sala 25 + Lima Rooms' LIMIT 1;

SELECT
  r0_.id AS id_0,
  r0_.loungeName AS loungeName_1,
  r0_.idLounge AS idLounge_2,
  r0_.dateStart AS dateStart_3,
  r0_.dateEnd AS dateEnd_4,
  r0_.servicePrice AS servicePrice_5,
  r0_.idReservation AS idReservation_6,
  r0_.pax AS pax_7,
  r0_.type AS type_8,
  r0_.createdAt AS createdAt_9,
  r0_.createdBy AS createdBy_10,
  r0_.updatedAt AS updatedAt_11,
  r0_.updatedBy AS updatedBy_12,
  r0_.hourStart AS hourStart_13,
  r0_.minStart AS minStart_14,
  r0_.hourEnd AS hourEnd_15,
  r0_.minEnd AS minEnd_16,
  r0_.rankQuote AS rankQuote_17,
  r0_.op_iva AS op_iva_18,
  r0_.iva AS iva_19,
  r0_.loungeDescription AS loungeDescription_20,
  r0_.importantDescription AS importantDescription_21,
  r0_.importantDescGeneralText AS importantDescGeneralText_22,
  r0_.importantDescSchedules AS importantDescSchedules_23,
  r0_.importantDescParking AS importantDescParking_24,
  r0_.language AS language_25,
  r0_.sent_to_sage AS sent_to_sage_26,
  r0_.sage_iva AS sage_iva_27,
  r0_.sage_article_id AS sage_article_id_28
FROM
  reservation_lounge_simple r0_
WHERE
  r0_.idReservation = ?
ORDER BY
  r0_.rankQuote ASC

SELECT r0_.id AS id_0, r0_.loungeName AS loungeName_1, r0_.idLounge AS idLounge_2, r0_.dateStart AS dateStart_3, r0_.dateEnd AS dateEnd_4, r0_.servicePrice AS servicePrice_5, r0_.idReservation AS idReservation_6, r0_.pax AS pax_7, r0_.type AS type_8, r0_.createdAt AS createdAt_9, r0_.createdBy AS createdBy_10, r0_.updatedAt AS updatedAt_11, r0_.updatedBy AS updatedBy_12, r0_.hourStart AS hourStart_13, r0_.minStart AS minStart_14, r0_.hourEnd AS hourEnd_15, r0_.minEnd AS minEnd_16, r0_.rankQuote AS rankQuote_17, r0_.op_iva AS op_iva_18, r0_.iva AS iva_19, r0_.loungeDescription AS loungeDescription_20, r0_.importantDescription AS importantDescription_21, r0_.importantDescGeneralText AS importantDescGeneralText_22, r0_.importantDescSchedules AS importantDescSchedules_23, r0_.importantDescParking AS importantDescParking_24, r0_.language AS language_25, r0_.sent_to_sage AS sent_to_sage_26, r0_.sage_iva AS sage_iva_27, r0_.sage_article_id AS sage_article_id_28 FROM reservation_lounge_simple r0_ WHERE r0_.idReservation = '14386' ORDER BY r0_.rankQuote ASC;

SELECT
  r0_.id AS id_0,
  r0_.loungeId AS loungeId_1,
  r0_.periodId AS periodId_2,
  r0_.price AS price_3,
  r0_.description AS description_4,
  r0_.created_id AS created_id_5,
  r0_.created_at AS created_at_6,
  r0_.updated_id AS updated_id_7,
  r0_.updated_at AS updated_at_8,
  r0_.year1 AS year1_9,
  r0_.year2 AS year2_10,
  r0_.month1 AS month1_11,
  r0_.month2 AS month2_12,
  r0_.month3 AS month3_13,
  r0_.month4 AS month4_14,
  r0_.month5 AS month5_15,
  r0_.month6 AS month6_16,
  r0_.month7 AS month7_17,
  r0_.month8 AS month8_18,
  r0_.month9 AS month9_19,
  r0_.month10 AS month10_20,
  r0_.month11 AS month11_21,
  r0_.month12 AS month12_22,
  r0_.day1 AS day1_23,
  r0_.day2 AS day2_24,
  r0_.day3 AS day3_25,
  r0_.day4 AS day4_26,
  r0_.day5 AS day5_27,
  r0_.day6 AS day6_28,
  r0_.day7 AS day7_29,
  r0_.title AS title_30,
  r0_.priceIsActive AS priceIsActive_31,
  r0_.dateStart AS dateStart_32,
  r0_.dateEnd AS dateEnd_33,
  r0_.type_price AS type_price_34,
  r0_.level_price AS level_price_35
FROM
  reservation_lounge_profile r0_
WHERE
  r0_.type_price = ?
  AND r0_.dateStart = ?
  AND r0_.loungeId = ?
ORDER BY
  r0_.level_price DESC

SELECT r0_.id AS id_0, r0_.loungeId AS loungeId_1, r0_.periodId AS periodId_2, r0_.price AS price_3, r0_.description AS description_4, r0_.created_id AS created_id_5, r0_.created_at AS created_at_6, r0_.updated_id AS updated_id_7, r0_.updated_at AS updated_at_8, r0_.year1 AS year1_9, r0_.year2 AS year2_10, r0_.month1 AS month1_11, r0_.month2 AS month2_12, r0_.month3 AS month3_13, r0_.month4 AS month4_14, r0_.month5 AS month5_15, r0_.month6 AS month6_16, r0_.month7 AS month7_17, r0_.month8 AS month8_18, r0_.month9 AS month9_19, r0_.month10 AS month10_20, r0_.month11 AS month11_21, r0_.month12 AS month12_22, r0_.day1 AS day1_23, r0_.day2 AS day2_24, r0_.day3 AS day3_25, r0_.day4 AS day4_26, r0_.day5 AS day5_27, r0_.day6 AS day6_28, r0_.day7 AS day7_29, r0_.title AS title_30, r0_.priceIsActive AS priceIsActive_31, r0_.dateStart AS dateStart_32, r0_.dateEnd AS dateEnd_33, r0_.type_price AS type_price_34, r0_.level_price AS level_price_35 FROM reservation_lounge_profile r0_ WHERE r0_.type_price = 'DIARIA' AND r0_.dateStart = '2026-06-22 00:00:00' AND r0_.loungeId = 12 ORDER BY r0_.level_price DESC;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO reservation_lounge_simple (
  loungeName, idLounge, dateStart, dateEnd,
  servicePrice, idReservation, pax,
  type, createdAt, createdBy, updatedAt,
  updatedBy, hourStart, minStart, hourEnd,
  minEnd, rankQuote, op_iva, iva, loungeDescription,
  importantDescription, importantDescGeneralText,
  importantDescSchedules, importantDescParking,
  language, sent_to_sage, sage_iva,
  sage_article_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO reservation_lounge_simple (loungeName, idLounge, dateStart, dateEnd, servicePrice, idReservation, pax, type, createdAt, createdBy, updatedAt, updatedBy, hourStart, minStart, hourEnd, minEnd, rankQuote, op_iva, iva, loungeDescription, importantDescription, importantDescGeneralText, importantDescSchedules, importantDescParking, language, sent_to_sage, sage_iva, sage_article_id) VALUES ('GP Imprenta E.Completo Exclusiva + Sala 25 + Lima Rooms', 12, '2026-06-22 08:00:00', '2026-06-22 17:00:00', 12200, 14386, 75, NULL, '2026-06-11 19:26:58', 149, '2026-06-11 19:26:58', 149, '08', '00', '17', '00', 2, 1, NULL, NULL, '<div class=\"gmail_default\" style=\"color: rgb(34, 34, 34); font-size: small; font-family: verdana, sans-serif;\"><b style=\"font-family: Verdana; color: rgb(51, 51, 51); font-size: 13px;\"><u>For this event, I can offer you the following spaces:</u></b></div><ul><li style=\"margin-left: 15px;\"><ul style=\"color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small;\"><li style=\"margin-left: 15px;\"><font face=\"verdana, sans-serif\" color=\"#000000\"><b><a href=\"https://www.instagram.com/p/Ca5jc6WD0um/?img_index=1\" target=\"_blank\" data-saferedirecturl=\"https://www.google.com/url?q=https://www.instagram.com/p/Ca5jc6WD0um/?img_index%3D1&amp;source=gmail&amp;ust=1770892345183000&amp;usg=AOvVaw2TlsnF4cf9aCJwKJwTK2Bm\" style=\"color: rgb(17, 85, 204);\">Plenary Room:</a></b>&nbsp;for the main meeting&nbsp;</font></li><li style=\"margin-left: 15px;\"><font face=\"verdana, sans-serif\"><b style=\"color: rgb(0, 0, 0);\"><a href=\"https://www.instagram.com/p/CZhhABnDXc_/\" target=\"_blank\" data-saferedirecturl=\"https://www.google.com/url?q=https://www.instagram.com/p/CZhhABnDXc_/&amp;source=gmail&amp;ust=1770892345183000&amp;usg=AOvVaw3pWp5fZ8tDuXXXzayBD9f_\" style=\"color: rgb(17, 85, 204);\">Greenhouse Room</a>&nbsp;</b><span style=\"color: rgb(0, 0, 0);\">for the catering</span></font></li><li style=\"margin-left: 15px;\"><font face=\"verdana, sans-serif\"><b style=\"color: rgb(0, 0, 0);\"><a href=\"https://www.instagram.com/p/CZ7BH1FjavD/\" target=\"_blank\" data-saferedirecturl=\"https://www.google.com/url?q=https://www.instagram.com/p/CZ7BH1FjavD/&amp;source=gmail&amp;ust=1770892345183000&amp;usg=AOvVaw0se_Qu6ttvswPCDQ6QuaMm\" style=\"color: rgb(17, 85, 204);\">Stage Room</a>&nbsp;</b><span style=\"color: rgb(0, 0, 0);\">for one of the breakouts&nbsp;</span></font></li><li style=\"margin-left: 15px;\"><font color=\"#000000\" face=\"verdana, sans-serif\"><b><a href=\"https://www.instagram.com/p/CXJgNATj_Eg/\" target=\"_blank\" data-saferedirecturl=\"https://www.google.com/url?q=https://www.instagram.com/p/CXJgNATj_Eg/&amp;source=gmail&amp;ust=1770892345183000&amp;usg=AOvVaw3TbBfx-XIVxJW1xOZRKTC_\" style=\"color: rgb(17, 85, 204);\">Crystal Room:</a>&nbsp;</b>for other breakout&nbsp;</font></li><li style=\"margin-left: 15px;\"><font color=\"#000000\" face=\"verdana, sans-serif\"><b>Atelier Room:&nbsp;</b>for the 3rd breakout&nbsp;</font></li><li style=\"margin-left: 15px;\"><strong style=\"font-family: Verdana; color: rgb(51, 51, 51); font-size: 13px;\">Room 25 — All-Inclusive (please see included items under the IMPORTANT section):</strong><span style=\"font-family: Verdana; color: rgb(51, 51, 51); font-size: 13px;\">&nbsp;for other parallel meeting</span></li><li style=\"margin-left: 15px;\"><span style=\"color: rgb(51, 51, 51); font-family: Roboto, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 13px;\"><font face=\"Verdana\"><b>Lima Rooms&nbsp;</b>for the rest of breakouts&nbsp;</font></span></li></ul></li></ul><p><font face=\"Verdana\"><b>LIMA ROOMS IS a</b>&nbsp;versatile 200 m² area designed to adapt to collaborative work dynamics, training sessions, and executive meetings. The space includes:</font></p><ul><li style=\"margin-left: 15px;\"><p><font face=\"Verdana\">5 working rooms, ideal for team meetings or brainstorming sessions of up to 10 people each</font></p></li><li style=\"margin-left: 15px;\"><p><font face=\"Verdana\">1 main room with capacity for up to 90 people in theater setup, perfect for presentations, training sessions, or conferences</font></p></li><li style=\"margin-left: 15px;\"><p><font face=\"Verdana\">1 catering room with capacity for 20 people, designed to provide a comfortable and private area for coffee breaks, lunches, or networking pauses</font></p></li><li style=\"margin-left: 15px;\"><p><font face=\"Verdana\">1 silence booth for private calls or confidential meetings for up to 2 people, ensuring maximum focus and privacy</font></p></li></ul>', '', '', '', 1, 0, 4, NULL);

"COMMIT"

"COMMIT";

SELECT
  MAX(r0_.rankListing) AS sclr_0
FROM
  reservation_agenda_item r0_
WHERE
  r0_.reservationId = ?

SELECT MAX(r0_.rankListing) AS sclr_0 FROM reservation_agenda_item r0_ WHERE r0_.reservationId = 14386;

SELECT
  MAX(r0_.rankListing) AS sclr_0
FROM
  reservation_agenda_item r0_
WHERE
  r0_.reservationId = ?
  AND r0_.titleOne = ?

SELECT MAX(r0_.rankListing) AS sclr_0 FROM reservation_agenda_item r0_ WHERE r0_.reservationId = 14386 AND r0_.titleOne = 'SALAS A UTILIZAR';

UPDATE
  reservation_agenda_item
SET
  rankListing = rankListing + 1
WHERE
  reservationId = ?
  AND rankListing >= ?

UPDATE reservation_agenda_item SET rankListing = rankListing + 1 WHERE reservationId = 14386 AND rankListing >= 5;