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 = '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

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

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.currency AS currency_4,
  t0.phoneCode AS phoneCode_5,
  t0.codeAlpha2 AS codeAlpha2_6
FROM
  Country t0
  INNER JOIN client_country ON t0.id = client_country.country_id
WHERE
  client_country.client_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.currency AS currency_4, t0.phoneCode AS phoneCode_5, t0.codeAlpha2 AS codeAlpha2_6 FROM Country t0 INNER JOIN client_country ON t0.id = client_country.country_id WHERE client_country.client_id = 4;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.active AS active_2,
  c0_.description AS description_3,
  c0_.latitude AS latitude_4,
  c0_.longitude AS longitude_5,
  c0_.country_id AS country_id_6,
  c0_.image_id AS image_id_7
FROM
  City c0_
  INNER JOIN Country c1_ ON c0_.country_id = c1_.id
WHERE
  c0_.name LIKE ?
  AND c1_.codeAlpha2 IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
  AND c0_.active = ?
ORDER BY
  c0_.country_id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.description AS description_3, c0_.latitude AS latitude_4, c0_.longitude AS longitude_5, c0_.country_id AS country_id_6, c0_.image_id AS image_id_7 FROM City c0_ INNER JOIN Country c1_ ON c0_.country_id = c1_.id WHERE c0_.name LIKE '%barce%' AND c1_.codeAlpha2 IN ('AF', 'AL', 'DZ', 'AS', 'AD', 'AO', 'AI', 'AQ', 'AG', 'AR', 'AM', 'AW', 'AU', 'AT', 'AZ', 'BS', 'BH', 'BD', 'BB', 'BY', 'BE', 'BZ', 'BJ', 'BM', 'BT', 'BO', 'BA', 'BW', 'BV', 'BR', 'IO', 'BN', 'BG', 'BF', 'BI', 'CV', 'KH', 'CM', 'CA', 'KY', 'CF', 'TD', 'CL', 'CN', 'CX', 'CC', 'CO', 'KM', 'CG', 'CD', 'CK', 'CR', 'CI', 'HR', 'CU', 'CW', 'CY', 'CZ', 'DK', 'DJ', 'DM', 'DO', 'EC', 'EG', 'SV', 'GQ', 'ER', 'EE', 'SZ', 'ET', 'FK', 'FO', 'FJ', 'FI', 'FR', 'GA', 'GM', 'GE', 'DE', 'GH', 'GI', 'GR', 'GL', 'GD', 'GP', 'GU', 'GT', 'GG', 'GN', 'GW', 'GY', 'HT', 'HM', 'HN', 'HK', 'HU', 'IS', 'IN', 'ID', 'IR', 'IQ', 'IE', 'IM', 'IT', 'JM', 'JP', 'JE', 'JO', 'KZ', 'KE', 'KI', 'KP', 'KR', 'XK', 'KW', 'KG', 'LA', 'LV', 'LB', 'LS', 'LR', 'LY', 'LI', 'LT', 'LU', 'MO', 'MG', 'MW', 'MY', 'MV', 'ML', 'MT', 'MH', 'MQ', 'MR', 'MU', 'YT', 'MX', 'FM', 'MD', 'MC', 'MN', 'ME', 'MS', 'MA', 'MZ', 'MM', 'NA', 'NR', 'NP', 'NL', 'NC', 'NZ', 'NI', 'NE', 'NG', 'NU', 'NF', 'MK', 'MP', 'NO', 'OM', 'PK', 'PW', 'PS', 'PA', 'PG', 'PY', 'PE', 'PH', 'PN', 'PL', 'PT', 'PR', 'QA', 'RE', 'RO', 'RU', 'RW', 'BL', 'SH', 'KN', 'LC', 'MF', 'PM', 'VC', 'WS', 'SM', 'ST', 'SA', 'SN', 'RS', 'SC', 'SL', 'SG', 'SX', 'SK', 'SI', 'SB', 'SO', 'ZA', 'GS', 'SS', 'ES', 'LK', 'SD', 'SR', 'SJ', 'SE', 'CH', 'SY', 'TW', 'TJ', 'TZ', 'TH', 'TL', 'TG', 'TK', 'TO', 'TT', 'TN', 'TR', 'TM', 'TV', 'UG', 'UA', 'AE', 'GB', 'US', 'UY', 'UZ', 'VU', 'VA', 'VE', 'VN', 'WF', 'EH', 'YE', 'ZM', 'ZW', 'VG', 'GF', 'PF', 'TC', 'BQ', 'VI') AND c0_.active = 1 ORDER BY c0_.country_id ASC;