Query Metrics
63
Database Queries
36
Different statements
1379.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
327.55 ms (23.75%) |
3 |
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, t0.sent_to_sage AS sent_to_sage_27, t0.breakdown_packages AS breakdown_packages_28, t0.show_audiovisual_price AS show_audiovisual_price_29, t0.show_audiovisual_package AS show_audiovisual_package_30, t0.sage_iva AS sage_iva_31, t0.sage_article_id AS sage_article_id_32 FROM reservation_lounge_simple t0 WHERE t0.idReservation = ?
Parameters:
[
18149
]
|
|
192.38 ms (13.95%) |
1 |
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, t0.sent_to_sage AS sent_to_sage_27, t0.breakdown_packages AS breakdown_packages_28, t0.show_audiovisual_price AS show_audiovisual_price_29, t0.show_audiovisual_package AS show_audiovisual_package_30, t0.sage_iva AS sage_iva_31, t0.sage_article_id AS sage_article_id_32 FROM reservation_lounge_simple t0 WHERE t0.idLounge = ? AND t0.idReservation = ? AND t0.rankQuote = ? LIMIT 1
Parameters:
[ 41 "18149" "" ] |
|
177.16 ms (12.84%) |
1 |
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, t0.sent_to_sage AS sent_to_sage_27, t0.breakdown_packages AS breakdown_packages_28, t0.show_audiovisual_price AS show_audiovisual_price_29, t0.show_audiovisual_package AS show_audiovisual_package_30, t0.sage_iva AS sage_iva_31, t0.sage_article_id AS sage_article_id_32 FROM reservation_lounge_simple t0 WHERE t0.idLounge = ? AND t0.idReservation = ? LIMIT 1
Parameters:
[ 41 "18149" ] |
|
172.41 ms (12.50%) |
1 |
SELECT r0_.id AS id_0, r0_.loungeName AS loungeName_1, r0_.idLounge AS idLounge_2, r0_.dateStart AS dateStart_3, r0_.dateEnd AS dateEnd_4, r0_.servicePrice AS servicePrice_5, r0_.idReservation AS idReservation_6, r0_.pax AS pax_7, r0_.type AS type_8, r0_.createdAt AS createdAt_9, r0_.createdBy AS createdBy_10, r0_.updatedAt AS updatedAt_11, r0_.updatedBy AS updatedBy_12, r0_.hourStart AS hourStart_13, r0_.minStart AS minStart_14, r0_.hourEnd AS hourEnd_15, r0_.minEnd AS minEnd_16, r0_.rankQuote AS rankQuote_17, r0_.op_iva AS op_iva_18, r0_.iva AS iva_19, r0_.loungeDescription AS loungeDescription_20, r0_.importantDescription AS importantDescription_21, r0_.importantDescGeneralText AS importantDescGeneralText_22, r0_.importantDescSchedules AS importantDescSchedules_23, r0_.importantDescParking AS importantDescParking_24, r0_.language AS language_25, r0_.sent_to_sage AS sent_to_sage_26, r0_.breakdown_packages AS breakdown_packages_27, r0_.show_audiovisual_price AS show_audiovisual_price_28, r0_.show_audiovisual_package AS show_audiovisual_package_29, r1_.id AS id_30, r1_.title AS title_31, r1_.clientContact AS clientContact_32, r1_.contactUnregistered AS contactUnregistered_33, r1_.nameContactUnregistered AS nameContactUnregistered_34, r1_.phoneContactUnregistered AS phoneContactUnregistered_35, r1_.days AS days_36, r1_.createdAt AS createdAt_37, r1_.priority AS priority_38, r1_.createdBy AS createdBy_39, r1_.supplier AS supplier_40, r1_.status AS status_41, r1_.updatedAt AS updatedAt_42, r1_.updatedBy AS updatedBy_43, r1_.daysBlock AS daysBlock_44, r1_.dateStart AS dateStart_45, r1_.dateEnd AS dateEnd_46, r1_.pax AS pax_47, r1_.access_key AS access_key_48, r1_.description AS description_49, r1_.contract AS contract_50, r1_.token AS token_51, r1_.comAvGp AS comAvGp_52, r1_.comHtGp AS comHtGp_53, r1_.sucoe AS sucoe_54, r1_.breakdown_packages AS breakdown_packages_55, r1_.show_package_price AS show_package_price_56, r1_.infoFormWeb AS infoFormWeb_57, r1_.mailToClient AS mailToClient_58, r0_.sage_iva AS sage_iva_59, r0_.sage_article_id AS sage_article_id_60, r1_.client_id AS client_id_61 FROM reservation_lounge_simple r0_ INNER JOIN reservation r1_ ON (r0_.idReservation = r1_.id) WHERE r1_.status IN (?, ?) AND r0_.dateStart <= ? AND r0_.dateEnd >= ? AND r1_.id <> ?
Parameters:
[ "Confirmed" "Invoiced" "2026-12-18 23:59:59" "2026-12-18 00:00:00" 18149 ] |
|
162.86 ms (11.81%) |
1 |
SELECT r0_.id AS id_0, r0_.loungeName AS loungeName_1, r0_.idLounge AS idLounge_2, r0_.dateStart AS dateStart_3, r0_.dateEnd AS dateEnd_4, r0_.servicePrice AS servicePrice_5, r0_.idReservation AS idReservation_6, r0_.pax AS pax_7, r0_.type AS type_8, r0_.createdAt AS createdAt_9, r0_.createdBy AS createdBy_10, r0_.updatedAt AS updatedAt_11, r0_.updatedBy AS updatedBy_12, r0_.hourStart AS hourStart_13, r0_.minStart AS minStart_14, r0_.hourEnd AS hourEnd_15, r0_.minEnd AS minEnd_16, r0_.rankQuote AS rankQuote_17, r0_.op_iva AS op_iva_18, r0_.iva AS iva_19, r0_.loungeDescription AS loungeDescription_20, r0_.importantDescription AS importantDescription_21, r0_.importantDescGeneralText AS importantDescGeneralText_22, r0_.importantDescSchedules AS importantDescSchedules_23, r0_.importantDescParking AS importantDescParking_24, r0_.language AS language_25, r0_.sent_to_sage AS sent_to_sage_26, r0_.breakdown_packages AS breakdown_packages_27, r0_.show_audiovisual_price AS show_audiovisual_price_28, r0_.show_audiovisual_package AS show_audiovisual_package_29, r0_.sage_iva AS sage_iva_30, r0_.sage_article_id AS sage_article_id_31 FROM reservation_lounge_simple r0_ WHERE r0_.idReservation = ? AND ((r0_.dateStart BETWEEN ? AND ?) OR (r0_.dateEnd BETWEEN ? AND ?))
Parameters:
[ 18149 "2026-12-18 00:00:00" "2026-12-18 23:59:59" "2026-12-18 00:00:00" "2026-12-18 23:59:59" ] |
|
98.32 ms (7.13%) |
1 |
SELECT r0_.id AS id_0, r0_.loungeName AS loungeName_1, r0_.idLounge AS idLounge_2, r0_.dateStart AS dateStart_3, r0_.dateEnd AS dateEnd_4, r0_.servicePrice AS servicePrice_5, r0_.idReservation AS idReservation_6, r0_.pax AS pax_7, r0_.type AS type_8, r0_.createdAt AS createdAt_9, r0_.createdBy AS createdBy_10, r0_.updatedAt AS updatedAt_11, r0_.updatedBy AS updatedBy_12, r0_.hourStart AS hourStart_13, r0_.minStart AS minStart_14, r0_.hourEnd AS hourEnd_15, r0_.minEnd AS minEnd_16, r0_.rankQuote AS rankQuote_17, r0_.op_iva AS op_iva_18, r0_.iva AS iva_19, r0_.loungeDescription AS loungeDescription_20, r0_.importantDescription AS importantDescription_21, r0_.importantDescGeneralText AS importantDescGeneralText_22, r0_.importantDescSchedules AS importantDescSchedules_23, r0_.importantDescParking AS importantDescParking_24, r0_.language AS language_25, r0_.sent_to_sage AS sent_to_sage_26, r0_.breakdown_packages AS breakdown_packages_27, r0_.show_audiovisual_price AS show_audiovisual_price_28, r0_.show_audiovisual_package AS show_audiovisual_package_29, r0_.sage_iva AS sage_iva_30, r0_.sage_article_id AS sage_article_id_31 FROM reservation_lounge_simple r0_ WHERE r0_.idReservation = ? ORDER BY r0_.rankQuote ASC
Parameters:
[
"18149"
]
|
|
96.25 ms (6.98%) |
1 |
SELECT MAX(r0_.pax) AS sclr_0 FROM reservation_lounge_simple r0_ WHERE r0_.idReservation = ?
Parameters:
[
18149
]
|
|
49.48 ms (3.59%) |
2 |
SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.rankListing AS rankListing_3, t0.titleOne AS titleOne_4, t0.titleTwo AS titleTwo_5, t0.titleThree AS titleThree_6, t0.dateStart AS dateStart_7, t0.dateEnd AS dateEnd_8, t0.description AS description_9, t0.picture AS picture_10, t0.sourceId AS sourceId_11, t0.sourceType AS sourceType_12, t0.createdAt AS createdAt_13, t0.createdId AS createdId_14, t0.updatedAt AS updatedAt_15, t0.updatedId AS updatedId_16 FROM reservation_agenda_item t0 WHERE t0.reservationId = ? AND t0.sourceType = ? LIMIT 1
Parameters:
[ 18149 "Pax" ] |
|
28.73 ms (2.08%) |
1 |
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, t0.sent_to_sage AS sent_to_sage_32, t0.sage_iva AS sage_iva_33, t0.iva_supplier AS iva_supplier_34, t35.id AS id_36, t35.lounge_other AS lounge_other_37, t35.date_start AS date_start_38, t35.hour_end AS hour_end_39, t35.gratitudes AS gratitudes_40, t35.created_at AS created_at_41, t35.updated_at AS updated_at_42, t35.pax AS pax_43, t35.observation AS observation_44, t35.type AS type_45, t35.reservation_service_id AS reservation_service_id_46, t35.lounge_gp_id AS lounge_gp_id_47, t35.created_id_id AS created_id_id_48, t35.updated_id_id AS updated_id_id_49, t35.ht_file_id AS ht_file_id_50, t0.sage_article_id AS sage_article_id_51, t0.sage_article_supplier_id AS sage_article_supplier_id_52 FROM reservation_service t0 LEFT JOIN ht_item t35 ON t35.reservation_service_id = t0.id WHERE t0.reservationId = ?
Parameters:
[
18149
]
|
|
18.78 ms (1.36%) |
1 |
SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.rankListing AS rankListing_3, t0.titleOne AS titleOne_4, t0.titleTwo AS titleTwo_5, t0.titleThree AS titleThree_6, t0.dateStart AS dateStart_7, t0.dateEnd AS dateEnd_8, t0.description AS description_9, t0.picture AS picture_10, t0.sourceId AS sourceId_11, t0.sourceType AS sourceType_12, t0.createdAt AS createdAt_13, t0.createdId AS createdId_14, t0.updatedAt AS updatedAt_15, t0.updatedId AS updatedId_16 FROM reservation_agenda_item t0 WHERE t0.reservationId = ? AND t0.sourceId = ? AND t0.titleOne = ? AND t0.titleTwo IS NULL AND t0.titleThree IS NULL
Parameters:
[ 18149 34761 "SALAS A UTILIZAR" ] |
|
13.87 ms (1.01%) |
5 |
"COMMIT"
Parameters:
[] |
|
10.50 ms (0.76%) |
1 |
SELECT MAX(r0_.rankListing) AS sclr_0 FROM reservation_agenda_item r0_ WHERE r0_.reservationId = ?
Parameters:
[
18149
]
|
|
7.99 ms (0.58%) |
1 |
SELECT MAX(r0_.rankListing) AS sclr_0 FROM reservation_agenda_item r0_ WHERE r0_.reservationId = ? AND r0_.titleOne = ?
Parameters:
[ 18149 "SALAS A UTILIZAR" ] |
|
2.99 ms (0.22%) |
1 |
INSERT INTO audit_log (module, entity_class, entity_id, entity_label, action, changes, user_id, user_name, user_email, ip_address, route, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "venues" "App\MDS\VenuesBundle\Entity\ReservationLoungeSimple" 34761 "Sala #34761 ("Combo 7 Legends Sala Global + Terraza") en Expediente #18149" "CREATE" "{"loungeName":{"old":null,"new":"Combo 7 Legends Sala Global + Terraza"},"idLounge":{"old":null,"new":41},"dateStart":{"old":null,"new":"18\/12\/2026 00:00:00"},"dateEnd":{"old":null,"new":"18\/12\/2026 23:59:00"},"servicePrice":{"old":null,"new":2000},"idReservation":{"old":null,"new":18149},"pax":{"old":null,"new":40},"hourStart":{"old":null,"new":"00"},"minStart":{"old":null,"new":"00"},"hourEnd":{"old":null,"new":"23"},"minEnd":{"old":null,"new":"59"},"rankQuote":{"old":null,"new":4},"opIva":{"old":null,"new":1},"importantDescription":{"old":null,"new":"<ul><li><font face=\"Verdana\"><u style=\"font-weight: bold;\">SALA GLOBAL: <\/u>Para la reunión\/presentación <\/font><\/li><\/ul><p><font face=\"Verdana\">Situada en la 4ta planta, la Sala Global es un espacio\r\nmoderno, luminoso y totalmente adaptable a las\r\nnecesidades de cada evento. Dispone de un sistema panelable que permite\r\nconfigurar el espacio en distintos formatos,\r\ngarantizando máxima versatilidad. Gracias a su\r\niluminación natural y su estética contemporánea, es\r\nideal para jornadas corporativas, sesiones de\r\nformación, ruedas de prensa o eventos de networking. \r\nAdemás, ofrece todos los servicios incluidos, lo que\r\nla convierte en una opción eficiente y funcional.<\/font><\/p><ul><li><p><font face=\"Verdana\"><b><u>TERRAZA - LA QUINTA PLANTA:<\/u> <\/b> Ubicada en pleno corazón de Madrid, en la emblemática <strong data-start=\"54\" data-end=\"72\">Puerta del Sol<\/strong>, con vistas privilegiadas a uno de los puntos más icónicos de la ciudad.<\/font><\/p><ul style=\"margin-bottom: 10px;\"><li><font face=\"Verdana\"><b>ZONA INDOOR + ZONA OUTDOOR: <\/b>Para la restauración. <b>Se trata de una terraza privada en la azotea del edifico.<\/b><\/font><\/li><\/ul><\/li><\/ul>"},"importantDescGeneralText":{"old":null,"new":"<p><font face=\"Verdana\">En la pestaña superior derecha de <b>\"Dossieres\"<\/b> encontrarás mas fotos e información de los espacios, la oferta de catering y gastronomía de<b> Higo & Trigo <\/b>y el rider técnico y precios de <b>Av Express<\/b><\/font><\/p>"},"importantDescSchedules":{"old":null,"new":"<p><font face=\"Verdana\">A consultar según el evento<\/font><\/p>"},"importantDescParking":{"old":null,"new":"<p><br><\/p>"},"language":{"old":null,"new":1},"sentToSage":{"old":null,"new":false},"breakdownPackages":{"old":null,"new":false},"showAudiovisualPrice":{"old":null,"new":false},"showAudiovisualPackage":{"old":null,"new":true},"sageIva":{"old":null,"new":"IVA general (ID: #4)"},"expediente_id":{"old":null,"new":18149},"expediente_afectado":{"old":null,"new":"Expediente #18149"}}" 151 "Ana Martín" "ana.martin@greenpatio.es" "81.44.217.21" "reservations_venues_create_simple_lounge" "2026-10-31 17:57:41" ] |
|
2.51 ms (0.18%) |
7 |
INSERT INTO reservation_lounge_simple_service_log (reservaId, version, itemId, itemName, itemType, dateStart, dateEnd, pax, price, agentId, agentName, rankQuote, idLounge, createdAt, updatedAt, serviceCatId, serviceCatName, units, opCommission, commission, price_over, toinvoice, viewInfo) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 18149 4 34758 "Sala de Cristal" "lounge" "2026-12-18 00:00:00" "2026-12-18 23:59:00" 40 "3000" 151 "Ana Martín" 1 13 "2026-10-31 17:57:41" null null null null null null null null null ] |
|
2.15 ms (0.16%) |
7 |
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.signature AS signature_3, t0.username AS username_4, t0.email AS email_5, t0.password AS password_6, t0.movil_password AS movil_password_7, t0.pass_gmail AS pass_gmail_8, t0.firm_gmail AS firm_gmail_9, t0.name AS name_10, t0.last_name AS last_name_11, t0.telephone AS telephone_12, t0.mobile AS mobile_13, t0.status AS status_14, t0.team_leader AS team_leader_15, t0.role AS role_16, t0.access_key AS access_key_17, t0.language AS language_18, t0.color AS color_19, t0.sidebar AS sidebar_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.description AS description_23, t0.job_title AS job_title_24, t0.reset_token AS reset_token_25, t0.id_office AS id_office_26, t0.id_company AS id_company_27, t0.id_user_rol AS id_user_rol_28, t0.id_team AS id_team_29 FROM users t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
151
]
|
|
1.78 ms (0.13%) |
1 |
INSERT INTO reservation_lounge_simple (loungeName, idLounge, dateStart, dateEnd, servicePrice, idReservation, pax, type, createdAt, createdBy, updatedAt, updatedBy, hourStart, minStart, hourEnd, minEnd, rankQuote, op_iva, iva, loungeDescription, importantDescription, importantDescGeneralText, importantDescSchedules, importantDescParking, language, sent_to_sage, breakdown_packages, show_audiovisual_price, show_audiovisual_package, sage_iva, sage_article_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "Combo 7 Legends Sala Global + Terraza" 41 "2026-12-18 00:00:00" "2026-12-18 23:59:00" 2000.0 18149 40 null "2026-10-31 17:57:41" 151 "2026-10-31 17:57:41" 151 "00" "00" "23" "59" 4 1 null null """ <ul><li><font face="Verdana"><u style="font-weight: bold;">SALA GLOBAL: </u>Para la reunión/presentación </font></li></ul><p><font face="Verdana">Situada en la 4ta planta, la Sala Global es un espacio\r\n moderno, luminoso y totalmente adaptable a las\r\n necesidades de cada evento. Dispone de un sistema panelable que permite\r\n configurar el espacio en distintos formatos,\r\n garantizando máxima versatilidad. Gracias a su\r\n iluminación natural y su estética contemporánea, es\r\n ideal para jornadas corporativas, sesiones de\r\n formación, ruedas de prensa o eventos de networking. \r\n Además, ofrece todos los servicios incluidos, lo que\r\n la convierte en una opción eficiente y funcional.</font></p><ul><li><p><font face="Verdana"><b><u>TERRAZA - LA QUINTA PLANTA:</u> </b> Ubicada en pleno corazón de Madrid, en la emblemática <strong data-start="54" data-end="72">Puerta del Sol</strong>, con vistas privilegiadas a uno de los puntos más icónicos de la ciudad.</font></p><ul style="margin-bottom: 10px;"><li><font face="Verdana"><b>ZONA INDOOR + ZONA OUTDOOR: </b>Para la restauración. <b>Se trata de una terraza privada en la azotea del edifico.</b></font></li></ul></li></ul> """ "<p><font face="Verdana">En la pestaña superior derecha de <b>"Dossieres"</b> encontrarás mas fotos e información de los espacios, la oferta de catering y gastronomía de<b> Higo & Trigo </b>y el rider técnico y precios de <b>Av Express</b></font></p>" "<p><font face="Verdana">A consultar según el evento</font></p>" "<p><br></p>" 1 0 0 0 1 4 null ] |
|
1.69 ms (0.12%) |
1 |
SELECT t0.id AS id_1, t0.language AS language_2, t0.important_description AS important_description_3, t0.important_desc_general_text AS important_desc_general_text_4, t0.important_desc_schedules AS important_desc_schedules_5, t0.important_desc_parking AS important_desc_parking_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.lounge_id AS lounge_id_9, t0.created_id_id AS created_id_id_10, t0.updated_id_id AS updated_id_id_11 FROM reservation_lounge_web_description t0 WHERE t0.lounge_id = ? AND t0.language = ? LIMIT 1
Parameters:
[ 41 1 ] |
|
1.42 ms (0.10%) |
5 |
"START TRANSACTION"
Parameters:
[] |
|
1.31 ms (0.09%) |
2 |
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:
[
17145
]
|
|
1.13 ms (0.08%) |
2 |
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.signature AS signature_3, t0.username AS username_4, t0.email AS email_5, t0.password AS password_6, t0.movil_password AS movil_password_7, t0.pass_gmail AS pass_gmail_8, t0.firm_gmail AS firm_gmail_9, t0.name AS name_10, t0.last_name AS last_name_11, t0.telephone AS telephone_12, t0.mobile AS mobile_13, t0.status AS status_14, t0.team_leader AS team_leader_15, t0.role AS role_16, t0.access_key AS access_key_17, t0.language AS language_18, t0.color AS color_19, t0.sidebar AS sidebar_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.description AS description_23, t0.job_title AS job_title_24, t0.reset_token AS reset_token_25, t0.id_office AS id_office_26, t0.id_company AS id_company_27, t0.id_user_rol AS id_user_rol_28, t0.id_team AS id_team_29 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"ana.martin@greenpatio.es"
]
|
|
0.75 ms (0.05%) |
1 |
SELECT t0.id AS id_1, t0.sage_code AS sage_code_2, t0.name AS name_3, t0.description AS description_4, t0.active AS active_5, t0.sent_to_sage AS sent_to_sage_6, t0.sync_date AS sync_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.discharge_date AS discharge_date_10, t0.family_id AS family_id_11, t0.subfamily_id AS subfamily_id_12, t0.vat_type_id AS vat_type_id_13, t0.settings_company_id AS settings_company_id_14 FROM sage_article t0 WHERE t0.vat_type_id = ? AND t0.name = ? LIMIT 1
Parameters:
[ 4 "Combo 7 Legends Sala Global + Terraza" ] |
|
0.74 ms (0.05%) |
1 |
UPDATE reservation SET dateStart = ?, dateEnd = ?, updatedAt = ? WHERE id = ?
Parameters:
[ "2026-12-18 00:00:00" "2026-12-18 23:59:00" "2026-10-31 17:57:41" 18149 ] |
|
0.66 ms (0.05%) |
1 |
SELECT MAX(r0_.version) AS sclr_0 FROM reservation_lounge_simple_service_log r0_ WHERE r0_.reservaId = ?
Parameters:
[
18149
]
|
|
0.61 ms (0.04%) |
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.breakdown_packages AS breakdown_packages_26, t0.show_package_price AS show_package_price_27, t0.infoFormWeb AS infoFormWeb_28, t0.mailToClient AS mailToClient_29, t0.client_id AS client_id_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.created_id_id AS created_id_id_48, t31.updated_id_id AS updated_id_id_49, t31.client_contact_id AS client_contact_id_50, t31.reservation_id AS reservation_id_51, t52.id AS id_53, t52.title AS title_54, t52.client AS client_55, t52.priority AS priority_56, t52.supplier AS supplier_57, t52.status AS status_58, t52.daysBlock AS daysBlock_59, t52.advancePayment AS advancePayment_60, t52.idProposal AS idProposal_61, t52.cateringName AS cateringName_62, t52.boolCatering AS boolCatering_63, t52.dateStart AS dateStart_64, t52.dateEnd AS dateEnd_65, t52.pax AS pax_66, t52.deposit AS deposit_67, t52.access_key AS access_key_68, t52.description AS description_69, t52.destinoId AS destinoId_70, t52.createdAt AS createdAt_71, t52.createdId AS createdId_72, t52.updatedAt AS updatedAt_73, t52.updatedId AS updatedId_74, t52.comments AS comments_75, t52.comments_in_inv AS comments_in_inv_76, t52.comments_in_pro AS comments_in_pro_77, t52.xtra_field_one AS xtra_field_one_78, t52.xtra_field_two AS xtra_field_two_79, t52.reservation_id AS reservation_id_80 FROM reservation t0 LEFT JOIN ht_file t31 ON t31.reservation_id = t0.id LEFT JOIN ave_files t52 ON t52.reservation_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"18149"
]
|
|
0.61 ms (0.04%) |
2 |
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 = ? LIMIT 1
Parameters:
[
"41"
]
|
|
0.58 ms (0.04%) |
2 |
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:
[
17145
]
|
|
0.57 ms (0.04%) |
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
Parameters:
[] |
|
0.50 ms (0.04%) |
1 |
UPDATE ht_file SET date_start = ?, date_end = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-12-18 00:00:00" "2026-12-18 23:59:00" "2026-10-31 17:57:41" 8160 ] |
|
0.49 ms (0.04%) |
1 |
UPDATE reservation_agenda_item SET updatedAt = ? WHERE id = ?
Parameters:
[ "2026-10-31 17:57:41" 23299 ] |
|
0.48 ms (0.03%) |
1 |
INSERT INTO reservation_agenda_item (reservationId, rankListing, titleOne, titleTwo, titleThree, dateStart, dateEnd, description, picture, sourceId, sourceType, createdAt, createdId, updatedAt, updatedId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 18149 9 "SALAS A UTILIZAR" null null "2026-12-18 00:00:00" "2026-12-18 23:59:00" "Combo 7 Legends Sala Global + Terraza" null 34761 "ReservationLoungeSimple" "2026-10-31 17:57:41" 151 "2026-10-31 17:57:41" 151 ] |
|
0.45 ms (0.03%) |
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.43 ms (0.03%) |
1 |
SELECT r0_.id AS id_0, r0_.loungeId AS loungeId_1, r0_.periodId AS periodId_2, r0_.price AS price_3, r0_.description AS description_4, r0_.created_id AS created_id_5, r0_.created_at AS created_at_6, r0_.updated_id AS updated_id_7, r0_.updated_at AS updated_at_8, r0_.year1 AS year1_9, r0_.year2 AS year2_10, r0_.month1 AS month1_11, r0_.month2 AS month2_12, r0_.month3 AS month3_13, r0_.month4 AS month4_14, r0_.month5 AS month5_15, r0_.month6 AS month6_16, r0_.month7 AS month7_17, r0_.month8 AS month8_18, r0_.month9 AS month9_19, r0_.month10 AS month10_20, r0_.month11 AS month11_21, r0_.month12 AS month12_22, r0_.day1 AS day1_23, r0_.day2 AS day2_24, r0_.day3 AS day3_25, r0_.day4 AS day4_26, r0_.day5 AS day5_27, r0_.day6 AS day6_28, r0_.day7 AS day7_29, r0_.title AS title_30, r0_.priceIsActive AS priceIsActive_31, r0_.dateStart AS dateStart_32, r0_.dateEnd AS dateEnd_33, r0_.type_price AS type_price_34, r0_.level_price AS level_price_35 FROM reservation_lounge_profile r0_ WHERE r0_.type_price = ? AND r0_.dateStart = ? AND r0_.loungeId = ? ORDER BY r0_.level_price DESC
Parameters:
[ "DIARIA" "2026-12-18 00:00:00" 41 ] |
|
0.40 ms (0.03%) |
1 |
SELECT t0.id AS id_1, t0.sage_code AS sage_code_2, t0.name AS name_3, t0.iva AS iva_4, t0.sync_date AS sync_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.settings_company_id AS settings_company_id_8 FROM sage_vat_rates t0 WHERE t0.sage_code = ? LIMIT 1
Parameters:
[
"03"
]
|
|
0.39 ms (0.03%) |
1 |
UPDATE ave_files SET dateStart = ?, dateEnd = ? WHERE id = ?
Parameters:
[ "2026-12-18 00:00:00" "2026-12-18 23:59:00" 13135 ] |
|
0.34 ms (0.02%) |
1 |
UPDATE ht_file SET updated_at = ? WHERE id = ?
Parameters:
[ "2026-10-31 17:57:41" 8160 ] |
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.