Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.role AS role_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.role AS role_4 FROM user t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.json AS json_2,
  t0.updated AS updated_3,
  t0.connection_id AS connection_id_4
FROM
  ApiPreloadBooking t0

SELECT t0.id AS id_1, t0.json AS json_2, t0.updated AS updated_3, t0.connection_id AS connection_id_4 FROM ApiPreloadBooking t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.apiKey AS apiKey_3,
  t0.clientKey AS clientKey_4,
  t0.clientId AS clientId_5,
  t0.brokerFee AS brokerFee_6,
  t0.validUntil AS validUntil_7,
  t0.clientInternal_id AS clientInternal_id_8
FROM
  ApiConnection t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.apiKey AS apiKey_3,
  t0.clientKey AS clientKey_4,
  t0.clientId AS clientId_5,
  t0.brokerFee AS brokerFee_6,
  t0.validUntil AS validUntil_7,
  t0.clientInternal_id AS clientInternal_id_8
FROM
  ApiConnection t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.apiKey AS apiKey_3,
  t0.clientKey AS clientKey_4,
  t0.clientId AS clientId_5,
  t0.brokerFee AS brokerFee_6,
  t0.validUntil AS validUntil_7,
  t0.clientInternal_id AS clientInternal_id_8
FROM
  ApiConnection t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.apiKey AS apiKey_3,
  t0.clientKey AS clientKey_4,
  t0.clientId AS clientId_5,
  t0.brokerFee AS brokerFee_6,
  t0.validUntil AS validUntil_7,
  t0.clientInternal_id AS clientInternal_id_8
FROM
  ApiConnection t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.apiKey AS apiKey_3,
  t0.clientKey AS clientKey_4,
  t0.clientId AS clientId_5,
  t0.brokerFee AS brokerFee_6,
  t0.validUntil AS validUntil_7,
  t0.clientInternal_id AS clientInternal_id_8
FROM
  ApiConnection t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.apiKey AS apiKey_3,
  t0.clientKey AS clientKey_4,
  t0.clientId AS clientId_5,
  t0.brokerFee AS brokerFee_6,
  t0.validUntil AS validUntil_7,
  t0.clientInternal_id AS clientInternal_id_8
FROM
  ApiConnection t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = 12;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.apiKey AS apiKey_3,
  t0.clientKey AS clientKey_4,
  t0.clientId AS clientId_5,
  t0.brokerFee AS brokerFee_6,
  t0.validUntil AS validUntil_7,
  t0.clientInternal_id AS clientInternal_id_8
FROM
  ApiConnection t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = 13;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.apiKey AS apiKey_3,
  t0.clientKey AS clientKey_4,
  t0.clientId AS clientId_5,
  t0.brokerFee AS brokerFee_6,
  t0.validUntil AS validUntil_7,
  t0.clientInternal_id AS clientInternal_id_8
FROM
  ApiConnection t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = 14;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.apiKey AS apiKey_3,
  t0.clientKey AS clientKey_4,
  t0.clientId AS clientId_5,
  t0.brokerFee AS brokerFee_6,
  t0.validUntil AS validUntil_7,
  t0.clientInternal_id AS clientInternal_id_8
FROM
  ApiConnection t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = 15;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.apiKey AS apiKey_3,
  t0.clientKey AS clientKey_4,
  t0.clientId AS clientId_5,
  t0.brokerFee AS brokerFee_6,
  t0.validUntil AS validUntil_7,
  t0.clientInternal_id AS clientInternal_id_8
FROM
  ApiConnection t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = 16;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.apiKey AS apiKey_3,
  t0.clientKey AS clientKey_4,
  t0.clientId AS clientId_5,
  t0.brokerFee AS brokerFee_6,
  t0.validUntil AS validUntil_7,
  t0.clientInternal_id AS clientInternal_id_8
FROM
  ApiConnection t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = 21;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.nameInternal AS nameInternal_3,
  t0.color AS color_4,
  t0.icon AS icon_5,
  t0.position AS position_6
FROM
  DetailStatus t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.nameInternal AS nameInternal_3, t0.color AS color_4, t0.icon AS icon_5, t0.position AS position_6 FROM DetailStatus t0 WHERE t0.id = '3';

SELECT
  t0.id AS id_1,
  t0.agency AS agency_2,
  t0.product AS product_3,
  t0.reference AS reference_4,
  t0.lastName AS lastName_5,
  t0.firstName AS firstName_6,
  t0.duration AS duration_7,
  t0.arrivalDate AS arrivalDate_8,
  t0.arrivalTime AS arrivalTime_9,
  t0.departureDate AS departureDate_10,
  t0.departureTime AS departureTime_11,
  t0.passengers AS passengers_12,
  t0.status AS status_13,
  t0.price AS price_14,
  t0.licensePlate AS licensePlate_15,
  t0.model AS model_16,
  t0.color AS color_17,
  t0.phone AS phone_18,
  t0.notice AS notice_19,
  t0.flightNumberArrival AS flightNumberArrival_20,
  t0.flightNumberDeparture AS flightNumberDeparture_21,
  t0.terminalDeparture AS terminalDeparture_22,
  t0.terminalArrival AS terminalArrival_23,
  t0.paymentStatus AS paymentStatus_24,
  t0.createdByApiAt AS createdByApiAt_25,
  t0.updatedByApiAt AS updatedByApiAt_26,
  t0.createdAt AS createdAt_27,
  t0.updatedAt AS updatedAt_28,
  t0.isNative AS isNative_29,
  t0.isManual AS isManual_30,
  t0.email AS email_31,
  t0.ApiConnection_id AS ApiConnection_id_32,
  t0.NativeDatabase_id AS NativeDatabase_id_33
FROM
  ApiBooking t0
WHERE
  t0.reference = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.agency AS agency_2, t0.product AS product_3, t0.reference AS reference_4, t0.lastName AS lastName_5, t0.firstName AS firstName_6, t0.duration AS duration_7, t0.arrivalDate AS arrivalDate_8, t0.arrivalTime AS arrivalTime_9, t0.departureDate AS departureDate_10, t0.departureTime AS departureTime_11, t0.passengers AS passengers_12, t0.status AS status_13, t0.price AS price_14, t0.licensePlate AS licensePlate_15, t0.model AS model_16, t0.color AS color_17, t0.phone AS phone_18, t0.notice AS notice_19, t0.flightNumberArrival AS flightNumberArrival_20, t0.flightNumberDeparture AS flightNumberDeparture_21, t0.terminalDeparture AS terminalDeparture_22, t0.terminalArrival AS terminalArrival_23, t0.paymentStatus AS paymentStatus_24, t0.createdByApiAt AS createdByApiAt_25, t0.updatedByApiAt AS updatedByApiAt_26, t0.createdAt AS createdAt_27, t0.updatedAt AS updatedAt_28, t0.isNative AS isNative_29, t0.isManual AS isManual_30, t0.email AS email_31, t0.ApiConnection_id AS ApiConnection_id_32, t0.NativeDatabase_id AS NativeDatabase_id_33 FROM ApiBooking t0 WHERE t0.reference = 'DGD1L2' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.note AS note_3,
  t0.apiBooking_id AS apiBooking_id_4,
  t0.nativeDatabase_id AS nativeDatabase_id_5,
  t0.arrivalStatus_id AS arrivalStatus_id_6,
  t0.departureStatus_id AS departureStatus_id_7
FROM
  BookingDetailStatus t0
WHERE
  t0.apiBooking_id = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.note AS note_3, t0.apiBooking_id AS apiBooking_id_4, t0.nativeDatabase_id AS nativeDatabase_id_5, t0.arrivalStatus_id AS arrivalStatus_id_6, t0.departureStatus_id AS departureStatus_id_7 FROM BookingDetailStatus t0 WHERE t0.apiBooking_id = 20724 ORDER BY t0.id DESC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  ApiConnection
SET
  clientId = ?
WHERE
  id = ?

UPDATE ApiConnection SET clientId = '0' WHERE id = 3;

UPDATE
  ApiConnection
SET
  clientId = ?
WHERE
  id = ?

UPDATE ApiConnection SET clientId = '0' WHERE id = 4;

UPDATE
  ApiConnection
SET
  clientId = ?
WHERE
  id = ?

UPDATE ApiConnection SET clientId = '0' WHERE id = 5;

UPDATE
  ApiConnection
SET
  clientId = ?
WHERE
  id = ?

UPDATE ApiConnection SET clientId = '0' WHERE id = 6;

UPDATE
  ApiConnection
SET
  clientId = ?
WHERE
  id = ?

UPDATE ApiConnection SET clientId = '1484' WHERE id = 7;

UPDATE
  ApiConnection
SET
  clientId = ?
WHERE
  id = ?

UPDATE ApiConnection SET clientId = '0' WHERE id = 12;

UPDATE
  ApiConnection
SET
  clientId = ?
WHERE
  id = ?

UPDATE ApiConnection SET clientId = '0' WHERE id = 13;

UPDATE
  ApiConnection
SET
  clientId = ?
WHERE
  id = ?

UPDATE ApiConnection SET clientId = '0' WHERE id = 14;

UPDATE
  ApiConnection
SET
  clientId = ?
WHERE
  id = ?

UPDATE ApiConnection SET clientId = '0' WHERE id = 15;

UPDATE
  ApiConnection
SET
  clientId = ?
WHERE
  id = ?

UPDATE ApiConnection SET clientId = '0' WHERE id = 16;

UPDATE
  ApiConnection
SET
  clientId = ?
WHERE
  id = ?

UPDATE ApiConnection SET clientId = '0' WHERE id = 21;

UPDATE
  BookingDetailStatus
SET
  departureStatus_id = ?
WHERE
  id = ?

UPDATE BookingDetailStatus SET departureStatus_id = 3 WHERE id = 6624;

"COMMIT"

"COMMIT";