Symfony Profiler

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_.title AS title_30,
  r1_.status AS status_31,
  r1_.id AS id_32,
  r2_.space_id AS sclr_33
FROM
  reservation_lounge_simple r0_
  INNER JOIN reservation r1_ ON (r1_.id = r0_.idReservation)
  LEFT JOIN reservation_lounge_details r2_ ON (r2_.id = r0_.idLounge)
WHERE
  (
    r0_.dateStart < ?
    AND r0_.dateEnd > ?
  )
  AND (
    (
      r1_.status IS NULL
      OR r1_.status <> ?
    )
  )

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_.title AS title_30, r1_.status AS status_31, r1_.id AS id_32, r2_.space_id AS sclr_33 FROM reservation_lounge_simple r0_ INNER JOIN reservation r1_ ON (r1_.id = r0_.idReservation) LEFT JOIN reservation_lounge_details r2_ ON (r2_.id = r0_.idLounge) WHERE (r0_.dateStart < '2026-11-09 00:00:00' AND r0_.dateEnd > '2026-09-28 00:00:00') AND ((r1_.status IS NULL OR r1_.status <> 'Deleted'));

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

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 = 'admon@avexpress.tv' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.master AS master_2,
  t0.number AS number_3,
  t0.prefix AS prefix_4,
  t0.dateAt AS dateAt_5,
  t0.type AS type_6,
  t0.reservationId AS reservationId_7,
  t0.totalNet AS totalNet_8,
  t0.vat AS vat_9,
  t0.total AS total_10,
  t0.balance AS balance_11,
  t0.createdAt AS createdAt_12,
  t0.createdId AS createdId_13,
  t0.updatedAt AS updatedAt_14,
  t0.updatedId AS updatedId_15,
  t0.client_name AS client_name_16,
  t0.client_address AS client_address_17,
  t0.client_document AS client_document_18,
  t0.client_type AS client_type_19,
  t20.id AS id_21,
  t20.sage_delivery_number AS sage_delivery_number_22,
  t20.sage_invoice_number AS sage_invoice_number_23,
  t20.sage_almacen AS sage_almacen_24,
  t20.factured AS factured_25,
  t20.is_rectificative AS is_rectificative_26,
  t20.sent_to_sage AS sent_to_sage_27,
  t20.sync_date AS sync_date_28,
  t20.factured_at AS factured_at_29,
  t20.created_at AS created_at_30,
  t20.updated_at AS updated_at_31,
  t20.last_error AS last_error_32,
  t20.letter AS letter_33,
  t20.pdf AS pdf_34,
  t20.client_id AS client_id_35,
  t20.rectifies_id AS rectifies_id_36,
  t20.sage_company_id AS sage_company_id_37,
  t20.reservation_invoice_id AS reservation_invoice_id_38,
  t20.reservation_invoice_rec_id AS reservation_invoice_rec_id_39,
  t20.ht_invoice_id AS ht_invoice_id_40,
  t20.ave_doc_invoice_id AS ave_doc_invoice_id_41,
  t20.ave_doc_invoice_rec_id AS ave_doc_invoice_rec_id_42,
  t43.id AS id_44,
  t43.prefix AS prefix_45,
  t43.number AS number_46,
  t43.date_at AS date_at_47,
  t43.reservation_id AS reservation_id_48,
  t43.name AS name_49,
  t43.amount AS amount_50,
  t43.iva AS iva_51,
  t43.total AS total_52,
  t43.created_at AS created_at_53,
  t43.created_id AS created_id_54,
  t43.updated_at AS updated_at_55,
  t43.updated_id AS updated_id_56,
  t43.sage_iva AS sage_iva_57,
  t43.reservation_invoice_id AS reservation_invoice_id_58
FROM
  reservation_invoice t0
  LEFT JOIN delivery_note t20 ON t20.reservation_invoice_id = t0.id
  LEFT JOIN reservation_proforma_deposit t43 ON t43.reservation_invoice_id = t0.id
WHERE
  t0.reservationId IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.master AS master_2, t0.number AS number_3, t0.prefix AS prefix_4, t0.dateAt AS dateAt_5, t0.type AS type_6, t0.reservationId AS reservationId_7, t0.totalNet AS totalNet_8, t0.vat AS vat_9, t0.total AS total_10, t0.balance AS balance_11, t0.createdAt AS createdAt_12, t0.createdId AS createdId_13, t0.updatedAt AS updatedAt_14, t0.updatedId AS updatedId_15, t0.client_name AS client_name_16, t0.client_address AS client_address_17, t0.client_document AS client_document_18, t0.client_type AS client_type_19, t20.id AS id_21, t20.sage_delivery_number AS sage_delivery_number_22, t20.sage_invoice_number AS sage_invoice_number_23, t20.sage_almacen AS sage_almacen_24, t20.factured AS factured_25, t20.is_rectificative AS is_rectificative_26, t20.sent_to_sage AS sent_to_sage_27, t20.sync_date AS sync_date_28, t20.factured_at AS factured_at_29, t20.created_at AS created_at_30, t20.updated_at AS updated_at_31, t20.last_error AS last_error_32, t20.letter AS letter_33, t20.pdf AS pdf_34, t20.client_id AS client_id_35, t20.rectifies_id AS rectifies_id_36, t20.sage_company_id AS sage_company_id_37, t20.reservation_invoice_id AS reservation_invoice_id_38, t20.reservation_invoice_rec_id AS reservation_invoice_rec_id_39, t20.ht_invoice_id AS ht_invoice_id_40, t20.ave_doc_invoice_id AS ave_doc_invoice_id_41, t20.ave_doc_invoice_rec_id AS ave_doc_invoice_rec_id_42, t43.id AS id_44, t43.prefix AS prefix_45, t43.number AS number_46, t43.date_at AS date_at_47, t43.reservation_id AS reservation_id_48, t43.name AS name_49, t43.amount AS amount_50, t43.iva AS iva_51, t43.total AS total_52, t43.created_at AS created_at_53, t43.created_id AS created_id_54, t43.updated_at AS updated_at_55, t43.updated_id AS updated_id_56, t43.sage_iva AS sage_iva_57, t43.reservation_invoice_id AS reservation_invoice_id_58 FROM reservation_invoice t0 LEFT JOIN delivery_note t20 ON t20.reservation_invoice_id = t0.id LEFT JOIN reservation_proforma_deposit t43 ON t43.reservation_invoice_id = t0.id WHERE t0.reservationId IN (13928, 14255, 14426, 14491, 14588, 14561, 15182, 15207, 15391, 15476, 15869, 15892, 14983, 15955, 15981, 15623, 16075, 16153, 16231, 16269, 16293, 16139, 16365, 16372, 16047, 16379, 16440, 15748, 16812, 16838, 16890, 16532, 16978, 16996, 17295, 17363, 17381, 17441, 17467, 16787, 17498, 17506, 17106, 17371, 17726, 17475, 15714, 17806, 17866, 17877, 17881, 10960, 17969, 17419, 15852, 18046, 18086, 18091, 18144) ORDER BY t0.id DESC;

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.team AS team_2
FROM
  settings_team t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.team AS team_2 FROM settings_team t0 WHERE t0.id = 8;

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;