Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.label AS label_3,
  t0.active AS active_4,
  t0.client_id AS client_id_5
FROM
  ClientIpAddress t0
WHERE
  t0.value = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.label AS label_3, t0.active AS active_4, t0.client_id AS client_id_5 FROM ClientIpAddress t0 WHERE t0.value = '10.10.100.199' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.apikey AS apikey_3,
  t0.phone AS phone_4,
  t0.email AS email_5,
  t0.address AS address_6,
  t0.logo AS logo_7,
  t0.active AS active_8,
  t0.currency AS currency_9,
  t10.id AS id_11,
  t10.email AS email_12,
  t10.roles AS roles_13,
  t10.password AS password_14,
  t10.display_name AS display_name_15,
  t10.isVerified AS isVerified_16,
  t10.username AS username_17,
  t10.active AS active_18,
  t10.client_id AS client_id_19
FROM
  Client t0
  LEFT JOIN User t10 ON t10.client_id = t0.id
WHERE
  t0.apikey = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.apikey AS apikey_3, t0.phone AS phone_4, t0.email AS email_5, t0.address AS address_6, t0.logo AS logo_7, t0.active AS active_8, t0.currency AS currency_9, t10.id AS id_11, t10.email AS email_12, t10.roles AS roles_13, t10.password AS password_14, t10.display_name AS display_name_15, t10.isVerified AS isVerified_16, t10.username AS username_17, t10.active AS active_18, t10.client_id AS client_id_19 FROM Client t0 LEFT JOIN User t10 ON t10.client_id = t0.id WHERE t0.apikey = 'royaume@voyages@123+-' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.display_name AS display_name_5,
  t0.isVerified AS isVerified_6,
  t0.username AS username_7,
  t0.active AS active_8,
  t0.client_id AS client_id_9
FROM
  User t0
WHERE
  t0.client_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5, t0.isVerified AS isVerified_6, t0.username AS username_7, t0.active AS active_8, t0.client_id AS client_id_9 FROM User t0 WHERE t0.client_id = 5 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO ApiLog (
  baseUrl, endpoint, request, response,
  statusCode, statusMessage, customerID,
  userID, date, elapsedTime, searchCode,
  tag, hotel, city, providerSearchCode,
  provider_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO ApiLog (baseUrl, endpoint, request, response, statusCode, statusMessage, customerID, userID, date, elapsedTime, searchCode, tag, hotel, city, providerSearchCode, provider_id) VALUES ('/api/flight', 'availability', '{\"natureTrip\":1,\"currency\":\"TND\",\"numberAdult\":\"1\",\"numberChild\":\"0\",\"numberInfants\":\"0\",\"directFlight\":false,\"refundable\":false,\"onlyLuggage\":false,\"fare\":\"STANDARD\",\"cabin_class\":\"ECONOMY\",\"itineraries\":[{\"originLocationCode\":\"TUN\",\"destinationLocationCode\":\"ROM\",\"departureDateTime\":\"2026-09-15T00:00:00\"}],\"sourceId\":\"7\"}', NULL, 200, 'WAITING', 5, 6, '2026-08-05 12:47:49', 0.029014110565186, NULL, NULL, NULL, NULL, NULL, NULL);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.partnerName AS partnerName_2,
  t0.url AS url_3,
  t0.active AS active_4,
  t0.apikey AS apikey_5,
  t0.sharedSecret AS sharedSecret_6,
  t0.login AS login_7,
  t0.password AS password_8,
  t0.timeout AS timeout_9,
  t0.lastToken AS lastToken_10,
  t0.lastDateToken AS lastDateToken_11,
  t0.currency AS currency_12,
  t0.apiMode AS apiMode_13,
  t0.companyId AS companyId_14,
  t0.bookingUrl AS bookingUrl_15,
  t0.provider_id AS provider_id_16,
  t0.client_id AS client_id_17
FROM
  XmlLink t0
WHERE
  t0.client_id = ?
  AND t0.active = ?
  AND t0.id = ?

SELECT t0.id AS id_1, t0.partnerName AS partnerName_2, t0.url AS url_3, t0.active AS active_4, t0.apikey AS apikey_5, t0.sharedSecret AS sharedSecret_6, t0.login AS login_7, t0.password AS password_8, t0.timeout AS timeout_9, t0.lastToken AS lastToken_10, t0.lastDateToken AS lastDateToken_11, t0.currency AS currency_12, t0.apiMode AS apiMode_13, t0.companyId AS companyId_14, t0.bookingUrl AS bookingUrl_15, t0.provider_id AS provider_id_16, t0.client_id AS client_id_17 FROM XmlLink t0 WHERE t0.client_id = 5 AND t0.active = 1 AND t0.id = '7';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.codeGDS AS codeGDS_3,
  t0.color AS color_4
FROM
  XmlProvider t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.codeGDS AS codeGDS_3, t0.color AS color_4 FROM XmlProvider t0 WHERE t0.id = 3;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO ApiLog (
  baseUrl, endpoint, request, response,
  statusCode, statusMessage, customerID,
  userID, date, elapsedTime, searchCode,
  tag, hotel, city, providerSearchCode,
  provider_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO ApiLog (baseUrl, endpoint, request, response, statusCode, statusMessage, customerID, userID, date, elapsedTime, searchCode, tag, hotel, city, providerSearchCode, provider_id) VALUES ('/FlightRest', 'searchFlight', '{\"SearchRQ\":{\"Search\":{\"DepartCFN\":\"TUN\",\"ArrivalCFN\":\"ROM\",\"DepartAP\":\"TUN\",\"ArrivalAP\":\"ROM\",\"DepartDate\":\"2026-09-15\",\"DepartTime\":\"00:00:00\"},\"Authentication\":{\"UrlAuthentication\":null,\"URL\":\"http:\\/\\/www.eye4travel.com\",\"ServiceType\":\"AIR\",\"IP\":\"122.166.128.15\",\"IsApiUser\":\"True\",\"APIKey\":\"WEFDKJN876-OIQEKDM-56IKJDN\",\"APIMode\":\"LIVE\"},\"GeneralInfo\":{\"GUID\":\"6a7322e57c9f7-df55a5ea\",\"SearchLang\":\"EN\",\"IsDynPkg\":\"false\",\"Currency\":\"TND\",\"Agent_Curr\":\"TND\",\"Gross_Curr\":\"TND\",\"Cabin\":\"EC\",\"TripType\":\"OW\",\"JourneyType\":\"INT\",\"CompanyId\":\"DBT\",\"Channel\":\"subagent\",\"DecPrefrences\":\"1\",\"LangCode\":\"EN\",\"JsonResponse\":\"true\",\"AgentId\":\"\",\"BranchId\":\"0\"},\"PaxDetails\":{\"Adults\":1,\"Childs\":0,\"Infant\":0},\"AdvanceSearch\":{\"IsSpcl\":\"False\",\"isFlexi\":\"false\",\"isFareBreakup\":\"False\",\"DirectFlight\":false,\"IncludeBaggage\":\"false\",\"IsLcc\":\"False\",\"SpecificAirlines\":{\"Airline\":[\"All\",\"\",\"\"]}}}}', '{\"count\":68}', 200, 'OK', 5, 6, '2026-08-05 12:47:54', 5.4116578102112, 'j8TvbBwpGR4MAuvYpAdWJQ==', NULL, NULL, NULL, '6a7322e57c9f7-df55a5ea', 3);

"COMMIT"

"COMMIT";

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.cityCode AS cityCode_3,
  t0.cityName AS cityName_4,
  t0.countryName AS countryName_5,
  t0.countryCode AS countryCode_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8
FROM
  Airport t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.cityCode AS cityCode_3, t0.cityName AS cityName_4, t0.countryName AS countryName_5, t0.countryCode AS countryCode_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8 FROM Airport t0 WHERE t0.code = 'TUN' LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.cityCode AS cityCode_3,
  t0.cityName AS cityName_4,
  t0.countryName AS countryName_5,
  t0.countryCode AS countryCode_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8
FROM
  Airport t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.cityCode AS cityCode_3, t0.cityName AS cityName_4, t0.countryName AS countryName_5, t0.countryCode AS countryCode_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8 FROM Airport t0 WHERE t0.code = 'FCO' LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.cityCode AS cityCode_3,
  t0.cityName AS cityName_4,
  t0.countryName AS countryName_5,
  t0.countryCode AS countryCode_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8
FROM
  Airport t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.cityCode AS cityCode_3, t0.cityName AS cityName_4, t0.countryName AS countryName_5, t0.countryCode AS countryCode_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8 FROM Airport t0 WHERE t0.code = 'DUS' LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.cityCode AS cityCode_3,
  t0.cityName AS cityName_4,
  t0.countryName AS countryName_5,
  t0.countryCode AS countryCode_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8
FROM
  Airport t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.cityCode AS cityCode_3, t0.cityName AS cityName_4, t0.countryName AS countryName_5, t0.countryCode AS countryCode_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8 FROM Airport t0 WHERE t0.code = 'MUC' LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.cityCode AS cityCode_3,
  t0.cityName AS cityName_4,
  t0.countryName AS countryName_5,
  t0.countryCode AS countryCode_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8
FROM
  Airport t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.cityCode AS cityCode_3, t0.cityName AS cityName_4, t0.countryName AS countryName_5, t0.countryCode AS countryCode_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8 FROM Airport t0 WHERE t0.code = 'CDG' LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.cityCode AS cityCode_3,
  t0.cityName AS cityName_4,
  t0.countryName AS countryName_5,
  t0.countryCode AS countryCode_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8
FROM
  Airport t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.cityCode AS cityCode_3, t0.cityName AS cityName_4, t0.countryName AS countryName_5, t0.countryCode AS countryCode_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8 FROM Airport t0 WHERE t0.code = 'IST' LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.cityCode AS cityCode_3,
  t0.cityName AS cityName_4,
  t0.countryName AS countryName_5,
  t0.countryCode AS countryCode_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8
FROM
  Airport t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.cityCode AS cityCode_3, t0.cityName AS cityName_4, t0.countryName AS countryName_5, t0.countryCode AS countryCode_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8 FROM Airport t0 WHERE t0.code = 'DOH' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.baseUrl AS baseUrl_2,
  t0.endpoint AS endpoint_3,
  t0.request AS request_4,
  t0.response AS response_5,
  t0.statusCode AS statusCode_6,
  t0.statusMessage AS statusMessage_7,
  t0.customerID AS customerID_8,
  t0.userID AS userID_9,
  t0.date AS date_10,
  t0.elapsedTime AS elapsedTime_11,
  t0.searchCode AS searchCode_12,
  t0.tag AS tag_13,
  t0.hotel AS hotel_14,
  t0.city AS city_15,
  t0.providerSearchCode AS providerSearchCode_16,
  t0.provider_id AS provider_id_17
FROM
  ApiLog t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.baseUrl AS baseUrl_2, t0.endpoint AS endpoint_3, t0.request AS request_4, t0.response AS response_5, t0.statusCode AS statusCode_6, t0.statusMessage AS statusMessage_7, t0.customerID AS customerID_8, t0.userID AS userID_9, t0.date AS date_10, t0.elapsedTime AS elapsedTime_11, t0.searchCode AS searchCode_12, t0.tag AS tag_13, t0.hotel AS hotel_14, t0.city AS city_15, t0.providerSearchCode AS providerSearchCode_16, t0.provider_id AS provider_id_17 FROM ApiLog t0 WHERE t0.id = 5848 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  ApiLog
SET
  statusMessage = ?,
  elapsedTime = ?
WHERE
  id = ?

UPDATE ApiLog SET statusMessage = 'GENX|OK PROCESS|68', elapsedTime = 5.475615978241 WHERE id = 5848;

"COMMIT"

"COMMIT";