Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.route_permissions AS route_permissions_4,
  t0.menu_permissions AS menu_permissions_5,
  t0.password AS password_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.is_verified AS is_verified_9,
  t0.picture AS picture_10,
  t0.phone AS phone_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.pwd_token AS pwd_token_14,
  t0.password_token_expires_at AS password_token_expires_at_15,
  t0.is_active AS is_active_16,
  t0.last_login AS last_login_17,
  t0.company_id AS company_id_18
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.route_permissions AS route_permissions_4, t0.menu_permissions AS menu_permissions_5, t0.password AS password_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.is_verified AS is_verified_9, t0.picture AS picture_10, t0.phone AS phone_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.pwd_token AS pwd_token_14, t0.password_token_expires_at AS password_token_expires_at_15, t0.is_active AS is_active_16, t0.last_login AS last_login_17, t0.company_id AS company_id_18 FROM user t0 WHERE t0.email = 'admin@blacksheep-van.com' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.date_begin AS date_begin_3,
  t0.date_end AS date_end_4,
  t0.km AS km_5,
  t0.booking_reference AS booking_reference_6,
  t0.created_at AS created_at_7,
  t0.status AS status_8,
  t0.product_id AS product_id_9,
  t0.creator_id AS creator_id_10,
  t0.agency_source_id AS agency_source_id_11,
  t0.agency_target_id AS agency_target_id_12,
  t13.id AS id_14,
  t13.date_begin AS date_begin_15,
  t13.date_end AS date_end_16,
  t13.is_active AS is_active_17,
  t13.product_id AS product_id_18,
  t13.product_event_id AS product_event_id_19,
  t13.agency_source_id AS agency_source_id_20,
  t13.agency_target_id AS agency_target_id_21
FROM
  product_event t0
  LEFT JOIN conveying_product t13 ON t13.product_event_id = t0.id
WHERE
  t0.booking_reference = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.date_begin AS date_begin_3, t0.date_end AS date_end_4, t0.km AS km_5, t0.booking_reference AS booking_reference_6, t0.created_at AS created_at_7, t0.status AS status_8, t0.product_id AS product_id_9, t0.creator_id AS creator_id_10, t0.agency_source_id AS agency_source_id_11, t0.agency_target_id AS agency_target_id_12, t13.id AS id_14, t13.date_begin AS date_begin_15, t13.date_end AS date_end_16, t13.is_active AS is_active_17, t13.product_id AS product_id_18, t13.product_event_id AS product_event_id_19, t13.agency_source_id AS agency_source_id_20, t13.agency_target_id AS agency_target_id_21 FROM product_event t0 LEFT JOIN conveying_product t13 ON t13.product_event_id = t0.id WHERE t0.booking_reference = 'RESA-3837';

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.label AS label_3,
  t0.updated_at AS updated_at_4,
  t0.park_release_date AS park_release_date_5,
  t0.park_entry_date AS park_entry_date_6,
  t0.api AS api_7,
  t0.model_id AS model_id_8,
  t0.product_category_id AS product_category_id_9,
  t0.vehicle_document_id AS vehicle_document_id_10,
  t0.agency_id AS agency_id_11
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.label AS label_3, t0.updated_at AS updated_at_4, t0.park_release_date AS park_release_date_5, t0.park_entry_date AS park_entry_date_6, t0.api AS api_7, t0.model_id AS model_id_8, t0.product_category_id AS product_category_id_9, t0.vehicle_document_id AS vehicle_document_id_10, t0.agency_id AS agency_id_11 FROM product t0 WHERE t0.id = 1347;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.immatriculation AS immatriculation_4,
  t0.immatriculation_date AS immatriculation_date_5,
  t0.type AS type_6,
  t0.serial_number AS serial_number_7,
  t0.car_body AS car_body_8,
  t0.energy AS energy_9,
  t0.tank_capacity AS tank_capacity_10,
  t0.color AS color_11,
  t0.tax_horsepower AS tax_horsepower_12,
  t0.purchase_date AS purchase_date_13,
  t0.purchase_price AS purchase_price_14,
  t0.co2 AS co2_15,
  t0.date1st_circulation AS date1st_circulation_16,
  t0.gears AS gears_17,
  t0.passengers AS passengers_18,
  t0.doors AS doors_19,
  t0.weight AS weight_20,
  t0.commercial_name AS commercial_name_21,
  t0.brand_logo AS brand_logo_22,
  t0.km AS km_23,
  t0.kmwpdate AS kmwpdate_24,
  t0.owner_id AS owner_id_25
FROM
  vehicle_document t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.immatriculation AS immatriculation_4, t0.immatriculation_date AS immatriculation_date_5, t0.type AS type_6, t0.serial_number AS serial_number_7, t0.car_body AS car_body_8, t0.energy AS energy_9, t0.tank_capacity AS tank_capacity_10, t0.color AS color_11, t0.tax_horsepower AS tax_horsepower_12, t0.purchase_date AS purchase_date_13, t0.purchase_price AS purchase_price_14, t0.co2 AS co2_15, t0.date1st_circulation AS date1st_circulation_16, t0.gears AS gears_17, t0.passengers AS passengers_18, t0.doors AS doors_19, t0.weight AS weight_20, t0.commercial_name AS commercial_name_21, t0.brand_logo AS brand_logo_22, t0.km AS km_23, t0.kmwpdate AS kmwpdate_24, t0.owner_id AS owner_id_25 FROM vehicle_document t0 WHERE t0.id = 1347;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.type AS type_3,
  t0.reference AS reference_4,
  t0.updated_at AS updated_at_5
FROM
  product_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.type AS type_3, t0.reference AS reference_4, t0.updated_at AS updated_at_5 FROM product_category t0 WHERE t0.id = 22;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO app_log (
  activity, created_at, user, module,
  session, response, code
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO app_log (activity, created_at, user, module, session, response, code) VALUES ('User \"admin@blacksheep-van.com\" performed POST /api/product_events/find (HTTP 200)', '2026-01-21 00:34:06', 'admin@blacksheep-van.com', 'product_events', '{\"iat\":1768951916,\"exp\":1768955516,\"jti\":\"76378157b8edc8c198714dd436b5cdd5\",\"roles\":[\"ROLE_SUPER_ADMIN\",\"ROLE_USER\"],\"username\":\"admin@blacksheep-van.com\"}', '[{\"id\":13239,\"type\":\"Booking\",\"bookingReference\":\"RESA-3837\",\"dateBegin\":{\"date\":\"2026-06-08 16:00:00.000000\",\"timezone_type\":3,\"timezone\":\"Europe\\/Paris\"},\"dateEnd\":{\"date\":\"2026-06-11 12:00:00.000000\",\"timezone_type\":3,\"timezone\":\"Europe\\/Paris\"},\"createdAt\":{\"date\":\"2026-01-21 00:31:53.000000\",\"timezone_type\":3,\"timezone\":\"Europe\\/Paris\"},\"product\":{\"id\":1347,\"label\":\"BURSTNER COPA + - Blanc - BVM (gestion locative)\",\"immatriculation\":\"GM-581-ZX (GL)\",\"category\":{\"id\":22,\"label\":\"BAROUDEUR +\"}}}]', '200');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO app_log (
  activity, created_at, user, module,
  session, response, code
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO app_log (activity, created_at, user, module, session, response, code) VALUES ('User \"admin@blacksheep-van.com\" performed POST /api/product_events/find (HTTP 200)', '2026-01-21 00:34:06', 'admin@blacksheep-van.com', 'product_events', '{\"iat\":1768951916,\"exp\":1768955516,\"jti\":\"76378157b8edc8c198714dd436b5cdd5\",\"roles\":[\"ROLE_SUPER_ADMIN\",\"ROLE_USER\"],\"username\":\"admin@blacksheep-van.com\"}', '[{\"id\":13239,\"type\":\"Booking\",\"bookingReference\":\"RESA-3837\",\"dateBegin\":{\"date\":\"2026-06-08 16:00:00.000000\",\"timezone_type\":3,\"timezone\":\"Europe\\/Paris\"},\"dateEnd\":{\"date\":\"2026-06-11 12:00:00.000000\",\"timezone_type\":3,\"timezone\":\"Europe\\/Paris\"},\"createdAt\":{\"date\":\"2026-01-21 00:31:53.000000\",\"timezone_type\":3,\"timezone\":\"Europe\\/Paris\"},\"product\":{\"id\":1347,\"label\":\"BURSTNER COPA + - Blanc - BVM (gestion locative)\",\"immatriculation\":\"GM-581-ZX (GL)\",\"category\":{\"id\":22,\"label\":\"BAROUDEUR +\"}}}]', '200');

"COMMIT"

"COMMIT";