Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.password AS password_2,
  u0_.api_token AS api_token_3,
  u0_.email AS email_4,
  u0_.active AS active_5,
  u0_.last_login_at AS last_login_at_6,
  u0_.firstname AS firstname_7,
  u0_.lastname AS lastname_8,
  u0_.phone AS phone_9,
  u0_.created_at AS created_at_10,
  u0_.updated_at AS updated_at_11,
  u0_.deleted_at AS deleted_at_12
FROM
  user u0_
WHERE
  u0_.password IS NOT NULL
  AND (
    u0_.username = ?
    OR u0_.email = ?
  )
LIMIT
  1

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.api_token AS api_token_3, u0_.email AS email_4, u0_.active AS active_5, u0_.last_login_at AS last_login_at_6, u0_.firstname AS firstname_7, u0_.lastname AS lastname_8, u0_.phone AS phone_9, u0_.created_at AS created_at_10, u0_.updated_at AS updated_at_11, u0_.deleted_at AS deleted_at_12 FROM user u0_ WHERE u0_.password IS NOT NULL AND (u0_.username = 'roland.dufour@pilipili-web.com' OR u0_.email = 'roland.dufour@pilipili-web.com') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.user_id AS user_id_5,
  t0.employee_profile_id AS employee_profile_id_6
FROM
  employee t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.user_id AS user_id_5, t0.employee_profile_id AS employee_profile_id_6 FROM employee t0 WHERE t0.user_id = 1;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.address AS address_4,
  t0.address2 AS address2_5,
  t0.postcode AS postcode_6,
  t0.city AS city_7,
  t0.country AS country_8,
  t0.register AS register_9,
  t0.vat_intra AS vat_intra_10,
  t0.commercial_name AS commercial_name_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.user_id AS user_id_15
FROM
  client t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.country AS country_8, t0.register AS register_9, t0.vat_intra AS vat_intra_10, t0.commercial_name AS commercial_name_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.user_id AS user_id_15 FROM client t0 WHERE t0.user_id = 1;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.user_id AS user_id_7
FROM
  affiliate t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM affiliate t0 WHERE t0.user_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.acls AS acls_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  employee_profile t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.acls AS acls_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM employee_profile t0 WHERE t0.id = 1;

SELECT
  count(DISTINCT e0_.id) AS sclr_0
FROM
  employee e0_
  INNER JOIN user u1_ ON e0_.user_id = u1_.id
WHERE
  e0_.deleted_at IS NULL
  AND u1_.deleted_at IS NULL

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM employee e0_ INNER JOIN user u1_ ON e0_.user_id = u1_.id WHERE e0_.deleted_at IS NULL AND u1_.deleted_at IS NULL;

SELECT
  DISTINCT e0_.id AS id_0,
  u1_.firstname AS firstname_1,
  u1_.lastname AS lastname_2
FROM
  employee e0_
  INNER JOIN user u1_ ON e0_.user_id = u1_.id
WHERE
  e0_.deleted_at IS NULL
  AND u1_.deleted_at IS NULL
ORDER BY
  u1_.firstname ASC,
  u1_.lastname ASC
LIMIT
  20

SELECT DISTINCT e0_.id AS id_0, u1_.firstname AS firstname_1, u1_.lastname AS lastname_2 FROM employee e0_ INNER JOIN user u1_ ON e0_.user_id = u1_.id WHERE e0_.deleted_at IS NULL AND u1_.deleted_at IS NULL ORDER BY u1_.firstname ASC, u1_.lastname ASC LIMIT 20;

SELECT
  e0_.id AS id_0,
  e0_.created_at AS created_at_1,
  e0_.updated_at AS updated_at_2,
  e0_.deleted_at AS deleted_at_3,
  u1_.id AS id_4,
  u1_.username AS username_5,
  u1_.password AS password_6,
  u1_.api_token AS api_token_7,
  u1_.email AS email_8,
  u1_.active AS active_9,
  u1_.last_login_at AS last_login_at_10,
  u1_.firstname AS firstname_11,
  u1_.lastname AS lastname_12,
  u1_.phone AS phone_13,
  u1_.created_at AS created_at_14,
  u1_.updated_at AS updated_at_15,
  u1_.deleted_at AS deleted_at_16,
  e0_.user_id AS user_id_17,
  e0_.employee_profile_id AS employee_profile_id_18
FROM
  employee e0_
  INNER JOIN user u1_ ON e0_.user_id = u1_.id
WHERE
  e0_.deleted_at IS NULL
  AND u1_.deleted_at IS NULL
  AND e0_.id IN (?, ?)
ORDER BY
  u1_.firstname ASC,
  u1_.lastname ASC

SELECT e0_.id AS id_0, e0_.created_at AS created_at_1, e0_.updated_at AS updated_at_2, e0_.deleted_at AS deleted_at_3, u1_.id AS id_4, u1_.username AS username_5, u1_.password AS password_6, u1_.api_token AS api_token_7, u1_.email AS email_8, u1_.active AS active_9, u1_.last_login_at AS last_login_at_10, u1_.firstname AS firstname_11, u1_.lastname AS lastname_12, u1_.phone AS phone_13, u1_.created_at AS created_at_14, u1_.updated_at AS updated_at_15, u1_.deleted_at AS deleted_at_16, e0_.user_id AS user_id_17, e0_.employee_profile_id AS employee_profile_id_18 FROM employee e0_ INNER JOIN user u1_ ON e0_.user_id = u1_.id WHERE e0_.deleted_at IS NULL AND u1_.deleted_at IS NULL AND e0_.id IN (2, 1) ORDER BY u1_.firstname ASC, u1_.lastname ASC;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.address AS address_4,
  t0.address2 AS address2_5,
  t0.postcode AS postcode_6,
  t0.city AS city_7,
  t0.country AS country_8,
  t0.register AS register_9,
  t0.vat_intra AS vat_intra_10,
  t0.commercial_name AS commercial_name_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.user_id AS user_id_15
FROM
  client t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.country AS country_8, t0.register AS register_9, t0.vat_intra AS vat_intra_10, t0.commercial_name AS commercial_name_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.user_id AS user_id_15 FROM client t0 WHERE t0.user_id = 2;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.user_id AS user_id_7
FROM
  affiliate t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM affiliate t0 WHERE t0.user_id = 2;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.created_at AS created_at_2,
  p0_.updated_at AS updated_at_3,
  p0_.deleted_at AS deleted_at_4
FROM
  product p0_
WHERE
  p0_.deleted_at IS NULL
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.deleted_at AS deleted_at_4 FROM product p0_ WHERE p0_.deleted_at IS NULL ORDER BY p0_.name ASC;