Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 47
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

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

[
  "45.67.217.146"
]

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 = '45.67.217.146' 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, t9.id AS id_10, t9.email AS email_11, t9.active AS active_12, t9.display_name AS display_name_13, t9.username AS username_14, t9.roles AS roles_15, t9.password AS password_16, t9.isVerified AS isVerified_17, t9.emailAuthCode AS emailAuthCode_18, t9.totpSecret AS totpSecret_19, t9.twoFactorMethod AS twoFactorMethod_20, t9.phoneNumber AS phoneNumber_21, t9.client_id AS client_id_22 FROM Client t0 LEFT JOIN User t9 ON t9.client_id = t0.id WHERE t0.apikey = ? LIMIT 1

[
  "chokri123"
]

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,
  t9.id AS id_10,
  t9.email AS email_11,
  t9.active AS active_12,
  t9.display_name AS display_name_13,
  t9.username AS username_14,
  t9.roles AS roles_15,
  t9.password AS password_16,
  t9.isVerified AS isVerified_17,
  t9.emailAuthCode AS emailAuthCode_18,
  t9.totpSecret AS totpSecret_19,
  t9.twoFactorMethod AS twoFactorMethod_20,
  t9.phoneNumber AS phoneNumber_21,
  t9.client_id AS client_id_22
FROM
  Client t0
  LEFT JOIN User t9 ON t9.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, t9.id AS id_10, t9.email AS email_11, t9.active AS active_12, t9.display_name AS display_name_13, t9.username AS username_14, t9.roles AS roles_15, t9.password AS password_16, t9.isVerified AS isVerified_17, t9.emailAuthCode AS emailAuthCode_18, t9.totpSecret AS totpSecret_19, t9.twoFactorMethod AS twoFactorMethod_20, t9.phoneNumber AS phoneNumber_21, t9.client_id AS client_id_22 FROM Client t0 LEFT JOIN User t9 ON t9.client_id = t0.id WHERE t0.apikey = 'chokri123' LIMIT 1;

SELECT t0.id AS id_1, t0.email AS email_2, t0.active AS active_3, t0.display_name AS display_name_4, t0.username AS username_5, t0.roles AS roles_6, t0.password AS password_7, t0.isVerified AS isVerified_8, t0.emailAuthCode AS emailAuthCode_9, t0.totpSecret AS totpSecret_10, t0.twoFactorMethod AS twoFactorMethod_11, t0.phoneNumber AS phoneNumber_12, t0.client_id AS client_id_13 FROM User t0 WHERE t0.client_id = ? LIMIT 1

[
  4
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.active AS active_3,
  t0.display_name AS display_name_4,
  t0.username AS username_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.isVerified AS isVerified_8,
  t0.emailAuthCode AS emailAuthCode_9,
  t0.totpSecret AS totpSecret_10,
  t0.twoFactorMethod AS twoFactorMethod_11,
  t0.phoneNumber AS phoneNumber_12,
  t0.client_id AS client_id_13
FROM
  User t0
WHERE
  t0.client_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.active AS active_3, t0.display_name AS display_name_4, t0.username AS username_5, t0.roles AS roles_6, t0.password AS password_7, t0.isVerified AS isVerified_8, t0.emailAuthCode AS emailAuthCode_9, t0.totpSecret AS totpSecret_10, t0.twoFactorMethod AS twoFactorMethod_11, t0.phoneNumber AS phoneNumber_12, t0.client_id AS client_id_13 FROM User t0 WHERE t0.client_id = 4 LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.description AS description_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.country_id AS country_id_7, t0.image_id AS image_id_8 FROM City t0 WHERE t0.id = ?

[
  "569"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.description AS description_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.country_id AS country_id_7,
  t0.image_id AS image_id_8
FROM
  City t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.description AS description_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.country_id AS country_id_7, t0.image_id AS image_id_8 FROM City t0 WHERE t0.id = '569';

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

[
  "EBOOKINGCENTER"
]

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.codeGDS AS codeGDS_3, t0.color AS color_4, t0.token AS token_5 FROM XmlProvider t0 WHERE t0.codeGDS = 'EBOOKINGCENTER' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.codeGDS AS codeGDS_3, t0.color AS color_4, t0.token AS token_5 FROM XmlProvider t0 INNER JOIN client_provider ON t0.id = client_provider.xmlprovider_id WHERE client_provider.client_id = ?

[
  4
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.codeGDS AS codeGDS_3,
  t0.color AS color_4,
  t0.token AS token_5
FROM
  XmlProvider t0
  INNER JOIN client_provider ON t0.id = client_provider.xmlprovider_id
WHERE
  client_provider.client_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.codeGDS AS codeGDS_3, t0.color AS color_4, t0.token AS token_5 FROM XmlProvider t0 INNER JOIN client_provider ON t0.id = client_provider.xmlprovider_id WHERE client_provider.client_id = 4;

SELECT t0.id AS id_1, t0.name AS name_2, t0.externalId AS externalId_3, t0.country AS country_4, t0.map_trace AS map_trace_5, t0.is_ignored AS is_ignored_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.city_id AS city_id_9, t0.provider_id AS provider_id_10 FROM CityProvider t0 WHERE t0.provider_id = ? AND t0.city_id = ?

[
  2
  569
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.externalId AS externalId_3,
  t0.country AS country_4,
  t0.map_trace AS map_trace_5,
  t0.is_ignored AS is_ignored_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8,
  t0.city_id AS city_id_9,
  t0.provider_id AS provider_id_10
FROM
  CityProvider t0
WHERE
  t0.provider_id = ?
  AND t0.city_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.externalId AS externalId_3, t0.country AS country_4, t0.map_trace AS map_trace_5, t0.is_ignored AS is_ignored_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.city_id AS city_id_9, t0.provider_id AS provider_id_10 FROM CityProvider t0 WHERE t0.provider_id = 2 AND t0.city_id = 569;

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.externalId AS externalId_2, h0_.latitude AS latitude_3, h0_.longitude AS longitude_4, h0_.cityProvider_id AS cityProvider_id_5 FROM HotelProvider h0_ WHERE h0_.cityProvider_id IN (?)

[
  94599
]

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.externalId AS externalId_2,
  h0_.latitude AS latitude_3,
  h0_.longitude AS longitude_4,
  h0_.cityProvider_id AS cityProvider_id_5
FROM
  HotelProvider h0_
WHERE
  h0_.cityProvider_id IN (?)

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.externalId AS externalId_2, h0_.latitude AS latitude_3, h0_.longitude AS longitude_4, h0_.cityProvider_id AS cityProvider_id_5 FROM HotelProvider h0_ WHERE h0_.cityProvider_id IN (94599);