https://venues.mante.solutions/venues/editvisit/5

Query Metrics

27 Database Queries
12 Different statements
7.18 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.44 ms
(20.04%)
8
SELECT t0.id AS id_1, t0.title AS title_2, t0.client AS client_3, t0.priority AS priority_4, t0.supplier AS supplier_5, t0.status AS status_6, t0.daysBlock AS daysBlock_7, t0.advancePayment AS advancePayment_8, t0.idProposal AS idProposal_9, t0.cateringName AS cateringName_10, t0.boolCatering AS boolCatering_11, t0.dateStart AS dateStart_12, t0.dateEnd AS dateEnd_13, t0.pax AS pax_14, t0.deposit AS deposit_15, t0.access_key AS access_key_16, t0.description AS description_17, t0.destinoId AS destinoId_18, t0.createdAt AS createdAt_19, t0.createdId AS createdId_20, t0.updatedAt AS updatedAt_21, t0.updatedId AS updatedId_22, t0.comments AS comments_23, t0.comments_in_inv AS comments_in_inv_24, t0.comments_in_pro AS comments_in_pro_25, t0.xtra_field_one AS xtra_field_one_26, t0.xtra_field_two AS xtra_field_two_27, t0.reservation_id AS reservation_id_28 FROM ave_files t0 WHERE t0.reservation_id = ?
Parameters:
[
  11
]
1.44 ms
(20.02%)
2
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.movil_password AS movil_password_6, t0.pass_gmail AS pass_gmail_7, t0.firm_gmail AS firm_gmail_8, t0.name AS name_9, t0.last_name AS last_name_10, t0.telephone AS telephone_11, t0.mobile AS mobile_12, t0.status AS status_13, t0.team_leader AS team_leader_14, t0.role AS role_15, t0.access_key AS access_key_16, t0.language AS language_17, t0.color AS color_18, t0.sidebar AS sidebar_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.description AS description_22, t0.job_title AS job_title_23, t0.id_office AS id_office_24, t0.id_company AS id_company_25, t0.id_user_rol AS id_user_rol_26, t0.id_team AS id_team_27 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "carlos.romero@develup.solutions"
]
1.38 ms
(19.25%)
8
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.created_id_id AS created_id_id_17, t0.updated_id_id AS updated_id_id_18, t0.client_contact_id AS client_contact_id_19, t0.reservation_id AS reservation_id_20 FROM ht_file t0 WHERE t0.reservation_id = ?
Parameters:
[
  11
]
0.49 ms
(6.81%)
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.client_id AS client_id_26, t27.id AS id_28, t27.title AS title_29, t27.status AS status_30, t27.days_block AS days_block_31, t27.pax AS pax_32, t27.description AS description_33, t27.description_two AS description_two_34, t27.contact_unregistered AS contact_unregistered_35, t27.name_contact_unregistered AS name_contact_unregistered_36, t27.phone_contact_unregistered AS phone_contact_unregistered_37, t27.date_start AS date_start_38, t27.date_end AS date_end_39, t27.created_at AS created_at_40, t27.updated_at AS updated_at_41, t27.client_type AS client_type_42, t27.client_id AS client_id_43, t27.created_id_id AS created_id_id_44, t27.updated_id_id AS updated_id_id_45, t27.client_contact_id AS client_contact_id_46, t27.reservation_id AS reservation_id_47, t48.id AS id_49, t48.title AS title_50, t48.client AS client_51, t48.priority AS priority_52, t48.supplier AS supplier_53, t48.status AS status_54, t48.daysBlock AS daysBlock_55, t48.advancePayment AS advancePayment_56, t48.idProposal AS idProposal_57, t48.cateringName AS cateringName_58, t48.boolCatering AS boolCatering_59, t48.dateStart AS dateStart_60, t48.dateEnd AS dateEnd_61, t48.pax AS pax_62, t48.deposit AS deposit_63, t48.access_key AS access_key_64, t48.description AS description_65, t48.destinoId AS destinoId_66, t48.createdAt AS createdAt_67, t48.createdId AS createdId_68, t48.updatedAt AS updatedAt_69, t48.updatedId AS updatedId_70, t48.comments AS comments_71, t48.comments_in_inv AS comments_in_inv_72, t48.comments_in_pro AS comments_in_pro_73, t48.xtra_field_one AS xtra_field_one_74, t48.xtra_field_two AS xtra_field_two_75, t48.reservation_id AS reservation_id_76 FROM reservation t0 LEFT JOIN ht_file t27 ON t27.reservation_id = t0.id LEFT JOIN ave_files t48 ON t48.reservation_id = t0.id WHERE t0.id = ?
Parameters:
[
  7
]
0.40 ms
(5.59%)
1
SELECT u0_.id AS id_0, u0_.picture AS picture_1, u0_.username AS username_2, u0_.email AS email_3, u0_.password AS password_4, u0_.movil_password AS movil_password_5, u0_.pass_gmail AS pass_gmail_6, u0_.firm_gmail AS firm_gmail_7, u0_.name AS name_8, u0_.last_name AS last_name_9, u0_.telephone AS telephone_10, u0_.mobile AS mobile_11, u0_.status AS status_12, u0_.team_leader AS team_leader_13, u0_.role AS role_14, u0_.access_key AS access_key_15, u0_.language AS language_16, u0_.color AS color_17, u0_.sidebar AS sidebar_18, u0_.created_at AS created_at_19, u0_.updated_at AS updated_at_20, u0_.description AS description_21, u0_.job_title AS job_title_22, u0_.id_office AS id_office_23, u0_.id_company AS id_company_24, u0_.id_user_rol AS id_user_rol_25, u0_.id_team AS id_team_26 FROM users u0_ WHERE u0_.id_team IN (?, ?)
Parameters:
[
  4
  16
]
0.39 ms
(5.45%)
1
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:
[]
0.38 ms
(5.22%)
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 = ?
Parameters:
[
  6
]
0.35 ms
(4.86%)
1
SELECT t0.id AS id_1, t0.clientId AS clientId_2, t0.clientName AS clientName_3, t0.title AS title_4, t0.idLounge AS idLounge_5, t0.dateStart AS dateStart_6, t0.dateEnd AS dateEnd_7, t0.servicePrice AS servicePrice_8, t0.idReservation AS idReservation_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.createdAt AS createdAt_16, t0.createdId AS createdId_17, t0.updatedAt AS updatedAt_18, t0.updatedId AS updatedId_19, t0.idLoungeDetails AS idLoungeDetails_20, t0.agentId AS agentId_21, t0.space_id AS space_id_22 FROM reservation_visit t0 WHERE t0.id = ?
Parameters:
[
  5
]
0.28 ms
(3.85%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.billing_series AS billing_series_2, s0_.is_main AS is_main_3, s0_.rectifying_billing_series AS rectifying_billing_series_4, s0_.iva AS iva_5 FROM space s0_
Parameters:
[]
0.23 ms
(3.22%)
1
SELECT t0.id AS id_1, t0.access_type AS access_type_2, t0.name AS name_3, t0.primary_color AS primary_color_4, t0.secondary_color AS secondary_color_5, t0.accent_color AS accent_color_6, t0.logo_path AS logo_path_7, t0.is_active AS is_active_8 FROM settings_branding t0 WHERE t0.access_type = ? LIMIT 1
Parameters:
[
  "venues"
]
0.21 ms
(2.95%)
1
SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.dateStart AS dateStart_2, r0_.client_id AS client_id_3 FROM reservation r0_ WHERE r0_.dateStart >= ? OR r0_.id = ? ORDER BY r0_.dateStart ASC
Parameters:
[
  "2026-05-26 00:00:00"
  7
]
0.20 ms
(2.74%)
1
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.created_id AS created_id_2, r0_.created_at AS created_at_3, r0_.updated_id AS updated_id_4, r0_.updated_at AS updated_at_5, r0_.meters AS meters_6, r0_.length AS length_7, r0_.width AS width_8, r0_.height AS height_9, r0_.cap_school AS cap_school_10, r0_.cap_theater AS cap_theater_11, r0_.cap_cocktail AS cap_cocktail_12, r0_.cap_banquet AS cap_banquet_13, r0_.cap_imperial AS cap_imperial_14, r0_.rank_lounge AS rank_lounge_15, r0_.combo AS combo_16, r0_.importantDescription AS importantDescription_17, r0_.importantDescGeneralText AS importantDescGeneralText_18, r0_.importantDescSchedules AS importantDescSchedules_19, r0_.importantDescParking AS importantDescParking_20, r0_.space_id AS space_id_21 FROM reservation_lounge_details r0_ WHERE r0_.space_id = ? ORDER BY r0_.name ASC
Parameters:
[
  2
]

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.