https://inout.mante.solutions/reservations-greenpatio/update/12024

Query Metrics

1 Database Queries
1 Different statements
0.98 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.98 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.id = ? LIMIT 1
Parameters:
[
  "12024"
]

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\Entity\HtMenu
  • The association App\Entity\HtMenu#htItem refers to the inverse side field App\Entity\HtItem#htMenu which does not exist.
App\Entity\HtExtra No errors.
App\Entity\HtNote No errors.