Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

38 Database Queries

11 Different statements

7.16 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.breakdown_packages AS breakdown_packages_26, t0.show_package_price AS show_package_price_27, t0.infoFormWeb AS infoFormWeb_28, t0.mailToClient AS mailToClient_29, t0.client_id AS client_id_30, t31.id AS id_32, t31.title AS title_33, t31.status AS status_34, t31.days_block AS days_block_35, t31.pax AS pax_36, t31.description AS description_37, t31.description_two AS description_two_38, t31.contact_unregistered AS contact_unregistered_39, t31.name_contact_unregistered AS name_contact_unregistered_40, t31.phone_contact_unregistered AS phone_contact_unregistered_41, t31.date_start AS date_start_42, t31.date_end AS date_end_43, t31.created_at AS created_at_44, t31.updated_at AS updated_at_45, t31.client_type AS client_type_46, t31.client_id AS client_id_47, t31.created_id_id AS created_id_id_48, t31.updated_id_id AS updated_id_id_49, t31.client_contact_id AS client_contact_id_50, t31.reservation_id AS reservation_id_51, t52.id AS id_53, t52.title AS title_54, t52.client AS client_55, t52.priority AS priority_56, t52.supplier AS supplier_57, t52.status AS status_58, t52.daysBlock AS daysBlock_59, t52.advancePayment AS advancePayment_60, t52.idProposal AS idProposal_61, t52.cateringName AS cateringName_62, t52.boolCatering AS boolCatering_63, t52.dateStart AS dateStart_64, t52.dateEnd AS dateEnd_65, t52.pax AS pax_66, t52.deposit AS deposit_67, t52.access_key AS access_key_68, t52.description AS description_69, t52.destinoId AS destinoId_70, t52.createdAt AS createdAt_71, t52.createdId AS createdId_72, t52.updatedAt AS updatedAt_73, t52.updatedId AS updatedId_74, t52.comments AS comments_75, t52.comments_in_inv AS comments_in_inv_76, t52.comments_in_pro AS comments_in_pro_77, t52.xtra_field_one AS xtra_field_one_78, t52.xtra_field_two AS xtra_field_two_79, t52.reservation_id AS reservation_id_80 FROM reservation t0 LEFT JOIN ht_file t31 ON t31.reservation_id = t0.id LEFT JOIN ave_files t52 ON t52.reservation_id = t0.id WHERE t0.token = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.total_net_price AS total_net_price_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8, t0.aveProductFileId AS aveProductFileId_9, t0.is_featured AS is_featured_10, t0.internal_price AS internal_price_11, t0.pricePackage AS pricePackage_12 FROM ave_package_template t0
SELECT t0.id AS id_1, t0.productName AS productName_2, t0.percProductPrice AS percProductPrice_3, t0.rankAvPack AS rankAvPack_4, t0.productId AS productId_5, t0.dateStart AS dateStart_6, t0.dateEnd AS dateEnd_7, t0.servicePrice AS servicePrice_8, t0.fileId AS fileId_9, t0.pax AS pax_10, t0.type AS type_11, t0.hourStart AS hourStart_12, t0.minStart AS minStart_13, t0.hourEnd AS hourEnd_14, t0.minEnd AS minEnd_15, t0.description AS description_16, t0.createdAt AS createdAt_17, t0.createdId AS createdId_18, t0.updatedAt AS updatedAt_19, t0.updatedId AS updatedId_20, t0.supplierExt AS supplierExt_21, t0.supplierExtId AS supplierExtId_22, t0.currency AS currency_23, t0.units AS units_24, t0.opCommission AS opCommission_25, t0.commission AS commission_26, t0.opOver AS opOver_27, t0.overPrice AS overPrice_28, t0.opIva AS opIva_29, t0.iva AS iva_30, t0.dateInAt AS dateInAt_31, t0.dateOutAt AS dateOutAt_32, t0.days AS days_33, t0.subTotalPrice AS subTotalPrice_34, t0.originId AS originId_35, t0.rankAv AS rankAv_36, t0.location AS location_37, t0.packId AS packId_38, t0.priceWithoutPack AS priceWithoutPack_39 FROM ave_package_template_items t0 ORDER BY t0.rankAvPack ASC
SELECT t0.id AS id_1, t0.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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
SELECT t0.id AS id_1, t0.loungeName AS loungeName_2, t0.idLounge AS idLounge_3, t0.dateStart AS dateStart_4, t0.dateEnd AS dateEnd_5, t0.servicePrice AS servicePrice_6, t0.idReservation AS idReservation_7, t0.pax AS pax_8, t0.type AS type_9, t0.createdAt AS createdAt_10, t0.createdBy AS createdBy_11, t0.updatedAt AS updatedAt_12, t0.updatedBy AS updatedBy_13, t0.hourStart AS hourStart_14, t0.minStart AS minStart_15, t0.hourEnd AS hourEnd_16, t0.minEnd AS minEnd_17, t0.rankQuote AS rankQuote_18, t0.op_iva AS op_iva_19, t0.iva AS iva_20, t0.loungeDescription AS loungeDescription_21, t0.importantDescription AS importantDescription_22, t0.importantDescGeneralText AS importantDescGeneralText_23, t0.importantDescSchedules AS importantDescSchedules_24, t0.importantDescParking AS importantDescParking_25, t0.language AS language_26, t0.sent_to_sage AS sent_to_sage_27, t0.breakdown_packages AS breakdown_packages_28, t0.show_audiovisual_price AS show_audiovisual_price_29, t0.show_audiovisual_package AS show_audiovisual_package_30, t0.sage_iva AS sage_iva_31, t0.sage_article_id AS sage_article_id_32 FROM reservation_lounge_simple t0 WHERE t0.idReservation = ? ORDER BY t0.dateStart ASC
SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.supplierId AS supplierId_3, t0.serviceId AS serviceId_4, t0.serviceCatId AS serviceCatId_5, t0.serviceCatName AS serviceCatName_6, t0.name AS name_7, t0.price AS price_8, t0.currency AS currency_9, t0.units AS units_10, t0.opCommission AS opCommission_11, t0.commission AS commission_12, t0.opOver AS opOver_13, t0.price_over AS price_over_14, t0.opIva AS opIva_15, t0.iva AS iva_16, t0.pax AS pax_17, t0.hour AS hour_18, t0.dateInAt AS dateInAt_19, t0.dateOutAt AS dateOutAt_20, t0.contcolor AS contcolor_21, t0.`rank` AS rank_22, t0.assistantId AS assistantId_23, t0.activityId AS activityId_24, t0.pay AS pay_25, t0.createdAt AS createdAt_26, t0.createdId AS createdId_27, t0.updatedAt AS updatedAt_28, t0.updatedId AS updatedId_29, t0.toinvoice AS toinvoice_30, t0.viewInfo AS viewInfo_31, t0.sent_to_sage AS sent_to_sage_32, t0.sage_iva AS sage_iva_33, t0.iva_supplier AS iva_supplier_34, t35.id AS id_36, t35.lounge_other AS lounge_other_37, t35.date_start AS date_start_38, t35.hour_end AS hour_end_39, t35.gratitudes AS gratitudes_40, t35.created_at AS created_at_41, t35.updated_at AS updated_at_42, t35.pax AS pax_43, t35.observation AS observation_44, t35.type AS type_45, t35.reservation_service_id AS reservation_service_id_46, t35.lounge_gp_id AS lounge_gp_id_47, t35.created_id_id AS created_id_id_48, t35.updated_id_id AS updated_id_id_49, t35.ht_file_id AS ht_file_id_50, t0.sage_article_id AS sage_article_id_51, t0.sage_article_supplier_id AS sage_article_supplier_id_52 FROM reservation_service t0 LEFT JOIN ht_item t35 ON t35.reservation_service_id = t0.id WHERE t0.reservationId = ? AND t0.toinvoice = ?
SELECT t0.id AS id_1, t0.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
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
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
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
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.54 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.41 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.breakdown_packages AS breakdown_packages_26, t0.show_package_price AS show_package_price_27, t0.infoFormWeb AS infoFormWeb_28, t0.mailToClient AS mailToClient_29, t0.client_id AS client_id_30, t31.id AS id_32, t31.title AS title_33, t31.status AS status_34, t31.days_block AS days_block_35, t31.pax AS pax_36, t31.description AS description_37, t31.description_two AS description_two_38, t31.contact_unregistered AS contact_unregistered_39, t31.name_contact_unregistered AS name_contact_unregistered_40, t31.phone_contact_unregistered AS phone_contact_unregistered_41, t31.date_start AS date_start_42, t31.date_end AS date_end_43, t31.created_at AS created_at_44, t31.updated_at AS updated_at_45, t31.client_type AS client_type_46, t31.client_id AS client_id_47, t31.created_id_id AS created_id_id_48, t31.updated_id_id AS updated_id_id_49, t31.client_contact_id AS client_contact_id_50, t31.reservation_id AS reservation_id_51, t52.id AS id_53, t52.title AS title_54, t52.client AS client_55, t52.priority AS priority_56, t52.supplier AS supplier_57, t52.status AS status_58, t52.daysBlock AS daysBlock_59, t52.advancePayment AS advancePayment_60, t52.idProposal AS idProposal_61, t52.cateringName AS cateringName_62, t52.boolCatering AS boolCatering_63, t52.dateStart AS dateStart_64, t52.dateEnd AS dateEnd_65, t52.pax AS pax_66, t52.deposit AS deposit_67, t52.access_key AS access_key_68, t52.description AS description_69, t52.destinoId AS destinoId_70, t52.createdAt AS createdAt_71, t52.createdId AS createdId_72, t52.updatedAt AS updatedAt_73, t52.updatedId AS updatedId_74, t52.comments AS comments_75, t52.comments_in_inv AS comments_in_inv_76, t52.comments_in_pro AS comments_in_pro_77, t52.xtra_field_one AS xtra_field_one_78, t52.xtra_field_two AS xtra_field_two_79, t52.reservation_id AS reservation_id_80 FROM reservation t0 LEFT JOIN ht_file t31 ON t31.reservation_id = t0.id LEFT JOIN ave_files t52 ON t52.reservation_id = t0.id WHERE t0.token = ? LIMIT 1 Parameters: [`"6a96f52926bb4"`] 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.breakdown_packages AS breakdown_packages_26, t0.show_package_price AS show_package_price_27, t0.infoFormWeb AS infoFormWeb_28, t0.mailToClient AS mailToClient_29, t0.client_id AS client_id_30, t31.id AS id_32, t31.title AS title_33, t31.status AS status_34, t31.days_block AS days_block_35, t31.pax AS pax_36, t31.description AS description_37, t31.description_two AS description_two_38, t31.contact_unregistered AS contact_unregistered_39, t31.name_contact_unregistered AS name_contact_unregistered_40, t31.phone_contact_unregistered AS phone_contact_unregistered_41, t31.date_start AS date_start_42, t31.date_end AS date_end_43, t31.created_at AS created_at_44, t31.updated_at AS updated_at_45, t31.client_type AS client_type_46, t31.client_id AS client_id_47, t31.created_id_id AS created_id_id_48, t31.updated_id_id AS updated_id_id_49, t31.client_contact_id AS client_contact_id_50, t31.reservation_id AS reservation_id_51, t52.id AS id_53, t52.title AS title_54, t52.client AS client_55, t52.priority AS priority_56, t52.supplier AS supplier_57, t52.status AS status_58, t52.daysBlock AS daysBlock_59, t52.advancePayment AS advancePayment_60, t52.idProposal AS idProposal_61, t52.cateringName AS cateringName_62, t52.boolCatering AS boolCatering_63, t52.dateStart AS dateStart_64, t52.dateEnd AS dateEnd_65, t52.pax AS pax_66, t52.deposit AS deposit_67, t52.access_key AS access_key_68, t52.description AS description_69, t52.destinoId AS destinoId_70, t52.createdAt AS createdAt_71, t52.createdId AS createdId_72, t52.updatedAt AS updatedAt_73, t52.updatedId AS updatedId_74, t52.comments AS comments_75, t52.comments_in_inv AS comments_in_inv_76, t52.comments_in_pro AS comments_in_pro_77, t52.xtra_field_one AS xtra_field_one_78, t52.xtra_field_two AS xtra_field_two_79, t52.reservation_id AS reservation_id_80 FROM reservation t0 LEFT JOIN ht_file t31 ON t31.reservation_id = t0.id LEFT JOIN ave_files t52 ON t52.reservation_id = t0.id WHERE t0.token = ? LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.clientContact AS clientContact_3, t0.contactUnregistered AS contactUnregistered_4, t0.nameContactUnregistered AS nameContactUnregistered_5, t0.phoneContactUnregistered AS phoneContactUnregistered_6, t0.days AS days_7, t0.createdAt AS createdAt_8, t0.priority AS priority_9, t0.createdBy AS createdBy_10, t0.supplier AS supplier_11, t0.status AS status_12, t0.updatedAt AS updatedAt_13, t0.updatedBy AS updatedBy_14, t0.daysBlock AS daysBlock_15, t0.dateStart AS dateStart_16, t0.dateEnd AS dateEnd_17, t0.pax AS pax_18, t0.access_key AS access_key_19, t0.description AS description_20, t0.contract AS contract_21, t0.token AS token_22, t0.comAvGp AS comAvGp_23, t0.comHtGp AS comHtGp_24, t0.sucoe AS sucoe_25, t0.breakdown_packages AS breakdown_packages_26, t0.show_package_price AS show_package_price_27, t0.infoFormWeb AS infoFormWeb_28, t0.mailToClient AS mailToClient_29, t0.client_id AS client_id_30, t31.id AS id_32, t31.title AS title_33, t31.status AS status_34, t31.days_block AS days_block_35, t31.pax AS pax_36, t31.description AS description_37, t31.description_two AS description_two_38, t31.contact_unregistered AS contact_unregistered_39, t31.name_contact_unregistered AS name_contact_unregistered_40, t31.phone_contact_unregistered AS phone_contact_unregistered_41, t31.date_start AS date_start_42, t31.date_end AS date_end_43, t31.created_at AS created_at_44, t31.updated_at AS updated_at_45, t31.client_type AS client_type_46, t31.client_id AS client_id_47, t31.created_id_id AS created_id_id_48, t31.updated_id_id AS updated_id_id_49, t31.client_contact_id AS client_contact_id_50, t31.reservation_id AS reservation_id_51, t52.id AS id_53, t52.title AS title_54, t52.client AS client_55, t52.priority AS priority_56, t52.supplier AS supplier_57, t52.status AS status_58, t52.daysBlock AS daysBlock_59, t52.advancePayment AS advancePayment_60, t52.idProposal AS idProposal_61, t52.cateringName AS cateringName_62, t52.boolCatering AS boolCatering_63, t52.dateStart AS dateStart_64, t52.dateEnd AS dateEnd_65, t52.pax AS pax_66, t52.deposit AS deposit_67, t52.access_key AS access_key_68, t52.description AS description_69, t52.destinoId AS destinoId_70, t52.createdAt AS createdAt_71, t52.createdId AS createdId_72, t52.updatedAt AS updatedAt_73, t52.updatedId AS updatedId_74, t52.comments AS comments_75, t52.comments_in_inv AS comments_in_inv_76, t52.comments_in_pro AS comments_in_pro_77, t52.xtra_field_one AS xtra_field_one_78, t52.xtra_field_two AS xtra_field_two_79, t52.reservation_id AS reservation_id_80 FROM reservation t0 LEFT JOIN ht_file t31 ON t31.reservation_id = t0.id LEFT JOIN ave_files t52 ON t52.reservation_id = t0.id WHERE t0.token = '6a96f52926bb4' LIMIT 1;
3	0.31 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, t0.internal_price AS internal_price_11, t0.pricePackage AS pricePackage_12 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, t0.internal_price AS internal_price_11, t0.pricePackage AS pricePackage_12 FROM ave_package_template t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.total_net_price AS total_net_price_4, t0.createdAt AS createdAt_5, t0.createdId AS createdId_6, t0.updatedAt AS updatedAt_7, t0.updatedId AS updatedId_8, t0.aveProductFileId AS aveProductFileId_9, t0.is_featured AS is_featured_10, t0.internal_price AS internal_price_11, t0.pricePackage AS pricePackage_12 FROM ave_package_template t0;
4	0.41 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 ORDER BY t0.rankAvPack ASC Parameters: [] 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 ORDER BY t0.rankAvPack ASC SELECT t0.id AS id_1, t0.productName AS productName_2, t0.percProductPrice AS percProductPrice_3, t0.rankAvPack AS rankAvPack_4, t0.productId AS productId_5, t0.dateStart AS dateStart_6, t0.dateEnd AS dateEnd_7, t0.servicePrice AS servicePrice_8, t0.fileId AS fileId_9, t0.pax AS pax_10, t0.type AS type_11, t0.hourStart AS hourStart_12, t0.minStart AS minStart_13, t0.hourEnd AS hourEnd_14, t0.minEnd AS minEnd_15, t0.description AS description_16, t0.createdAt AS createdAt_17, t0.createdId AS createdId_18, t0.updatedAt AS updatedAt_19, t0.updatedId AS updatedId_20, t0.supplierExt AS supplierExt_21, t0.supplierExtId AS supplierExtId_22, t0.currency AS currency_23, t0.units AS units_24, t0.opCommission AS opCommission_25, t0.commission AS commission_26, t0.opOver AS opOver_27, t0.overPrice AS overPrice_28, t0.opIva AS opIva_29, t0.iva AS iva_30, t0.dateInAt AS dateInAt_31, t0.dateOutAt AS dateOutAt_32, t0.days AS days_33, t0.subTotalPrice AS subTotalPrice_34, t0.originId AS originId_35, t0.rankAv AS rankAv_36, t0.location AS location_37, t0.packId AS packId_38, t0.priceWithoutPack AS priceWithoutPack_39 FROM ave_package_template_items t0 ORDER BY t0.rankAvPack ASC;
5	0.32 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;
6	0.15 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.13 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;
8	0.12 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;
9	0.13 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;
10	0.13 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: [`28`] 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 = 28;
11	0.23 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: [`29`] 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 = 29;
12	0.17 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: [`30`] 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 = 30;
13	0.18 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: [`31`] 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 = 31;
14	0.13 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: [`32`] 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 = 32;
15	0.19 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: [`33`] 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 = 33;
16	0.15 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: [`35`] 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 = 35;
17	0.39 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.breakdown_packages AS breakdown_packages_28, t0.show_audiovisual_price AS show_audiovisual_price_29, t0.show_audiovisual_package AS show_audiovisual_package_30, t0.sage_iva AS sage_iva_31, t0.sage_article_id AS sage_article_id_32 FROM reservation_lounge_simple t0 WHERE t0.idReservation = ? ORDER BY t0.dateStart ASC Parameters: [`17333`] 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.breakdown_packages AS breakdown_packages_28, t0.show_audiovisual_price AS show_audiovisual_price_29, t0.show_audiovisual_package AS show_audiovisual_package_30, t0.sage_iva AS sage_iva_31, t0.sage_article_id AS sage_article_id_32 FROM reservation_lounge_simple t0 WHERE t0.idReservation = ? ORDER BY t0.dateStart ASC SELECT t0.id AS id_1, t0.loungeName AS loungeName_2, t0.idLounge AS idLounge_3, t0.dateStart AS dateStart_4, t0.dateEnd AS dateEnd_5, t0.servicePrice AS servicePrice_6, t0.idReservation AS idReservation_7, t0.pax AS pax_8, t0.type AS type_9, t0.createdAt AS createdAt_10, t0.createdBy AS createdBy_11, t0.updatedAt AS updatedAt_12, t0.updatedBy AS updatedBy_13, t0.hourStart AS hourStart_14, t0.minStart AS minStart_15, t0.hourEnd AS hourEnd_16, t0.minEnd AS minEnd_17, t0.rankQuote AS rankQuote_18, t0.op_iva AS op_iva_19, t0.iva AS iva_20, t0.loungeDescription AS loungeDescription_21, t0.importantDescription AS importantDescription_22, t0.importantDescGeneralText AS importantDescGeneralText_23, t0.importantDescSchedules AS importantDescSchedules_24, t0.importantDescParking AS importantDescParking_25, t0.language AS language_26, t0.sent_to_sage AS sent_to_sage_27, t0.breakdown_packages AS breakdown_packages_28, t0.show_audiovisual_price AS show_audiovisual_price_29, t0.show_audiovisual_package AS show_audiovisual_package_30, t0.sage_iva AS sage_iva_31, t0.sage_article_id AS sage_article_id_32 FROM reservation_lounge_simple t0 WHERE t0.idReservation = 17333 ORDER BY t0.dateStart ASC;
18	0.34 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 = ? AND t0.toinvoice = ? Parameters: [`17333 1`] 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 = ? AND t0.toinvoice = ? SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.supplierId AS supplierId_3, t0.serviceId AS serviceId_4, t0.serviceCatId AS serviceCatId_5, t0.serviceCatName AS serviceCatName_6, t0.name AS name_7, t0.price AS price_8, t0.currency AS currency_9, t0.units AS units_10, t0.opCommission AS opCommission_11, t0.commission AS commission_12, t0.opOver AS opOver_13, t0.price_over AS price_over_14, t0.opIva AS opIva_15, t0.iva AS iva_16, t0.pax AS pax_17, t0.hour AS hour_18, t0.dateInAt AS dateInAt_19, t0.dateOutAt AS dateOutAt_20, t0.contcolor AS contcolor_21, t0.`rank` AS rank_22, t0.assistantId AS assistantId_23, t0.activityId AS activityId_24, t0.pay AS pay_25, t0.createdAt AS createdAt_26, t0.createdId AS createdId_27, t0.updatedAt AS updatedAt_28, t0.updatedId AS updatedId_29, t0.toinvoice AS toinvoice_30, t0.viewInfo AS viewInfo_31, t0.sent_to_sage AS sent_to_sage_32, t0.sage_iva AS sage_iva_33, t0.iva_supplier AS iva_supplier_34, t35.id AS id_36, t35.lounge_other AS lounge_other_37, t35.date_start AS date_start_38, t35.hour_end AS hour_end_39, t35.gratitudes AS gratitudes_40, t35.created_at AS created_at_41, t35.updated_at AS updated_at_42, t35.pax AS pax_43, t35.observation AS observation_44, t35.type AS type_45, t35.reservation_service_id AS reservation_service_id_46, t35.lounge_gp_id AS lounge_gp_id_47, t35.created_id_id AS created_id_id_48, t35.updated_id_id AS updated_id_id_49, t35.ht_file_id AS ht_file_id_50, t0.sage_article_id AS sage_article_id_51, t0.sage_article_supplier_id AS sage_article_supplier_id_52 FROM reservation_service t0 LEFT JOIN ht_item t35 ON t35.reservation_service_id = t0.id WHERE t0.reservationId = 17333 AND t0.toinvoice = 1;
19	0.16 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 de Cristal"`] 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 de Cristal' LIMIT 1;
20	0.21 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: [`13`] 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 = 13;
21	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: [`13`] 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 = 13;
22	0.15 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: [`13`] 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 = 13 LIMIT 1;
23	0.14 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 25"`] 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 25' LIMIT 1;
24	0.15 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: [`19`] 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 = 19;
25	0.11 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: [`19`] 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 = 19;
26	0.15 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: [`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 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 = 19 LIMIT 1;
27	0.14 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 White en exclusiva"`] 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 White en exclusiva' LIMIT 1;
28	0.10 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: [`24`] 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 = 24;
29	0.10 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: [`24`] 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 = 24;
30	0.11 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: [`24`] 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 = 24 LIMIT 1;
31	0.16 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 Black"`] 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 Black' LIMIT 1;
32	0.14 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: [`25`] 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 = 25;
33	0.11 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: [`25`] 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 = 25;
34	0.15 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: [`25`] 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 = 25 LIMIT 1;
35	0.12 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: [`"Legends La Quinta Planta"`] 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 = 'Legends La Quinta Planta' LIMIT 1;
36	0.11 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: [`44`] 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 = 44;
37	0.09 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: [`44`] 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 = 44;
38	0.10 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: [`44`] 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 = 44 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\AveProduct	No errors.
App\MDS\AvexpressBundle\Entity\AvePackageTemplateItems	No errors.
App\Entity\ReservationLoungeWebDescription	No errors.
App\MDS\VenuesBundle\Entity\ReservationLoungeSimple	No errors.
App\Entity\SageVatRates	No errors.
App\Entity\SageArticle	No errors.
App\MDS\VenuesBundle\Entity\ReservationService	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/6a96f52926bb4

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping