Symfony Profiler

SELECT
  h0_.id AS id_0,
  h0_.title AS title_1,
  h0_.status AS status_2,
  h0_.days_block AS days_block_3,
  h0_.pax AS pax_4,
  h0_.description AS description_5,
  h0_.description_two AS description_two_6,
  h0_.contact_unregistered AS contact_unregistered_7,
  h0_.name_contact_unregistered AS name_contact_unregistered_8,
  h0_.phone_contact_unregistered AS phone_contact_unregistered_9,
  h0_.date_start AS date_start_10,
  h0_.date_end AS date_end_11,
  h0_.created_at AS created_at_12,
  h0_.updated_at AS updated_at_13,
  h0_.client_type AS client_type_14,
  h1_.id AS id_15,
  h1_.lounge_other AS lounge_other_16,
  h1_.date_start AS date_start_17,
  h1_.hour_end AS hour_end_18,
  h1_.gratitudes AS gratitudes_19,
  h1_.created_at AS created_at_20,
  h1_.updated_at AS updated_at_21,
  h1_.pax AS pax_22,
  h1_.observation AS observation_23,
  h1_.type AS type_24,
  r2_.id AS id_25,
  r2_.title AS title_26,
  r2_.clientContact AS clientContact_27,
  r2_.contactUnregistered AS contactUnregistered_28,
  r2_.nameContactUnregistered AS nameContactUnregistered_29,
  r2_.phoneContactUnregistered AS phoneContactUnregistered_30,
  r2_.days AS days_31,
  r2_.createdAt AS createdAt_32,
  r2_.priority AS priority_33,
  r2_.createdBy AS createdBy_34,
  r2_.supplier AS supplier_35,
  r2_.status AS status_36,
  r2_.updatedAt AS updatedAt_37,
  r2_.updatedBy AS updatedBy_38,
  r2_.daysBlock AS daysBlock_39,
  r2_.dateStart AS dateStart_40,
  r2_.dateEnd AS dateEnd_41,
  r2_.pax AS pax_42,
  r2_.access_key AS access_key_43,
  r2_.description AS description_44,
  r2_.contract AS contract_45,
  r2_.token AS token_46,
  r2_.comAvGp AS comAvGp_47,
  r2_.comHtGp AS comHtGp_48,
  r2_.sucoe AS sucoe_49,
  r3_.id AS id_50,
  r3_.name AS name_51,
  r3_.created_id AS created_id_52,
  r3_.created_at AS created_at_53,
  r3_.updated_id AS updated_id_54,
  r3_.updated_at AS updated_at_55,
  r3_.meters AS meters_56,
  r3_.length AS length_57,
  r3_.width AS width_58,
  r3_.height AS height_59,
  r3_.cap_school AS cap_school_60,
  r3_.cap_theater AS cap_theater_61,
  r3_.cap_cocktail AS cap_cocktail_62,
  r3_.cap_banquet AS cap_banquet_63,
  r3_.cap_imperial AS cap_imperial_64,
  r3_.rank_lounge AS rank_lounge_65,
  r3_.combo AS combo_66,
  r3_.importantDescription AS importantDescription_67,
  r3_.importantDescGeneralText AS importantDescGeneralText_68,
  r3_.importantDescSchedules AS importantDescSchedules_69,
  r3_.importantDescParking AS importantDescParking_70,
  h0_.client_id AS client_id_71,
  h0_.created_id_id AS created_id_id_72,
  h0_.updated_id_id AS updated_id_id_73,
  h0_.client_contact_id AS client_contact_id_74,
  h0_.reservation_id AS reservation_id_75,
  h1_.reservation_service_id AS reservation_service_id_76,
  h1_.lounge_gp_id AS lounge_gp_id_77,
  h1_.created_id_id AS created_id_id_78,
  h1_.updated_id_id AS updated_id_id_79,
  h1_.ht_file_id AS ht_file_id_80,
  r2_.client_id AS client_id_81,
  r3_.space_id AS space_id_82
FROM
  ht_file h0_
  LEFT JOIN ht_item h1_ ON h0_.id = h1_.ht_file_id
  LEFT JOIN reservation r2_ ON h0_.reservation_id = r2_.id
  LEFT JOIN reservation_lounge_details r3_ ON h1_.lounge_gp_id = r3_.id
WHERE
  (
    h0_.date_start <= ?
    AND COALESCE(h0_.date_end, h0_.date_start) >= ?
  )
  AND (
    (
      h0_.status <> ?
      OR h0_.status IS NULL
    )
  )

SELECT h0_.id AS id_0, h0_.title AS title_1, h0_.status AS status_2, h0_.days_block AS days_block_3, h0_.pax AS pax_4, h0_.description AS description_5, h0_.description_two AS description_two_6, h0_.contact_unregistered AS contact_unregistered_7, h0_.name_contact_unregistered AS name_contact_unregistered_8, h0_.phone_contact_unregistered AS phone_contact_unregistered_9, h0_.date_start AS date_start_10, h0_.date_end AS date_end_11, h0_.created_at AS created_at_12, h0_.updated_at AS updated_at_13, h0_.client_type AS client_type_14, h1_.id AS id_15, h1_.lounge_other AS lounge_other_16, h1_.date_start AS date_start_17, h1_.hour_end AS hour_end_18, h1_.gratitudes AS gratitudes_19, h1_.created_at AS created_at_20, h1_.updated_at AS updated_at_21, h1_.pax AS pax_22, h1_.observation AS observation_23, h1_.type AS type_24, r2_.id AS id_25, r2_.title AS title_26, r2_.clientContact AS clientContact_27, r2_.contactUnregistered AS contactUnregistered_28, r2_.nameContactUnregistered AS nameContactUnregistered_29, r2_.phoneContactUnregistered AS phoneContactUnregistered_30, r2_.days AS days_31, r2_.createdAt AS createdAt_32, r2_.priority AS priority_33, r2_.createdBy AS createdBy_34, r2_.supplier AS supplier_35, r2_.status AS status_36, r2_.updatedAt AS updatedAt_37, r2_.updatedBy AS updatedBy_38, r2_.daysBlock AS daysBlock_39, r2_.dateStart AS dateStart_40, r2_.dateEnd AS dateEnd_41, r2_.pax AS pax_42, r2_.access_key AS access_key_43, r2_.description AS description_44, r2_.contract AS contract_45, r2_.token AS token_46, r2_.comAvGp AS comAvGp_47, r2_.comHtGp AS comHtGp_48, r2_.sucoe AS sucoe_49, r3_.id AS id_50, r3_.name AS name_51, r3_.created_id AS created_id_52, r3_.created_at AS created_at_53, r3_.updated_id AS updated_id_54, r3_.updated_at AS updated_at_55, r3_.meters AS meters_56, r3_.length AS length_57, r3_.width AS width_58, r3_.height AS height_59, r3_.cap_school AS cap_school_60, r3_.cap_theater AS cap_theater_61, r3_.cap_cocktail AS cap_cocktail_62, r3_.cap_banquet AS cap_banquet_63, r3_.cap_imperial AS cap_imperial_64, r3_.rank_lounge AS rank_lounge_65, r3_.combo AS combo_66, r3_.importantDescription AS importantDescription_67, r3_.importantDescGeneralText AS importantDescGeneralText_68, r3_.importantDescSchedules AS importantDescSchedules_69, r3_.importantDescParking AS importantDescParking_70, h0_.client_id AS client_id_71, h0_.created_id_id AS created_id_id_72, h0_.updated_id_id AS updated_id_id_73, h0_.client_contact_id AS client_contact_id_74, h0_.reservation_id AS reservation_id_75, h1_.reservation_service_id AS reservation_service_id_76, h1_.lounge_gp_id AS lounge_gp_id_77, h1_.created_id_id AS created_id_id_78, h1_.updated_id_id AS updated_id_id_79, h1_.ht_file_id AS ht_file_id_80, r2_.client_id AS client_id_81, r3_.space_id AS space_id_82 FROM ht_file h0_ LEFT JOIN ht_item h1_ ON h0_.id = h1_.ht_file_id LEFT JOIN reservation r2_ ON h0_.reservation_id = r2_.id LEFT JOIN reservation_lounge_details r3_ ON h1_.lounge_gp_id = r3_.id WHERE (h0_.date_start <= '2026-05-11 00:00:00' AND COALESCE(h0_.date_end, h0_.date_start) >= '2026-03-30 00:00:00') AND ((h0_.status <> 'Deleted' OR h0_.status IS NULL));

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 = ?

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 = 12171;

SELECT
  r0_.dateStart AS dateStart_0,
  r0_.type AS type_1,
  r1_.space_id AS sclr_2
FROM
  reservation_lounge_simple r0_
  LEFT JOIN reservation_lounge_details r1_ ON (r1_.id = r0_.idLounge)
WHERE
  r0_.idReservation = ?

SELECT r0_.dateStart AS dateStart_0, r0_.type AS type_1, r1_.space_id AS sclr_2 FROM reservation_lounge_simple r0_ LEFT JOIN reservation_lounge_details r1_ ON (r1_.id = r0_.idLounge) WHERE r0_.idReservation = 12171;

SELECT
  DISTINCT r0_.loungeName AS loungeName_0
FROM
  reservation_lounge_simple r0_
WHERE
  r0_.idReservation = ?

SELECT DISTINCT r0_.loungeName AS loungeName_0 FROM reservation_lounge_simple r0_ WHERE r0_.idReservation = 12171;

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

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 = 'iTrey951112@gmail.com' LIMIT 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

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;

SELECT
  t0.id AS id_1,
  t0.status_name AS status_name_2,
  t0.color AS color_3,
  t0.business_type AS business_type_4,
  t0.space_id AS space_id_5
FROM
  status_color t0

SELECT t0.id AS id_1, t0.status_name AS status_name_2, t0.color AS color_3, t0.business_type AS business_type_4, t0.space_id AS space_id_5 FROM status_color t0;