Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.salutation AS salutation_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.email AS email_5,
  t0.phone AS phone_6,
  t0.birth_date AS birth_date_7,
  t0.identity_card AS identity_card_8,
  t0.roles AS roles_9,
  t0.hash AS hash_10,
  t0.password AS password_11,
  t0.date_created AS date_created_12,
  t0.date_updated AS date_updated_13,
  t0.is_verified AS is_verified_14,
  t0.company_id AS company_id_15
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.salutation AS salutation_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.email AS email_5, t0.phone AS phone_6, t0.birth_date AS birth_date_7, t0.identity_card AS identity_card_8, t0.roles AS roles_9, t0.hash AS hash_10, t0.password AS password_11, t0.date_created AS date_created_12, t0.date_updated AS date_updated_13, t0.is_verified AS is_verified_14, t0.company_id AS company_id_15 FROM user t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.vehicle_type AS vehicle_type_2,
  t0.vehicle AS vehicle_3,
  t0.place AS place_4,
  t0.user AS user_5,
  t0.reservation_id AS reservation_id_6
FROM
  reservation_relation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.vehicle_type AS vehicle_type_2, t0.vehicle AS vehicle_3, t0.place AS place_4, t0.user AS user_5, t0.reservation_id AS reservation_id_6 FROM reservation_relation t0 WHERE t0.id = 20;

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.country AS country_3,
  t0.zip AS zip_4,
  t0.city AS city_5,
  t0.state AS state_6,
  t0.altitude AS altitude_7,
  t0.name AS name_8,
  t0.longitude AS longitude_9,
  t0.latitude AS latitude_10
FROM
  place t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.country AS country_3, t0.zip AS zip_4, t0.city AS city_5, t0.state AS state_6, t0.altitude AS altitude_7, t0.name AS name_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10 FROM place t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.date_update AS date_update_2,
  t0.technical_data AS technical_data_3,
  t0.type AS type_4,
  t0.tag AS tag_5,
  t0.date_create AS date_create_6
FROM
  vehicle_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_update AS date_update_2, t0.technical_data AS technical_data_3, t0.type AS type_4, t0.tag AS tag_5, t0.date_create AS date_create_6 FROM vehicle_type t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.insurance_price AS insurance_price_2,
  t0.operator_price AS operator_price_3,
  t0.training_price AS training_price_4,
  t0.additional_items_price AS additional_items_price_5,
  t0.total_price AS total_price_6,
  t0.rent_operator AS rent_operator_7,
  t0.order_training AS order_training_8,
  t0.insurance_type AS insurance_type_9,
  t0.insure_storno AS insure_storno_10,
  t0.status AS status_11,
  t0.finished_step AS finished_step_12,
  t0.sale_flag AS sale_flag_13,
  t0.type AS type_14,
  t0.notice AS notice_15,
  t0.start_date_real AS start_date_real_16,
  t0.finish_date_real AS finish_date_real_17,
  t0.start_date AS start_date_18,
  t0.finish_date AS finish_date_19,
  t0.rent_price AS rent_price_20,
  t0.date_create AS date_create_21,
  t22.id AS id_23,
  t22.vehicle_type AS vehicle_type_24,
  t22.vehicle AS vehicle_25,
  t22.place AS place_26,
  t22.user AS user_27,
  t22.reservation_id AS reservation_id_28,
  t29.id AS id_30,
  t29.price AS price_31,
  t29.type AS type_32,
  t29.date_create AS date_create_33,
  t29.reservation_id AS reservation_id_34
FROM
  reservation t0
  LEFT JOIN reservation_relation t22 ON t22.reservation_id = t0.id
  LEFT JOIN reservation_insurance t29 ON t29.reservation_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.insurance_price AS insurance_price_2, t0.operator_price AS operator_price_3, t0.training_price AS training_price_4, t0.additional_items_price AS additional_items_price_5, t0.total_price AS total_price_6, t0.rent_operator AS rent_operator_7, t0.order_training AS order_training_8, t0.insurance_type AS insurance_type_9, t0.insure_storno AS insure_storno_10, t0.status AS status_11, t0.finished_step AS finished_step_12, t0.sale_flag AS sale_flag_13, t0.type AS type_14, t0.notice AS notice_15, t0.start_date_real AS start_date_real_16, t0.finish_date_real AS finish_date_real_17, t0.start_date AS start_date_18, t0.finish_date AS finish_date_19, t0.rent_price AS rent_price_20, t0.date_create AS date_create_21, t22.id AS id_23, t22.vehicle_type AS vehicle_type_24, t22.vehicle AS vehicle_25, t22.place AS place_26, t22.user AS user_27, t22.reservation_id AS reservation_id_28, t29.id AS id_30, t29.price AS price_31, t29.type AS type_32, t29.date_create AS date_create_33, t29.reservation_id AS reservation_id_34 FROM reservation t0 LEFT JOIN reservation_relation t22 ON t22.reservation_id = t0.id LEFT JOIN reservation_insurance t29 ON t29.reservation_id = t0.id WHERE t0.id = 20;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.price AS price_4,
  t0.price_interval AS price_interval_5,
  t0.date_create AS date_create_6
FROM
  reservation_item t0
  INNER JOIN reservation_reservation_items ON t0.id = reservation_reservation_items.reservation_item_id
WHERE
  reservation_reservation_items.reservation_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.price_interval AS price_interval_5, t0.date_create AS date_create_6 FROM reservation_item t0 INNER JOIN reservation_reservation_items ON t0.id = reservation_reservation_items.reservation_item_id WHERE reservation_reservation_items.reservation_id = 20;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.price AS price_4,
  t0.price_interval AS price_interval_5,
  t0.date_create AS date_create_6
FROM
  reservation_item t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.price_interval AS price_interval_5, t0.date_create AS date_create_6 FROM reservation_item t0;

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.country AS country_3,
  t0.zip AS zip_4,
  t0.city AS city_5,
  t0.state AS state_6,
  t0.altitude AS altitude_7,
  t0.name AS name_8,
  t0.longitude AS longitude_9,
  t0.latitude AS latitude_10
FROM
  place t0

SELECT t0.id AS id_1, t0.street AS street_2, t0.country AS country_3, t0.zip AS zip_4, t0.city AS city_5, t0.state AS state_6, t0.altitude AS altitude_7, t0.name AS name_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10 FROM place t0;

SELECT
  t0.id AS id_1,
  t0.date_update AS date_update_2,
  t0.technical_data AS technical_data_3,
  t0.type AS type_4,
  t0.tag AS tag_5,
  t0.date_create AS date_create_6
FROM
  vehicle_type t0

SELECT t0.id AS id_1, t0.date_update AS date_update_2, t0.technical_data AS technical_data_3, t0.type AS type_4, t0.tag AS tag_5, t0.date_create AS date_create_6 FROM vehicle_type t0;

SELECT
  v0_.id AS id_0,
  v0_.date_update AS date_update_1,
  v0_.technical_data AS technical_data_2,
  v0_.active AS active_3,
  v0_.fleet_id AS fleet_id_4,
  v0_.rental_status AS rental_status_5,
  v0_.qnr AS qnr_6,
  v0_.inverse_id AS inverse_id_7,
  v0_.vehicle_licence_plate AS vehicle_licence_plate_8,
  v0_.serial_number AS serial_number_9,
  v0_.car_manufacturer_name AS car_manufacturer_name_10,
  v0_.car_model_name AS car_model_name_11,
  v0_.fuel_type AS fuel_type_12,
  v0_.transmission AS transmission_13,
  v0_.date_create AS date_create_14,
  v0_.type_id AS type_id_15
FROM
  vehicle v0_
WHERE
  NOT (
    EXISTS (
      SELECT
        1 AS sclr_16
      FROM
        reservation_relation r1_
        INNER JOIN reservation r2_
      WHERE
        r1_.vehicle = v0_.id
        AND r2_.start_date <= ?
        AND r2_.finish_date >= ?
        AND r2_.status = ?
    )
  )

SELECT v0_.id AS id_0, v0_.date_update AS date_update_1, v0_.technical_data AS technical_data_2, v0_.active AS active_3, v0_.fleet_id AS fleet_id_4, v0_.rental_status AS rental_status_5, v0_.qnr AS qnr_6, v0_.inverse_id AS inverse_id_7, v0_.vehicle_licence_plate AS vehicle_licence_plate_8, v0_.serial_number AS serial_number_9, v0_.car_manufacturer_name AS car_manufacturer_name_10, v0_.car_model_name AS car_model_name_11, v0_.fuel_type AS fuel_type_12, v0_.transmission AS transmission_13, v0_.date_create AS date_create_14, v0_.type_id AS type_id_15 FROM vehicle v0_ WHERE NOT (EXISTS (SELECT 1 AS sclr_16 FROM reservation_relation r1_ INNER JOIN reservation r2_ WHERE r1_.vehicle = v0_.id AND r2_.start_date <= '2026-04-20 11:15:00' AND r2_.finish_date >= '2026-04-19 11:15:00' AND r2_.status = 'assigned'));

SELECT
  t0.id AS id_1,
  t0.immobilizer AS immobilizer_2,
  t0.central_lock AS central_lock_3,
  t0.handbrake AS handbrake_4,
  t0.fuel_level AS fuel_level_5,
  t0.ignition AS ignition_6,
  t0.doors AS doors_7,
  t0.lights AS lights_8,
  t0.gearshift_position AS gearshift_position_9,
  t0.mileage AS mileage_10,
  t0.mileage_since_immobilizer_unlock AS mileage_since_immobilizer_unlock_11,
  t0.board_voltage AS board_voltage_12,
  t0.keyfob AS keyfob_13,
  t0.bluetooth_connection AS bluetooth_connection_14,
  t0.central_lock_last_command AS central_lock_last_command_15,
  t0.speed AS speed_16,
  t0.request_type AS request_type_17,
  t0.timestamp AS timestamp_18,
  t0.low_battery_level_alarm AS low_battery_level_alarm_19,
  t0.low_fuel_level_alarm AS low_fuel_level_alarm_20,
  t0.user_id AS user_id_21,
  t0.vehicle_id AS vehicle_id_22
FROM
  vehicle_status t0
WHERE
  t0.vehicle_id = ?
ORDER BY
  t0.timestamp DESC

SELECT t0.id AS id_1, t0.immobilizer AS immobilizer_2, t0.central_lock AS central_lock_3, t0.handbrake AS handbrake_4, t0.fuel_level AS fuel_level_5, t0.ignition AS ignition_6, t0.doors AS doors_7, t0.lights AS lights_8, t0.gearshift_position AS gearshift_position_9, t0.mileage AS mileage_10, t0.mileage_since_immobilizer_unlock AS mileage_since_immobilizer_unlock_11, t0.board_voltage AS board_voltage_12, t0.keyfob AS keyfob_13, t0.bluetooth_connection AS bluetooth_connection_14, t0.central_lock_last_command AS central_lock_last_command_15, t0.speed AS speed_16, t0.request_type AS request_type_17, t0.timestamp AS timestamp_18, t0.low_battery_level_alarm AS low_battery_level_alarm_19, t0.low_fuel_level_alarm AS low_fuel_level_alarm_20, t0.user_id AS user_id_21, t0.vehicle_id AS vehicle_id_22 FROM vehicle_status t0 WHERE t0.vehicle_id = 15 ORDER BY t0.timestamp DESC;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.timestamp AS timestamp_4,
  t0.vehicle_status_id AS vehicle_status_id_5
FROM
  vehicle_position t0
WHERE
  t0.vehicle_status_id = ?
ORDER BY
  t0.timestamp DESC

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.timestamp AS timestamp_4, t0.vehicle_status_id AS vehicle_status_id_5 FROM vehicle_position t0 WHERE t0.vehicle_status_id = 110 ORDER BY t0.timestamp DESC;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.timestamp AS timestamp_4,
  t0.vehicle_status_id AS vehicle_status_id_5
FROM
  vehicle_position t0
WHERE
  t0.vehicle_status_id = ?
ORDER BY
  t0.timestamp DESC

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.timestamp AS timestamp_4, t0.vehicle_status_id AS vehicle_status_id_5 FROM vehicle_position t0 WHERE t0.vehicle_status_id = 106 ORDER BY t0.timestamp DESC;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.timestamp AS timestamp_4,
  t0.vehicle_status_id AS vehicle_status_id_5
FROM
  vehicle_position t0
WHERE
  t0.vehicle_status_id = ?
ORDER BY
  t0.timestamp DESC

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.timestamp AS timestamp_4, t0.vehicle_status_id AS vehicle_status_id_5 FROM vehicle_position t0 WHERE t0.vehicle_status_id = 105 ORDER BY t0.timestamp DESC;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.timestamp AS timestamp_4,
  t0.vehicle_status_id AS vehicle_status_id_5
FROM
  vehicle_position t0
WHERE
  t0.vehicle_status_id = ?
ORDER BY
  t0.timestamp DESC

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.timestamp AS timestamp_4, t0.vehicle_status_id AS vehicle_status_id_5 FROM vehicle_position t0 WHERE t0.vehicle_status_id = 104 ORDER BY t0.timestamp DESC;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.timestamp AS timestamp_4,
  t0.vehicle_status_id AS vehicle_status_id_5
FROM
  vehicle_position t0
WHERE
  t0.vehicle_status_id = ?
ORDER BY
  t0.timestamp DESC

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.timestamp AS timestamp_4, t0.vehicle_status_id AS vehicle_status_id_5 FROM vehicle_position t0 WHERE t0.vehicle_status_id = 94 ORDER BY t0.timestamp DESC;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.timestamp AS timestamp_4,
  t0.vehicle_status_id AS vehicle_status_id_5
FROM
  vehicle_position t0
WHERE
  t0.vehicle_status_id = ?
ORDER BY
  t0.timestamp DESC

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.timestamp AS timestamp_4, t0.vehicle_status_id AS vehicle_status_id_5 FROM vehicle_position t0 WHERE t0.vehicle_status_id = 85 ORDER BY t0.timestamp DESC;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.timestamp AS timestamp_4,
  t0.vehicle_status_id AS vehicle_status_id_5
FROM
  vehicle_position t0
WHERE
  t0.vehicle_status_id = ?
ORDER BY
  t0.timestamp DESC

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.timestamp AS timestamp_4, t0.vehicle_status_id AS vehicle_status_id_5 FROM vehicle_position t0 WHERE t0.vehicle_status_id = 76 ORDER BY t0.timestamp DESC;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.timestamp AS timestamp_4,
  t0.vehicle_status_id AS vehicle_status_id_5
FROM
  vehicle_position t0
WHERE
  t0.vehicle_status_id = ?
ORDER BY
  t0.timestamp DESC

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.timestamp AS timestamp_4, t0.vehicle_status_id AS vehicle_status_id_5 FROM vehicle_position t0 WHERE t0.vehicle_status_id = 67 ORDER BY t0.timestamp DESC;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.timestamp AS timestamp_4,
  t0.vehicle_status_id AS vehicle_status_id_5
FROM
  vehicle_position t0
WHERE
  t0.vehicle_status_id = ?
ORDER BY
  t0.timestamp DESC

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.timestamp AS timestamp_4, t0.vehicle_status_id AS vehicle_status_id_5 FROM vehicle_position t0 WHERE t0.vehicle_status_id = 58 ORDER BY t0.timestamp DESC;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.timestamp AS timestamp_4,
  t0.vehicle_status_id AS vehicle_status_id_5
FROM
  vehicle_position t0
WHERE
  t0.vehicle_status_id = ?
ORDER BY
  t0.timestamp DESC

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.timestamp AS timestamp_4, t0.vehicle_status_id AS vehicle_status_id_5 FROM vehicle_position t0 WHERE t0.vehicle_status_id = 49 ORDER BY t0.timestamp DESC;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.timestamp AS timestamp_4,
  t0.vehicle_status_id AS vehicle_status_id_5
FROM
  vehicle_position t0
WHERE
  t0.vehicle_status_id = ?
ORDER BY
  t0.timestamp DESC

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.timestamp AS timestamp_4, t0.vehicle_status_id AS vehicle_status_id_5 FROM vehicle_position t0 WHERE t0.vehicle_status_id = 40 ORDER BY t0.timestamp DESC;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.timestamp AS timestamp_4,
  t0.vehicle_status_id AS vehicle_status_id_5
FROM
  vehicle_position t0
WHERE
  t0.vehicle_status_id = ?
ORDER BY
  t0.timestamp DESC

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.timestamp AS timestamp_4, t0.vehicle_status_id AS vehicle_status_id_5 FROM vehicle_position t0 WHERE t0.vehicle_status_id = 30 ORDER BY t0.timestamp DESC;