Symfony Profiler

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
  INNER JOIN ave_package_lounges ON t0.id = ave_package_lounges.lounge_id
WHERE
  ave_package_lounges.package_template_id = ?

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 INNER JOIN ave_package_lounges ON t0.id = ave_package_lounges.lounge_id WHERE ave_package_lounges.package_template_id = 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.name = ?
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.name = 'Sala de Cristal' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.loungeId AS loungeId_2,
  t0.language AS language_3,
  t0.description AS description_4,
  t0.createdId AS createdId_5,
  t0.createdAt AS createdAt_6,
  t0.updatedId AS updatedId_7,
  t0.updatedAt AS updatedAt_8
FROM
  reservation_lounge_description t0
WHERE
  t0.loungeId = ?

SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.language AS language_3, t0.description AS description_4, t0.createdId AS createdId_5, t0.createdAt AS createdAt_6, t0.updatedId AS updatedId_7, t0.updatedAt AS updatedAt_8 FROM reservation_lounge_description t0 WHERE t0.loungeId = 13;

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

SELECT
  t0.id AS id_1,
  t0.loungeId AS loungeId_2,
  t0.createdId AS createdId_3,
  t0.createdAt AS createdAt_4,
  t0.updatedId AS updatedId_5,
  t0.updatedAt AS updatedAt_6,
  t0.title AS title_7,
  t0.image_large AS image_large_8,
  t0.image_medium AS image_medium_9,
  t0.image_small AS image_small_10
FROM
  reservation_lounge_picture t0
WHERE
  t0.loungeId = ?

SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.createdId AS createdId_3, t0.createdAt AS createdAt_4, t0.updatedId AS updatedId_5, t0.updatedAt AS updatedAt_6, t0.title AS title_7, t0.image_large AS image_large_8, t0.image_medium AS image_medium_9, t0.image_small AS image_small_10 FROM reservation_lounge_picture t0 WHERE t0.loungeId = 13;

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.productName AS productName_2,
  t0.percProductPrice AS percProductPrice_3,
  t0.rankAvPack AS rankAvPack_4,
  t0.productId AS productId_5,
  t0.dateStart AS dateStart_6,
  t0.dateEnd AS dateEnd_7,
  t0.servicePrice AS servicePrice_8,
  t0.fileId AS fileId_9,
  t0.pax AS pax_10,
  t0.type AS type_11,
  t0.hourStart AS hourStart_12,
  t0.minStart AS minStart_13,
  t0.hourEnd AS hourEnd_14,
  t0.minEnd AS minEnd_15,
  t0.description AS description_16,
  t0.createdAt AS createdAt_17,
  t0.createdId AS createdId_18,
  t0.updatedAt AS updatedAt_19,
  t0.updatedId AS updatedId_20,
  t0.supplierExt AS supplierExt_21,
  t0.supplierExtId AS supplierExtId_22,
  t0.currency AS currency_23,
  t0.units AS units_24,
  t0.opCommission AS opCommission_25,
  t0.commission AS commission_26,
  t0.opOver AS opOver_27,
  t0.overPrice AS overPrice_28,
  t0.opIva AS opIva_29,
  t0.iva AS iva_30,
  t0.dateInAt AS dateInAt_31,
  t0.dateOutAt AS dateOutAt_32,
  t0.days AS days_33,
  t0.subTotalPrice AS subTotalPrice_34,
  t0.originId AS originId_35,
  t0.rankAv AS rankAv_36,
  t0.location AS location_37,
  t0.packId AS packId_38,
  t0.priceWithoutPack AS priceWithoutPack_39
FROM
  ave_package_template_items t0
ORDER BY
  t0.rankAvPack ASC

SELECT t0.id AS id_1, t0.productName AS productName_2, t0.percProductPrice AS percProductPrice_3, t0.rankAvPack AS rankAvPack_4, t0.productId AS productId_5, t0.dateStart AS dateStart_6, t0.dateEnd AS dateEnd_7, t0.servicePrice AS servicePrice_8, t0.fileId AS fileId_9, t0.pax AS pax_10, t0.type AS type_11, t0.hourStart AS hourStart_12, t0.minStart AS minStart_13, t0.hourEnd AS hourEnd_14, t0.minEnd AS minEnd_15, t0.description AS description_16, t0.createdAt AS createdAt_17, t0.createdId AS createdId_18, t0.updatedAt AS updatedAt_19, t0.updatedId AS updatedId_20, t0.supplierExt AS supplierExt_21, t0.supplierExtId AS supplierExtId_22, t0.currency AS currency_23, t0.units AS units_24, t0.opCommission AS opCommission_25, t0.commission AS commission_26, t0.opOver AS opOver_27, t0.overPrice AS overPrice_28, t0.opIva AS opIva_29, t0.iva AS iva_30, t0.dateInAt AS dateInAt_31, t0.dateOutAt AS dateOutAt_32, t0.days AS days_33, t0.subTotalPrice AS subTotalPrice_34, t0.originId AS originId_35, t0.rankAv AS rankAv_36, t0.location AS location_37, t0.packId AS packId_38, t0.priceWithoutPack AS priceWithoutPack_39 FROM ave_package_template_items t0 ORDER BY t0.rankAvPack ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.clientContact AS clientContact_3,
  t0.contactUnregistered AS contactUnregistered_4,
  t0.nameContactUnregistered AS nameContactUnregistered_5,
  t0.phoneContactUnregistered AS phoneContactUnregistered_6,
  t0.days AS days_7,
  t0.createdAt AS createdAt_8,
  t0.priority AS priority_9,
  t0.createdBy AS createdBy_10,
  t0.supplier AS supplier_11,
  t0.status AS status_12,
  t0.updatedAt AS updatedAt_13,
  t0.updatedBy AS updatedBy_14,
  t0.daysBlock AS daysBlock_15,
  t0.dateStart AS dateStart_16,
  t0.dateEnd AS dateEnd_17,
  t0.pax AS pax_18,
  t0.access_key AS access_key_19,
  t0.description AS description_20,
  t0.contract AS contract_21,
  t0.token AS token_22,
  t0.comAvGp AS comAvGp_23,
  t0.comHtGp AS comHtGp_24,
  t0.sucoe AS sucoe_25,
  t0.breakdown_packages AS breakdown_packages_26,
  t0.show_package_price AS show_package_price_27,
  t0.infoFormWeb AS infoFormWeb_28,
  t0.mailToClient AS mailToClient_29,
  t0.client_id AS client_id_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.created_id_id AS created_id_id_48,
  t31.updated_id_id AS updated_id_id_49,
  t31.client_contact_id AS client_contact_id_50,
  t31.reservation_id AS reservation_id_51,
  t52.id AS id_53,
  t52.title AS title_54,
  t52.client AS client_55,
  t52.priority AS priority_56,
  t52.supplier AS supplier_57,
  t52.status AS status_58,
  t52.daysBlock AS daysBlock_59,
  t52.advancePayment AS advancePayment_60,
  t52.idProposal AS idProposal_61,
  t52.cateringName AS cateringName_62,
  t52.boolCatering AS boolCatering_63,
  t52.dateStart AS dateStart_64,
  t52.dateEnd AS dateEnd_65,
  t52.pax AS pax_66,
  t52.deposit AS deposit_67,
  t52.access_key AS access_key_68,
  t52.description AS description_69,
  t52.destinoId AS destinoId_70,
  t52.createdAt AS createdAt_71,
  t52.createdId AS createdId_72,
  t52.updatedAt AS updatedAt_73,
  t52.updatedId AS updatedId_74,
  t52.comments AS comments_75,
  t52.comments_in_inv AS comments_in_inv_76,
  t52.comments_in_pro AS comments_in_pro_77,
  t52.xtra_field_one AS xtra_field_one_78,
  t52.xtra_field_two AS xtra_field_two_79,
  t52.reservation_id AS reservation_id_80
FROM
  reservation t0
  LEFT JOIN ht_file t31 ON t31.reservation_id = t0.id
  LEFT JOIN ave_files t52 ON t52.reservation_id = t0.id
WHERE
  t0.token = ?
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.breakdown_packages AS breakdown_packages_26, t0.show_package_price AS show_package_price_27, t0.infoFormWeb AS infoFormWeb_28, t0.mailToClient AS mailToClient_29, t0.client_id AS client_id_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.created_id_id AS created_id_id_48, t31.updated_id_id AS updated_id_id_49, t31.client_contact_id AS client_contact_id_50, t31.reservation_id AS reservation_id_51, t52.id AS id_53, t52.title AS title_54, t52.client AS client_55, t52.priority AS priority_56, t52.supplier AS supplier_57, t52.status AS status_58, t52.daysBlock AS daysBlock_59, t52.advancePayment AS advancePayment_60, t52.idProposal AS idProposal_61, t52.cateringName AS cateringName_62, t52.boolCatering AS boolCatering_63, t52.dateStart AS dateStart_64, t52.dateEnd AS dateEnd_65, t52.pax AS pax_66, t52.deposit AS deposit_67, t52.access_key AS access_key_68, t52.description AS description_69, t52.destinoId AS destinoId_70, t52.createdAt AS createdAt_71, t52.createdId AS createdId_72, t52.updatedAt AS updatedAt_73, t52.updatedId AS updatedId_74, t52.comments AS comments_75, t52.comments_in_inv AS comments_in_inv_76, t52.comments_in_pro AS comments_in_pro_77, t52.xtra_field_one AS xtra_field_one_78, t52.xtra_field_two AS xtra_field_two_79, t52.reservation_id AS reservation_id_80 FROM reservation t0 LEFT JOIN ht_file t31 ON t31.reservation_id = t0.id LEFT JOIN ave_files t52 ON t52.reservation_id = t0.id WHERE t0.token = '6a96f52926bb4' 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.breakdown_packages AS breakdown_packages_28,
  t0.show_audiovisual_price AS show_audiovisual_price_29,
  t0.show_audiovisual_package AS show_audiovisual_package_30,
  t0.sage_iva AS sage_iva_31,
  t0.sage_article_id AS sage_article_id_32
FROM
  reservation_lounge_simple t0
WHERE
  t0.idReservation = ?
ORDER BY
  t0.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, 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.breakdown_packages AS breakdown_packages_28, t0.show_audiovisual_price AS show_audiovisual_price_29, t0.show_audiovisual_package AS show_audiovisual_package_30, t0.sage_iva AS sage_iva_31, t0.sage_article_id AS sage_article_id_32 FROM reservation_lounge_simple t0 WHERE t0.idReservation = 17333 ORDER BY t0.dateStart ASC;

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,
  t0.sent_to_sage AS sent_to_sage_32,
  t0.sage_iva AS sage_iva_33,
  t0.iva_supplier AS iva_supplier_34,
  t35.id AS id_36,
  t35.lounge_other AS lounge_other_37,
  t35.date_start AS date_start_38,
  t35.hour_end AS hour_end_39,
  t35.gratitudes AS gratitudes_40,
  t35.created_at AS created_at_41,
  t35.updated_at AS updated_at_42,
  t35.pax AS pax_43,
  t35.observation AS observation_44,
  t35.type AS type_45,
  t35.reservation_service_id AS reservation_service_id_46,
  t35.lounge_gp_id AS lounge_gp_id_47,
  t35.created_id_id AS created_id_id_48,
  t35.updated_id_id AS updated_id_id_49,
  t35.ht_file_id AS ht_file_id_50,
  t0.sage_article_id AS sage_article_id_51,
  t0.sage_article_supplier_id AS sage_article_supplier_id_52
FROM
  reservation_service t0
  LEFT JOIN ht_item t35 ON t35.reservation_service_id = t0.id
WHERE
  t0.reservationId = ?
  AND t0.toinvoice = ?

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, t0.sent_to_sage AS sent_to_sage_32, t0.sage_iva AS sage_iva_33, t0.iva_supplier AS iva_supplier_34, t35.id AS id_36, t35.lounge_other AS lounge_other_37, t35.date_start AS date_start_38, t35.hour_end AS hour_end_39, t35.gratitudes AS gratitudes_40, t35.created_at AS created_at_41, t35.updated_at AS updated_at_42, t35.pax AS pax_43, t35.observation AS observation_44, t35.type AS type_45, t35.reservation_service_id AS reservation_service_id_46, t35.lounge_gp_id AS lounge_gp_id_47, t35.created_id_id AS created_id_id_48, t35.updated_id_id AS updated_id_id_49, t35.ht_file_id AS ht_file_id_50, t0.sage_article_id AS sage_article_id_51, t0.sage_article_supplier_id AS sage_article_supplier_id_52 FROM reservation_service t0 LEFT JOIN ht_item t35 ON t35.reservation_service_id = t0.id WHERE t0.reservationId = 17333 AND t0.toinvoice = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.total_net_price AS total_net_price_4,
  t0.createdAt AS createdAt_5,
  t0.createdId AS createdId_6,
  t0.updatedAt AS updatedAt_7,
  t0.updatedId AS updatedId_8,
  t0.aveProductFileId AS aveProductFileId_9,
  t0.is_featured AS is_featured_10,
  t0.internal_price AS internal_price_11,
  t0.pricePackage AS pricePackage_12
FROM
  ave_package_template t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.total_net_price AS total_net_price_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8, t0.aveProductFileId AS aveProductFileId_9, t0.is_featured AS is_featured_10, t0.internal_price AS internal_price_11, t0.pricePackage AS pricePackage_12 FROM ave_package_template t0;