https://inout.mante.solutions/api/client/proposal/685bdcaeb9f37

Query Metrics

29 Database Queries
8 Different statements
5.49 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.90 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.client AS client_3, t0.clientContact AS clientContact_4, t0.contactUnregistered AS contactUnregistered_5, t0.nameContactUnregistered AS nameContactUnregistered_6, t0.phoneContactUnregistered AS phoneContactUnregistered_7, t0.days AS days_8, t0.createdAt AS createdAt_9, t0.priority AS priority_10, t0.createdBy AS createdBy_11, t0.supplier AS supplier_12, t0.status AS status_13, t0.updatedAt AS updatedAt_14, t0.updatedBy AS updatedBy_15, t0.daysBlock AS daysBlock_16, t0.advancePayment AS advancePayment_17, t0.idProposal AS idProposal_18, t0.cateringName AS cateringName_19, t0.boolCatering AS boolCatering_20, t0.dateStart AS dateStart_21, t0.dateEnd AS dateEnd_22, t0.pax AS pax_23, t0.deposit AS deposit_24, t0.access_key AS access_key_25, t0.description AS description_26, t0.contract AS contract_27, t0.token AS token_28, t0.comAvGp AS comAvGp_29, t0.comHtGp AS comHtGp_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.proposal_id AS proposal_id_48, t31.created_id_id AS created_id_id_49, t31.updated_id_id AS updated_id_id_50, t31.client_contact_id AS client_contact_id_51, t31.reservation_id AS reservation_id_52 FROM reservation t0 LEFT JOIN ht_file t31 ON t31.reservation_id = t0.id WHERE t0.token = ? LIMIT 1
Parameters:
[
  "685bdcaeb9f37"
]
2 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, t32.id AS id_33, t32.lounge_other AS lounge_other_34, t32.date_start AS date_start_35, t32.hour_end AS hour_end_36, t32.gratitudes AS gratitudes_37, t32.created_at AS created_at_38, t32.updated_at AS updated_at_39, t32.pax AS pax_40, t32.observation AS observation_41, t32.type AS type_42, t32.reservation_service_id AS reservation_service_id_43, t32.lounge_gp_id AS lounge_gp_id_44, t32.created_id_id AS created_id_id_45, t32.updated_id_id AS updated_id_id_46, t32.ht_file_id AS ht_file_id_47 FROM reservation_service t0 LEFT JOIN ht_item t32 ON t32.reservation_service_id = t0.id WHERE t0.reservationId = ?
Parameters:
[
  12311
]
3 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 FROM reservation_lounge_simple t0 WHERE t0.idReservation = ?
Parameters:
[
  12311
]
4 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 FROM reservation_lounge_details t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Sala White en exclusiva"
]
5 0.22 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
]
6 0.38 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
]
7 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_id AS created_id_3, t0.created_at AS created_at_4, t0.updated_id AS updated_id_5, t0.updated_at AS updated_at_6, t0.meters AS meters_7, t0.length AS length_8, t0.width AS width_9, t0.height AS height_10, t0.cap_school AS cap_school_11, t0.cap_theater AS cap_theater_12, t0.cap_cocktail AS cap_cocktail_13, t0.cap_banquet AS cap_banquet_14, t0.cap_imperial AS cap_imperial_15, t0.rank_lounge AS rank_lounge_16, t0.combo AS combo_17, t0.importantDescription AS importantDescription_18, t0.importantDescGeneralText AS importantDescGeneralText_19, t0.importantDescSchedules AS importantDescSchedules_20, t0.importantDescParking AS importantDescParking_21 FROM reservation_lounge_details t0 WHERE t0.id = ?
Parameters:
[
  "22"
]
8 0.16 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:
[
  22
]
9 0.15 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:
[
  22
]
10 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 FROM reservation_lounge_details t0 WHERE t0.id = ?
Parameters:
[
  "23"
]
11 0.12 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:
[
  23
]
12 0.13 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:
[
  23
]
13 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 FROM reservation_lounge_details t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  24
]
14 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 FROM reservation_lounge_details t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Sala White en exclusiva"
]
15 0.13 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
]
16 0.14 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
]
17 0.12 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:
[
  22
]
18 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:
[
  22
]
19 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:
[
  23
]
20 0.12 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:
[
  23
]
21 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 FROM reservation_lounge_details t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  24
]
22 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 FROM reservation_lounge_details t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Sala Black"
]
23 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:
[
  25
]
24 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
]
25 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 FROM reservation_lounge_details t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  25
]
26 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 FROM reservation_lounge_details t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Sala Black"
]
27 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:
[
  25
]
28 0.16 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
]
29 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 FROM reservation_lounge_details t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  25
]

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.