Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.login = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.login = '0899843151' LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          u0_.id AS id_0,
          u0_.first_name AS first_name_1,
          u0_.middle_name AS middle_name_2,
          u0_.last_name AS last_name_3,
          u0_.gender AS gender_4,
          u0_.location AS location_5,
          u0_.phone AS phone_6,
          u0_.login AS login_7,
          u0_.password AS password_8,
          u0_.roles AS roles_9,
          u0_.created_at AS created_at_10,
          u0_.status AS status_11
        FROM
          user u0_
          LEFT JOIN city c1_ ON u0_.city_id = c1_.id
          LEFT JOIN province p2_ ON c1_.province_id = p2_.id
          LEFT JOIN fonction_history f3_ ON u0_.id = f3_.user_id
          AND (f3_.status = ?)
          LEFT JOIN fonction f4_ ON f3_.fonction_id = f4_.id
          LEFT JOIN service s5_ ON f4_.service_id = s5_.id
          LEFT JOIN organization o6_ ON s5_.organization_id = o6_.id
        ORDER BY
          u0_.last_name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.middle_name AS middle_name_2, u0_.last_name AS last_name_3, u0_.gender AS gender_4, u0_.location AS location_5, u0_.phone AS phone_6, u0_.login AS login_7, u0_.password AS password_8, u0_.roles AS roles_9, u0_.created_at AS created_at_10, u0_.status AS status_11 FROM user u0_ LEFT JOIN city c1_ ON u0_.city_id = c1_.id LEFT JOIN province p2_ ON c1_.province_id = p2_.id LEFT JOIN fonction_history f3_ ON u0_.id = f3_.user_id AND (f3_.status = 'ACTIVE') LEFT JOIN fonction f4_ ON f3_.fonction_id = f4_.id LEFT JOIN service s5_ ON f4_.service_id = s5_.id LEFT JOIN organization o6_ ON s5_.organization_id = o6_.id ORDER BY u0_.last_name ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      last_name_3
    FROM
      (
        SELECT
          u0_.id AS id_0,
          u0_.first_name AS first_name_1,
          u0_.middle_name AS middle_name_2,
          u0_.last_name AS last_name_3,
          u0_.gender AS gender_4,
          u0_.location AS location_5,
          u0_.phone AS phone_6,
          u0_.login AS login_7,
          u0_.password AS password_8,
          u0_.roles AS roles_9,
          u0_.created_at AS created_at_10,
          u0_.status AS status_11,
          f1_.id AS id_12,
          f1_.debut_at AS debut_at_13,
          f1_.end_at AS end_at_14,
          f1_.status AS status_15,
          f1_.created_at AS created_at_16
        FROM
          user u0_
          LEFT JOIN city c2_ ON u0_.city_id = c2_.id
          LEFT JOIN province p3_ ON c2_.province_id = p3_.id
          LEFT JOIN fonction_history f1_ ON u0_.id = f1_.user_id
          AND (f1_.status = ?)
          LEFT JOIN fonction f4_ ON f1_.fonction_id = f4_.id
          LEFT JOIN service s5_ ON f4_.service_id = s5_.id
          LEFT JOIN organization o6_ ON s5_.organization_id = o6_.id
      ) dctrn_result_inner
    ORDER BY
      last_name_3 ASC
  ) dctrn_result
LIMIT
  25

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, last_name_3 FROM (SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.middle_name AS middle_name_2, u0_.last_name AS last_name_3, u0_.gender AS gender_4, u0_.location AS location_5, u0_.phone AS phone_6, u0_.login AS login_7, u0_.password AS password_8, u0_.roles AS roles_9, u0_.created_at AS created_at_10, u0_.status AS status_11, f1_.id AS id_12, f1_.debut_at AS debut_at_13, f1_.end_at AS end_at_14, f1_.status AS status_15, f1_.created_at AS created_at_16 FROM user u0_ LEFT JOIN city c2_ ON u0_.city_id = c2_.id LEFT JOIN province p3_ ON c2_.province_id = p3_.id LEFT JOIN fonction_history f1_ ON u0_.id = f1_.user_id AND (f1_.status = 'ACTIVE') LEFT JOIN fonction f4_ ON f1_.fonction_id = f4_.id LEFT JOIN service s5_ ON f4_.service_id = s5_.id LEFT JOIN organization o6_ ON s5_.organization_id = o6_.id) dctrn_result_inner ORDER BY last_name_3 ASC) dctrn_result LIMIT 25;

SELECT
  u0_.id AS id_0,
  u0_.first_name AS first_name_1,
  u0_.middle_name AS middle_name_2,
  u0_.last_name AS last_name_3,
  u0_.gender AS gender_4,
  u0_.location AS location_5,
  u0_.phone AS phone_6,
  u0_.login AS login_7,
  u0_.password AS password_8,
  u0_.roles AS roles_9,
  u0_.created_at AS created_at_10,
  u0_.status AS status_11,
  u0_.city_id AS city_id_12,
  u0_.parking_id AS parking_id_13
FROM
  user u0_
  LEFT JOIN city c1_ ON u0_.city_id = c1_.id
  LEFT JOIN province p2_ ON c1_.province_id = p2_.id
  LEFT JOIN fonction_history f3_ ON u0_.id = f3_.user_id
  AND (f3_.status = ?)
  LEFT JOIN fonction f4_ ON f3_.fonction_id = f4_.id
  LEFT JOIN service s5_ ON f4_.service_id = s5_.id
  LEFT JOIN organization o6_ ON s5_.organization_id = o6_.id
WHERE
  u0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  u0_.last_name ASC

SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.middle_name AS middle_name_2, u0_.last_name AS last_name_3, u0_.gender AS gender_4, u0_.location AS location_5, u0_.phone AS phone_6, u0_.login AS login_7, u0_.password AS password_8, u0_.roles AS roles_9, u0_.created_at AS created_at_10, u0_.status AS status_11, u0_.city_id AS city_id_12, u0_.parking_id AS parking_id_13 FROM user u0_ LEFT JOIN city c1_ ON u0_.city_id = c1_.id LEFT JOIN province p2_ ON c1_.province_id = p2_.id LEFT JOIN fonction_history f3_ ON u0_.id = f3_.user_id AND (f3_.status = 'ACTIVE') LEFT JOIN fonction f4_ ON f3_.fonction_id = f4_.id LEFT JOIN service s5_ ON f4_.service_id = s5_.id LEFT JOIN organization o6_ ON s5_.organization_id = o6_.id WHERE u0_.id IN (19, 23, 14, 16, 10, 20, 22, 11, 9, 25, 17, 1, 12, 21, 18, 24, 13, 26, 27, 15) ORDER BY u0_.last_name ASC;

SELECT
  t0.id AS id_1,
  t0.debut_at AS debut_at_2,
  t0.end_at AS end_at_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.fonction_id AS fonction_id_6,
  t0.user_id AS user_id_7
FROM
  fonction_history t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = 19;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.created_at AS created_at_4,
  t0.province_id AS province_id_5
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.province_id AS province_id_5 FROM city t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.created_at AS created_at_4
FROM
  province t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.created_at AS created_at_4 FROM province t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.debut_at AS debut_at_2,
  t0.end_at AS end_at_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.fonction_id AS fonction_id_6,
  t0.user_id AS user_id_7
FROM
  fonction_history t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = 23;

SELECT
  t0.id AS id_1,
  t0.debut_at AS debut_at_2,
  t0.end_at AS end_at_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.fonction_id AS fonction_id_6,
  t0.user_id AS user_id_7
FROM
  fonction_history t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = 14;

SELECT
  t0.id AS id_1,
  t0.debut_at AS debut_at_2,
  t0.end_at AS end_at_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.fonction_id AS fonction_id_6,
  t0.user_id AS user_id_7
FROM
  fonction_history t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = 16;

SELECT
  t0.id AS id_1,
  t0.debut_at AS debut_at_2,
  t0.end_at AS end_at_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.fonction_id AS fonction_id_6,
  t0.user_id AS user_id_7
FROM
  fonction_history t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = 10;

SELECT
  t0.id AS id_1,
  t0.debut_at AS debut_at_2,
  t0.end_at AS end_at_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.fonction_id AS fonction_id_6,
  t0.user_id AS user_id_7
FROM
  fonction_history t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = 20;

SELECT
  t0.id AS id_1,
  t0.debut_at AS debut_at_2,
  t0.end_at AS end_at_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.fonction_id AS fonction_id_6,
  t0.user_id AS user_id_7
FROM
  fonction_history t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = 22;

SELECT
  t0.id AS id_1,
  t0.debut_at AS debut_at_2,
  t0.end_at AS end_at_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.fonction_id AS fonction_id_6,
  t0.user_id AS user_id_7
FROM
  fonction_history t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = 9;

SELECT
  t0.id AS id_1,
  t0.debut_at AS debut_at_2,
  t0.end_at AS end_at_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.fonction_id AS fonction_id_6,
  t0.user_id AS user_id_7
FROM
  fonction_history t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = 11;

SELECT
  t0.id AS id_1,
  t0.debut_at AS debut_at_2,
  t0.end_at AS end_at_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.fonction_id AS fonction_id_6,
  t0.user_id AS user_id_7
FROM
  fonction_history t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = 25;

SELECT
  t0.id AS id_1,
  t0.debut_at AS debut_at_2,
  t0.end_at AS end_at_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.fonction_id AS fonction_id_6,
  t0.user_id AS user_id_7
FROM
  fonction_history t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = 17;

SELECT
  t0.id AS id_1,
  t0.debut_at AS debut_at_2,
  t0.end_at AS end_at_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.fonction_id AS fonction_id_6,
  t0.user_id AS user_id_7
FROM
  fonction_history t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = 1;

SELECT
  t0.id AS id_1,
  t0.debut_at AS debut_at_2,
  t0.end_at AS end_at_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.fonction_id AS fonction_id_6,
  t0.user_id AS user_id_7
FROM
  fonction_history t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = 12;

SELECT
  t0.id AS id_1,
  t0.debut_at AS debut_at_2,
  t0.end_at AS end_at_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.fonction_id AS fonction_id_6,
  t0.user_id AS user_id_7
FROM
  fonction_history t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = 21;

SELECT
  t0.id AS id_1,
  t0.debut_at AS debut_at_2,
  t0.end_at AS end_at_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.fonction_id AS fonction_id_6,
  t0.user_id AS user_id_7
FROM
  fonction_history t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = 18;

SELECT
  t0.id AS id_1,
  t0.debut_at AS debut_at_2,
  t0.end_at AS end_at_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.fonction_id AS fonction_id_6,
  t0.user_id AS user_id_7
FROM
  fonction_history t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = 24;

SELECT
  t0.id AS id_1,
  t0.debut_at AS debut_at_2,
  t0.end_at AS end_at_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.fonction_id AS fonction_id_6,
  t0.user_id AS user_id_7
FROM
  fonction_history t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = 13;