https://inout.mante.solutions/api/client/proposal/6863c85c4ba41

Query Metrics

3 Database Queries
3 Different statements
112.06 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 41.86 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:
[
  "6863c85c4ba41"
]
2 14.46 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:
[
  12371
]
3 55.74 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:
[
  12371
]

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\MDS\GreenPatioBundle\Entity\Reservation No errors.
App\Entity\HtFile No errors.
App\Entity\Client No errors.
App\MDS\EventsBundle\Entity\Proposal No errors.
App\Entity\User No errors.
App\Entity\ClientContact No errors.
App\Entity\GpReminder No errors.
App\Entity\HtItem
  • The mappings App\Entity\HtItem#htMenus and App\Entity\HtMenu#htItem are inconsistent with each other.
App\Entity\HtVisit No errors.
App\MDS\GreenPatioBundle\Entity\ReservationService No errors.
App\MDS\GreenPatioBundle\Entity\ReservationLoungeDetails No errors.
App\MDS\GreenPatioBundle\Entity\ReservationLoungeSimple No errors.