Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

38 Database Queries

13 Different statements

12.73 ms Query time

0 Invalid entities

Queries

Group similar statements


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.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.token = ? LIMIT 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 FROM ave_package_template t0
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.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 WHERE t0.packId = ?
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.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 WHERE t0.packId = ?
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.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 WHERE t0.packId = ?
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.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 WHERE t0.packId = ?
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.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 WHERE t0.packId = ?
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.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 WHERE t0.packId = ?
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.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 WHERE t0.packId = ?
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.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 WHERE t0.packId = ?
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.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 WHERE t0.packId = ?
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 = ?
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.id = ?
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.idReservation = ?
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.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.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.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 = ?
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.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.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 = ?
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.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.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.name = ? 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.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.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

#▲	Time	Info
1	0.95 ms	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 Parameters: [] View formatted query View runnable query Explain query 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;
2	0.66 ms	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.token = ? LIMIT 1 Parameters: [`"6a233e686cc6f"`] View formatted query View runnable query Explain query 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.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.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.token = '6a233e686cc6f' LIMIT 1;
3	0.50 ms	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 FROM ave_package_template t0 Parameters: [] View formatted query View runnable query Explain query 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 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 FROM ave_package_template t0;
4	0.36 ms	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 = ? Parameters: [`1`] View formatted query View runnable query Explain query 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;
5	0.50 ms	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 WHERE t0.packId = ? Parameters: [`1`] View formatted query View runnable query Explain query 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 WHERE t0.packId = ? 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 WHERE t0.packId = 1;
6	0.39 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 = 2;
7	0.30 ms	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 WHERE t0.packId = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 WHERE t0.packId = ? 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 WHERE t0.packId = 2;
8	0.33 ms	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 = ? Parameters: [`3`] View formatted query View runnable query Explain query 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 = 3;
9	0.29 ms	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 WHERE t0.packId = ? Parameters: [`3`] View formatted query View runnable query Explain query 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 WHERE t0.packId = ? 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 WHERE t0.packId = 3;
10	0.36 ms	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 = ? Parameters: [`5`] View formatted query View runnable query Explain query 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 = 5;
11	0.32 ms	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 WHERE t0.packId = ? Parameters: [`5`] View formatted query View runnable query Explain query 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 WHERE t0.packId = ? 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 WHERE t0.packId = 5;
12	0.31 ms	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 = ? Parameters: [`10`] View formatted query View runnable query Explain query 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 = 10;
13	0.31 ms	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 WHERE t0.packId = ? Parameters: [`10`] View formatted query View runnable query Explain query 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 WHERE t0.packId = ? 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 WHERE t0.packId = 10;
14	0.37 ms	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 = ? Parameters: [`16`] View formatted query View runnable query Explain query 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 = 16;
15	0.46 ms	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 WHERE t0.packId = ? Parameters: [`16`] View formatted query View runnable query Explain query 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 WHERE t0.packId = ? 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 WHERE t0.packId = 16;
16	0.28 ms	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 = ? Parameters: [`17`] View formatted query View runnable query Explain query 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 = 17;
17	0.29 ms	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 WHERE t0.packId = ? Parameters: [`17`] View formatted query View runnable query Explain query 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 WHERE t0.packId = ? 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 WHERE t0.packId = 17;
18	0.26 ms	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 = ? Parameters: [`18`] View formatted query View runnable query Explain query 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 = 18;
19	0.24 ms	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 WHERE t0.packId = ? Parameters: [`18`] View formatted query View runnable query Explain query 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 WHERE t0.packId = ? 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 WHERE t0.packId = 18;
20	0.30 ms	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 = ? Parameters: [`19`] View formatted query View runnable query Explain query 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 = 19;
21	0.23 ms	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 WHERE t0.packId = ? Parameters: [`19`] View formatted query View runnable query Explain query 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 WHERE t0.packId = ? 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 WHERE t0.packId = 19;
22	0.57 ms	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 = ? Parameters: [`16413`] View formatted query View runnable query Explain query 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 = ? 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 = 16413;
23	0.45 ms	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.id = ? Parameters: [`4`] View formatted query View runnable query Explain query 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.id = ? 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.id = 4;
24	0.44 ms	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.idReservation = ? Parameters: [`16413`] View formatted query View runnable query Explain query 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.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, 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.idReservation = 16413;
25	0.28 ms	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 Parameters: [`"Combo 1 Plenaria Imprenta + Invernadero"`] View formatted query View runnable query Explain query 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 = 'Combo 1 Plenaria Imprenta + Invernadero' LIMIT 1;
26	0.38 ms	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 = ? Parameters: [`16`] View formatted query View runnable query Explain query 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 = 16;
27	0.40 ms	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 = ? Parameters: [`16`] View formatted query View runnable query Explain query 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 = 16;
28	0.24 ms	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 = ? Parameters: [`"2"`] View formatted query View runnable query Explain query 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 = ? 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 = '2';
29	0.20 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 = 2;
30	0.20 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 = 2;
31	0.24 ms	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 = ? Parameters: [`"4"`] View formatted query View runnable query Explain query 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 = ? 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 = '4';
32	0.18 ms	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 = ? Parameters: [`4`] View formatted query View runnable query Explain query 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 = 4;
33	0.17 ms	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 = ? Parameters: [`4`] View formatted query View runnable query Explain query 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 = 4;
34	0.22 ms	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 Parameters: [`16`] View formatted query View runnable query Explain query 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 = 16 LIMIT 1;
35	0.21 ms	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 Parameters: [`"Sala Plenaria La Imprenta"`] View formatted query View runnable query Explain query 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 Plenaria La Imprenta' LIMIT 1;
36	0.17 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 = 2;
37	0.18 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 = 2;
38	0.20 ms	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 Parameters: [`2`] View formatted query View runnable query Explain query 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 = 2 LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Configuration	No errors.
App\Entity\Space	No errors.
App\MDS\VenuesBundle\Entity\ReservationLoungeDetails	No errors.
App\MDS\VenuesBundle\Entity\Reservation	No errors.
App\Entity\Client	No errors.
App\Entity\HtFile	No errors.
App\Entity\User	No errors.
App\Entity\ClientContact	No errors.
App\MDS\AvexpressBundle\Entity\AveFiles	No errors.
App\Entity\DocContract	No errors.
App\Entity\HtItem	No errors.
App\Entity\HtVisit	No errors.
App\MDS\AvexpressBundle\Entity\AvePackageTemplate	No errors.
App\MDS\AvexpressBundle\Entity\AvePackageTemplateItems	No errors.
App\Entity\ReservationLoungeWebDescription	No errors.
App\MDS\VenuesBundle\Entity\ReservationService	No errors.
App\Entity\SageVatRates	No errors.
App\Entity\SageArticle	No errors.
App\Entity\SettingsCompany	No errors.
App\MDS\VenuesBundle\Entity\ReservationLoungeSimple	No errors.
App\MDS\VenuesBundle\Entity\ReservationLoungeDescription	No errors.
App\MDS\VenuesBundle\Entity\ReservationLoungePicture	No errors.

Symfony Profiler

https://mantevenues.mante.solutions/api/client/proposal/6a233e686cc6f

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping