Symfony Profiler

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.date_of_birth AS date_of_birth_14,
  t0.firstname AS firstname_15,
  t0.lastname AS lastname_16,
  t0.website AS website_17,
  t0.biography AS biography_18,
  t0.gender AS gender_19,
  t0.locale AS locale_20,
  t0.timezone AS timezone_21,
  t0.phone AS phone_22,
  t0.facebook_uid AS facebook_uid_23,
  t0.facebook_name AS facebook_name_24,
  t0.facebook_data AS facebook_data_25,
  t0.twitter_uid AS twitter_uid_26,
  t0.twitter_name AS twitter_name_27,
  t0.twitter_data AS twitter_data_28,
  t0.gplus_uid AS gplus_uid_29,
  t0.gplus_name AS gplus_name_30,
  t0.gplus_data AS gplus_data_31,
  t0.token AS token_32,
  t0.two_step_code AS two_step_code_33,
  t0.id AS id_34
FROM
  adm_user t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.date_of_birth AS date_of_birth_14, t0.firstname AS firstname_15, t0.lastname AS lastname_16, t0.website AS website_17, t0.biography AS biography_18, t0.gender AS gender_19, t0.locale AS locale_20, t0.timezone AS timezone_21, t0.phone AS phone_22, t0.facebook_uid AS facebook_uid_23, t0.facebook_name AS facebook_name_24, t0.facebook_data AS facebook_data_25, t0.twitter_uid AS twitter_uid_26, t0.twitter_name AS twitter_name_27, t0.twitter_data AS twitter_data_28, t0.gplus_uid AS gplus_uid_29, t0.gplus_name AS gplus_name_30, t0.gplus_data AS gplus_data_31, t0.token AS token_32, t0.two_step_code AS two_step_code_33, t0.id AS id_34 FROM adm_user t0 WHERE t0.id = 2 LIMIT 1;

SELECT
  t0.name AS name_1,
  t0.roles AS roles_2,
  t0.id AS id_3
FROM
  fos_group t0
  INNER JOIN fos_user_user_group ON t0.id = fos_user_user_group.group_id
WHERE
  fos_user_user_group.user_id = ?

SELECT t0.name AS name_1, t0.roles AS roles_2, t0.id AS id_3 FROM fos_group t0 INNER JOIN fos_user_user_group ON t0.id = fos_user_user_group.group_id WHERE fos_user_user_group.user_id = 2;

SELECT
  t0.id AS id_1,
  t0.mark AS mark_2,
  t0.model AS model_3,
  t0.vin_number AS vin_number_4,
  t0.registration_number AS registration_number_5,
  t0.issue_year AS issue_year_6,
  t0.payment_amount AS payment_amount_7,
  t0.color AS color_8
FROM
  motorcycle t0

SELECT t0.id AS id_1, t0.mark AS mark_2, t0.model AS model_3, t0.vin_number AS vin_number_4, t0.registration_number AS registration_number_5, t0.issue_year AS issue_year_6, t0.payment_amount AS payment_amount_7, t0.color AS color_8 FROM motorcycle t0;

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.password AS password_3,
  t0.user_number AS user_number_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.middle_name AS middle_name_7,
  t0.date_of_birth AS date_of_birth_8,
  t0.passport_number AS passport_number_9,
  t0.passport_id AS passport_id_10,
  t0.passport_issue_date AS passport_issue_date_11,
  t0.passport_issuing_authority AS passport_issuing_authority_12,
  t0.registration_address AS registration_address_13,
  t0.drivers_license_number AS drivers_license_number_14,
  t0.drivers_license_date AS drivers_license_date_15,
  t0.date_signing_contract AS date_signing_contract_16,
  t0.notes AS notes_17
FROM
  client t0

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.password AS password_3, t0.user_number AS user_number_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.middle_name AS middle_name_7, t0.date_of_birth AS date_of_birth_8, t0.passport_number AS passport_number_9, t0.passport_id AS passport_id_10, t0.passport_issue_date AS passport_issue_date_11, t0.passport_issuing_authority AS passport_issuing_authority_12, t0.registration_address AS registration_address_13, t0.drivers_license_number AS drivers_license_number_14, t0.drivers_license_date AS drivers_license_date_15, t0.date_signing_contract AS date_signing_contract_16, t0.notes AS notes_17 FROM client t0;

SELECT
  r0_.id AS id_0,
  r0_.start_date AS start_date_1,
  r0_.end_date AS end_date_2,
  r0_.amount AS amount_3,
  r0_.status AS status_4,
  r0_.notes AS notes_5,
  r0_.motorcycle_id AS motorcycle_id_6,
  r0_.client_id AS client_id_7
FROM
  reserve r0_
WHERE
  (
    (
      ? BETWEEN r0_.start_date
      AND r0_.end_date
    )
    OR (
      ? BETWEEN r0_.start_date
      AND r0_.end_date
    )
    OR (
      r0_.start_date BETWEEN ?
      AND ?
    )
    OR (
      r0_.end_date BETWEEN ?
      AND ?
    )
  )
  AND r0_.motorcycle_id = ?
ORDER BY
  r0_.motorcycle_id ASC

SELECT r0_.id AS id_0, r0_.start_date AS start_date_1, r0_.end_date AS end_date_2, r0_.amount AS amount_3, r0_.status AS status_4, r0_.notes AS notes_5, r0_.motorcycle_id AS motorcycle_id_6, r0_.client_id AS client_id_7 FROM reserve r0_ WHERE (('2024-08-31 11:00:00' BETWEEN r0_.start_date AND r0_.end_date) OR ('2024-09-01 10:59:59' BETWEEN r0_.start_date AND r0_.end_date) OR (r0_.start_date BETWEEN '2024-08-31 11:00:00' AND '2024-09-01 10:59:59') OR (r0_.end_date BETWEEN '2024-08-31 11:00:00' AND '2024-09-01 10:59:59')) AND r0_.motorcycle_id = 7 ORDER BY r0_.motorcycle_id ASC;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO reserve (
  start_date, end_date, amount, status,
  notes, motorcycle_id, client_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO reserve (start_date, end_date, amount, status, notes, motorcycle_id, client_id) VALUES ('2024-08-31 11:00:00', '2024-09-01 10:59:59', 60, 2, NULL, 7, 268);

"COMMIT"

"COMMIT";