https://inout.mante.solutions/higotrigo/ht/file/htexternal/3521/summary

Query Metrics

46 Database Queries
8 Different statements
11.36 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.95 ms
(34.80%)
24
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
  18
]
2.22 ms
(19.56%)
8
SELECT t0.id AS id_1, t0.total_ten_pax AS total_ten_pax_2, t0.coste_pax AS coste_pax_3, t0.pvp AS pvp_4, t0.pvp_not_vat AS pvp_not_vat_5, t0.coste_directo_perc AS coste_directo_perc_6, t0.beneficio AS beneficio_7, t0.foto AS foto_8, t0.decription AS decription_9, t0.observaciones AS observaciones_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.nombre AS nombre_13, t0.escandallo_pax AS escandallo_pax_14, t0.created_id_id AS created_id_id_15, t0.updated_id_id AS updated_id_id_16, t0.family_escandallo_id AS family_escandallo_id_17 FROM escandallo t0 INNER JOIN ht_menu_escandallo ON t0.id = ht_menu_escandallo.escandallo_id WHERE ht_menu_escandallo.ht_menu_id = ?
Parameters:
[
  2294
]
1.84 ms
(16.18%)
8
SELECT t0.id AS id_1, t0.beneficio AS beneficio_2, t0.total_price AS total_price_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.template AS template_6, t0.name AS name_7, t0.iva AS iva_8, t0.created_id_id AS created_id_id_9, t0.updated_id_id AS updated_id_id_10, t0.ht_item_id AS ht_item_id_11 FROM ht_menu t0 WHERE t0.ht_item_id = ?
Parameters:
[
  2473
]
1.19 ms
(10.48%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.status AS status_3, t0.days_block AS days_block_4, t0.pax AS pax_5, t0.description AS description_6, t0.description_two AS description_two_7, t0.contact_unregistered AS contact_unregistered_8, t0.name_contact_unregistered AS name_contact_unregistered_9, t0.phone_contact_unregistered AS phone_contact_unregistered_10, t0.date_start AS date_start_11, t0.date_end AS date_end_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.client_type AS client_type_15, t0.client_id AS client_id_16, t0.proposal_id AS proposal_id_17, t0.created_id_id AS created_id_id_18, t0.updated_id_id AS updated_id_id_19, t0.client_contact_id AS client_contact_id_20, t0.reservation_id AS reservation_id_21 FROM ht_file t0 WHERE t0.id = ?
Parameters:
[
  "3521"
]
0.73 ms
(6.43%)
1
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, t0.infoFormWeb AS infoFormWeb_31, t32.id AS id_33, t32.title AS title_34, t32.status AS status_35, t32.days_block AS days_block_36, t32.pax AS pax_37, t32.description AS description_38, t32.description_two AS description_two_39, t32.contact_unregistered AS contact_unregistered_40, t32.name_contact_unregistered AS name_contact_unregistered_41, t32.phone_contact_unregistered AS phone_contact_unregistered_42, t32.date_start AS date_start_43, t32.date_end AS date_end_44, t32.created_at AS created_at_45, t32.updated_at AS updated_at_46, t32.client_type AS client_type_47, t32.client_id AS client_id_48, t32.proposal_id AS proposal_id_49, t32.created_id_id AS created_id_id_50, t32.updated_id_id AS updated_id_id_51, t32.client_contact_id AS client_contact_id_52, t32.reservation_id AS reservation_id_53 FROM reservation t0 LEFT JOIN ht_file t32 ON t32.reservation_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  13640
]
0.59 ms
(5.19%)
2
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 = ? AND t0.type = ? LIMIT 1
Parameters:
[
  13640
  "Montaje"
]
0.42 ms
(3.69%)
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 FROM reservation_lounge_details t0 WHERE t0.id = ?
Parameters:
[
  25
]
0.42 ms
(3.67%)
1
SELECT t0.id AS id_1, t0.lounge_other AS lounge_other_2, t0.date_start AS date_start_3, t0.hour_end AS hour_end_4, t0.gratitudes AS gratitudes_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.pax AS pax_8, t0.observation AS observation_9, t0.type AS type_10, t0.reservation_service_id AS reservation_service_id_11, t0.lounge_gp_id AS lounge_gp_id_12, t0.created_id_id AS created_id_id_13, t0.updated_id_id AS updated_id_id_14, t0.ht_file_id AS ht_file_id_15 FROM ht_item t0 WHERE t0.ht_file_id = ?
Parameters:
[
  3521
]

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\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\MDS\GreenPatioBundle\Entity\Reservation 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.
App\Entity\ReservationLoungeWebDescription No errors.
App\Entity\Escandallo No errors.
App\Entity\FamilyEscandallo No errors.
App\Entity\EscandalloProduct No errors.
App\Entity\GpReminder No errors.
App\MDS\GreenPatioBundle\Entity\ReservationLoungeSimple No errors.