Symfony Profiler

SELECT
  i0_.id AS id_0,
  i0_.code AS code_1,
  i0_.created_at AS created_at_2,
  i0_.dataJson AS dataJson_3,
  i0_.amount AS amount_4,
  i0_.comment AS comment_5,
  r1_.id AS id_6,
  r1_.created_at AS created_at_7,
  r1_.updated_at AS updated_at_8,
  r1_.note AS note_9,
  r1_.code AS code_10,
  r1_.invalide AS invalide_11,
  r1_.is_manual AS is_manual_12,
  r1_.cancel_date AS cancel_date_13,
  r1_.enter_date AS enter_date_14,
  r1_.exit_date AS exit_date_15,
  r1_.quantity_adult AS quantity_adult_16,
  r1_.quantity_children AS quantity_children_17,
  r1_.amount AS amount_18,
  r1_.payment_status AS payment_status_19,
  r1_.is_canceled AS is_canceled_20,
  r1_.invite_type AS invite_type_21,
  r1_.is_draft AS is_draft_22,
  r1_.start_date AS start_date_23,
  r1_.end_date AS end_date_24,
  c2_.id AS id_25,
  c2_.created_at AS created_at_26,
  c2_.updated_at AS updated_at_27,
  c2_.firstname AS firstname_28,
  c2_.lastname AS lastname_29,
  c2_.phone AS phone_30,
  c2_.player_id AS player_id_31,
  c2_.email AS email_32,
  c2_.password AS password_33,
  c2_.enterprise_name AS enterprise_name_34,
  c2_.enterprise_adress AS enterprise_adress_35,
  c2_.contact_number AS contact_number_36,
  c2_.contribuable_account AS contribuable_account_37,
  c2_.username AS username_38,
  c2_.cni AS cni_39,
  c2_.country AS country_40,
  c2_.number_passport AS number_passport_41,
  c2_.akoula_note AS akoula_note_42,
  c2_.personal_note AS personal_note_43,
  c2_.country_passport AS country_passport_44,
  c2_.expiredate_passport AS expiredate_passport_45,
  c2_.is_enterprise AS is_enterprise_46,
  u3_.id AS id_47,
  u3_.firstname AS firstname_48,
  u3_.lastname AS lastname_49,
  u3_.username AS username_50,
  u3_.roles AS roles_51,
  u3_.phone AS phone_52,
  u3_.email AS email_53,
  u3_.password AS password_54,
  u3_.created_at AS created_at_55,
  i0_.reservation_bedroom_id AS reservation_bedroom_id_56,
  i0_.created_by AS created_by_57,
  r1_.promo_code_id AS promo_code_id_58,
  r1_.customer_id AS customer_id_59,
  r1_.reservation_id AS reservation_id_60,
  r1_.bedroom_id AS bedroom_id_61,
  r1_.bedroom_chamber_id AS bedroom_chamber_id_62,
  c2_.account_id AS account_id_63
FROM
  invoice i0_
  LEFT JOIN reservation_bedroom r1_ ON i0_.reservation_bedroom_id = r1_.id
  LEFT JOIN customer c2_ ON r1_.customer_id = c2_.id
  LEFT JOIN user u3_ ON i0_.created_by = u3_.id
  INNER JOIN reservation_bedroom r4_ ON i0_.reservation_bedroom_id = r4_.id
  INNER JOIN customer c5_ ON r4_.customer_id = c5_.id
WHERE
  i0_.id IN (
    SELECT
      i6_.id
    FROM
      invoice i6_
      LEFT JOIN reservation_bedroom r7_ ON i6_.reservation_bedroom_id = r7_.id
      LEFT JOIN customer c8_ ON r7_.customer_id = c8_.id
      LEFT JOIN user u9_ ON i6_.created_by = u9_.id
      LEFT JOIN reservation_bedroom r10_ ON i6_.reservation_bedroom_id = r10_.id
      LEFT JOIN customer c11_ ON r10_.customer_id = c11_.id
    WHERE
      r7_.reservation_id = ?
      AND (
        CONCAT(
          c11_.firstname, ' ', c11_.lastname
        ) LIKE ?
        OR i6_.code LIKE ?
      )
  )
ORDER BY
  i0_.id ASC
LIMIT
  30

SELECT i0_.id AS id_0, i0_.code AS code_1, i0_.created_at AS created_at_2, i0_.dataJson AS dataJson_3, i0_.amount AS amount_4, i0_.comment AS comment_5, r1_.id AS id_6, r1_.created_at AS created_at_7, r1_.updated_at AS updated_at_8, r1_.note AS note_9, r1_.code AS code_10, r1_.invalide AS invalide_11, r1_.is_manual AS is_manual_12, r1_.cancel_date AS cancel_date_13, r1_.enter_date AS enter_date_14, r1_.exit_date AS exit_date_15, r1_.quantity_adult AS quantity_adult_16, r1_.quantity_children AS quantity_children_17, r1_.amount AS amount_18, r1_.payment_status AS payment_status_19, r1_.is_canceled AS is_canceled_20, r1_.invite_type AS invite_type_21, r1_.is_draft AS is_draft_22, r1_.start_date AS start_date_23, r1_.end_date AS end_date_24, c2_.id AS id_25, c2_.created_at AS created_at_26, c2_.updated_at AS updated_at_27, c2_.firstname AS firstname_28, c2_.lastname AS lastname_29, c2_.phone AS phone_30, c2_.player_id AS player_id_31, c2_.email AS email_32, c2_.password AS password_33, c2_.enterprise_name AS enterprise_name_34, c2_.enterprise_adress AS enterprise_adress_35, c2_.contact_number AS contact_number_36, c2_.contribuable_account AS contribuable_account_37, c2_.username AS username_38, c2_.cni AS cni_39, c2_.country AS country_40, c2_.number_passport AS number_passport_41, c2_.akoula_note AS akoula_note_42, c2_.personal_note AS personal_note_43, c2_.country_passport AS country_passport_44, c2_.expiredate_passport AS expiredate_passport_45, c2_.is_enterprise AS is_enterprise_46, u3_.id AS id_47, u3_.firstname AS firstname_48, u3_.lastname AS lastname_49, u3_.username AS username_50, u3_.roles AS roles_51, u3_.phone AS phone_52, u3_.email AS email_53, u3_.password AS password_54, u3_.created_at AS created_at_55, i0_.reservation_bedroom_id AS reservation_bedroom_id_56, i0_.created_by AS created_by_57, r1_.promo_code_id AS promo_code_id_58, r1_.customer_id AS customer_id_59, r1_.reservation_id AS reservation_id_60, r1_.bedroom_id AS bedroom_id_61, r1_.bedroom_chamber_id AS bedroom_chamber_id_62, c2_.account_id AS account_id_63 FROM invoice i0_ LEFT JOIN reservation_bedroom r1_ ON i0_.reservation_bedroom_id = r1_.id LEFT JOIN customer c2_ ON r1_.customer_id = c2_.id LEFT JOIN user u3_ ON i0_.created_by = u3_.id INNER JOIN reservation_bedroom r4_ ON i0_.reservation_bedroom_id = r4_.id INNER JOIN customer c5_ ON r4_.customer_id = c5_.id WHERE i0_.id IN (SELECT i6_.id FROM invoice i6_ LEFT JOIN reservation_bedroom r7_ ON i6_.reservation_bedroom_id = r7_.id LEFT JOIN customer c8_ ON r7_.customer_id = c8_.id LEFT JOIN user u9_ ON i6_.created_by = u9_.id LEFT JOIN reservation_bedroom r10_ ON i6_.reservation_bedroom_id = r10_.id LEFT JOIN customer c11_ ON r10_.customer_id = c11_.id WHERE r7_.reservation_id = 87 AND (CONCAT(c11_.firstname, ' ', c11_.lastname) LIKE '%%' OR i6_.code LIKE '%%')) ORDER BY i0_.id ASC LIMIT 30;

SELECT
  count(DISTINCT i0_.id) AS sclr_0
FROM
  invoice i0_
  LEFT JOIN reservation_bedroom r1_ ON i0_.reservation_bedroom_id = r1_.id
  LEFT JOIN customer c2_ ON r1_.customer_id = c2_.id
  LEFT JOIN user u3_ ON i0_.created_by = u3_.id
  INNER JOIN reservation_bedroom r4_ ON i0_.reservation_bedroom_id = r4_.id
  INNER JOIN customer c5_ ON r4_.customer_id = c5_.id
WHERE
  i0_.id IN (
    SELECT
      i6_.id
    FROM
      invoice i6_
      LEFT JOIN reservation_bedroom r7_ ON i6_.reservation_bedroom_id = r7_.id
      LEFT JOIN customer c8_ ON r7_.customer_id = c8_.id
      LEFT JOIN user u9_ ON i6_.created_by = u9_.id
      LEFT JOIN reservation_bedroom r10_ ON i6_.reservation_bedroom_id = r10_.id
      LEFT JOIN customer c11_ ON r10_.customer_id = c11_.id
    WHERE
      r7_.reservation_id = ?
      AND (
        CONCAT(
          c11_.firstname, ' ', c11_.lastname
        ) LIKE ?
        OR i6_.code LIKE ?
      )
  )

SELECT count(DISTINCT i0_.id) AS sclr_0 FROM invoice i0_ LEFT JOIN reservation_bedroom r1_ ON i0_.reservation_bedroom_id = r1_.id LEFT JOIN customer c2_ ON r1_.customer_id = c2_.id LEFT JOIN user u3_ ON i0_.created_by = u3_.id INNER JOIN reservation_bedroom r4_ ON i0_.reservation_bedroom_id = r4_.id INNER JOIN customer c5_ ON r4_.customer_id = c5_.id WHERE i0_.id IN (SELECT i6_.id FROM invoice i6_ LEFT JOIN reservation_bedroom r7_ ON i6_.reservation_bedroom_id = r7_.id LEFT JOIN customer c8_ ON r7_.customer_id = c8_.id LEFT JOIN user u9_ ON i6_.created_by = u9_.id LEFT JOIN reservation_bedroom r10_ ON i6_.reservation_bedroom_id = r10_.id LEFT JOIN customer c11_ ON r10_.customer_id = c11_.id WHERE r7_.reservation_id = 87 AND (CONCAT(c11_.firstname, ' ', c11_.lastname) LIKE '%%' OR i6_.code LIKE '%%'));

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.username AS username_4,
  t0.roles AS roles_5,
  t0.phone AS phone_6,
  t0.email AS email_7,
  t0.password AS password_8,
  t0.created_at AS created_at_9
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.username AS username_4, t0.roles AS roles_5, t0.phone AS phone_6, t0.email AS email_7, t0.password AS password_8, t0.created_at AS created_at_9 FROM user t0 WHERE t0.username = 'figuc' LIMIT 1;