https://inout.mante.solutions/reservations-greenpatio/updateloungegrid Return to referer URL

Query Metrics

76 Database Queries
16 Different statements
74.85 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
26.62 ms
(35.56%)
12
"COMMIT"
Parameters:
[]
11.80 ms
(15.76%)
6
SELECT t0.id AS id_1, t0.contractual_document AS contractual_document_2, t0.company_id AS company_id_3, t0.model_id AS model_id_4, t0.file_id AS file_id_5, t0.client_id AS client_id_6, t0.created_at AS created_at_7, t0.created_id AS created_id_8, t0.updated_at AS updated_at_9, t0.updated_id AS updated_id_10, t0.date_at AS date_at_11, t0.booking_data AS booking_data_12, t0.client_proxy AS client_proxy_13, t0.client_job AS client_job_14 FROM doc_contract t0 WHERE t0.company_id = ? AND t0.file_id = ? AND t0.model_id = ?
Parameters:
[
  7
  "14695"
  16
]
7.79 ms
(10.41%)
1
UPDATE ave_files SET dateStart = ?, dateEnd = ? WHERE id = ?
Parameters:
[
  "2026-02-25 00:00:00"
  "2026-02-25 00:00:00"
  8448
]
4.66 ms
(6.22%)
6
UPDATE reservation_lounge_simple SET dateStart = ?, dateEnd = ?, idReservation = ?, pax = ?, op_iva = ?, updatedAt = ? WHERE id = ?
Parameters:
[
  "2026-02-25 00:00:00"
  "2026-02-25 00:00:00"
  "14695"
  0
  1
  "2026-02-04 07:34:41"
  21407
]
4.07 ms
(5.43%)
7
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:
[
  "14695"
]
3.92 ms
(5.23%)
6
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.id = ? LIMIT 1
Parameters:
[
  21407
]
3.06 ms
(4.09%)
12
"START TRANSACTION"
Parameters:
[]
2.66 ms
(3.55%)
6
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:
[
  "Combo 1 Plenaria Imprenta + Invernadero"
]
2.42 ms
(3.24%)
6
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 = ? LIMIT 1
Parameters:
[
  14695
]
2.21 ms
(2.95%)
6
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.reservation_id = ? LIMIT 1
Parameters:
[
  14695
]
2.11 ms
(2.82%)
2
UPDATE reservation SET dateStart = ?, dateEnd = ? WHERE id = ?
Parameters:
[
  "2999-01-01 00:00:00"
  "2000-01-01 00:00:00"
  14695
]
1.39 ms
(1.85%)
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.id_office AS id_office_13, t0.status AS status_14, t0.id_company AS id_company_15, t0.id_user_rol AS id_user_rol_16, t0.id_team AS id_team_17, t0.team_leader AS team_leader_18, t0.role AS role_19, t0.access_key AS access_key_20, t0.language AS language_21, t0.color AS color_22, t0.vacations AS vacations_23, t0.half_days AS half_days_24, t0.sidebar AS sidebar_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.description AS description_28, t0.job_title AS job_title_29 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "ana.martin@greenpatio.es"
]
0.68 ms
(0.91%)
1
UPDATE ht_file SET date_start = ?, date_end = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "2026-02-25 00:00:00"
  "2026-02-25 00:00:00"
  "2026-02-04 07:34:41"
  4611
]
0.58 ms
(0.77%)
1
UPDATE reservation SET dateEnd = ? WHERE id = ?
Parameters:
[
  "2026-02-26 00:00:00"
  14695
]
0.52 ms
(0.70%)
1
UPDATE ht_file SET date_end = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "2026-02-26 00:00:00"
  "2026-02-04 07:34:41"
  4611
]
0.38 ms
(0.50%)
1
UPDATE ave_files SET dateEnd = ? WHERE id = ?
Parameters:
[
  "2026-02-26 00:00:00"
  8448
]

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