Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.language AS language_5,
  t0.is_verified AS is_verified_6,
  t0.last_name AS last_name_7,
  t0.first_name AS first_name_8,
  t0.profession AS profession_9,
  t0.entity AS entity_10,
  t0.address AS address_11,
  t0.npa AS npa_12,
  t0.city AS city_13,
  t0.discriminator
FROM
  user t0
WHERE
  t0.id = ?
  AND t0.discriminator IN ('client')

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.language AS language_5, t0.is_verified AS is_verified_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.profession AS profession_9, t0.entity AS entity_10, t0.address AS address_11, t0.npa AS npa_12, t0.city AS city_13, t0.discriminator FROM user t0 WHERE t0.id = 1 AND t0.discriminator IN ('client');

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.creation_date AS creation_date_2
FROM
  project p0_
  INNER JOIN user u1_ ON (
    EXISTS (
      SELECT
        1
      FROM
        project_in_client p2_
      WHERE
        p2_.client_id = u1_.id
        AND p2_.project_id IN (p0_.id)
    )
  )
  AND u1_.discriminator IN ('client')
WHERE
  u1_.id = ?
ORDER BY
  p0_.creation_date ASC
LIMIT
  15

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.creation_date AS creation_date_2 FROM project p0_ INNER JOIN user u1_ ON (EXISTS (SELECT 1 FROM project_in_client p2_ WHERE p2_.client_id = u1_.id AND p2_.project_id IN (p0_.id))) AND u1_.discriminator IN ('client') WHERE u1_.id = 1 ORDER BY p0_.creation_date ASC LIMIT 15;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.description AS description_2
FROM
  project p1_
  INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id
  INNER JOIN building b0_ ON b0_.id = b2_.building_id
WHERE
  p1_.id = ?
ORDER BY
  b0_.id ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2 FROM project p1_ INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id INNER JOIN building b0_ ON b0_.id = b2_.building_id WHERE p1_.id = 102 ORDER BY b0_.id ASC LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.description AS description_2
FROM
  project p1_
  INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id
  INNER JOIN building b0_ ON b0_.id = b2_.building_id
WHERE
  p1_.id = ?
ORDER BY
  b0_.id ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2 FROM project p1_ INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id INNER JOIN building b0_ ON b0_.id = b2_.building_id WHERE p1_.id = 16 ORDER BY b0_.id ASC LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.description AS description_2
FROM
  project p1_
  INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id
  INNER JOIN building b0_ ON b0_.id = b2_.building_id
WHERE
  p1_.id = ?
ORDER BY
  b0_.id ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2 FROM project p1_ INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id INNER JOIN building b0_ ON b0_.id = b2_.building_id WHERE p1_.id = 104 ORDER BY b0_.id ASC LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.description AS description_2
FROM
  project p1_
  INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id
  INNER JOIN building b0_ ON b0_.id = b2_.building_id
WHERE
  p1_.id = ?
ORDER BY
  b0_.id ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2 FROM project p1_ INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id INNER JOIN building b0_ ON b0_.id = b2_.building_id WHERE p1_.id = 17 ORDER BY b0_.id ASC LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.description AS description_2
FROM
  project p1_
  INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id
  INNER JOIN building b0_ ON b0_.id = b2_.building_id
WHERE
  p1_.id = ?
ORDER BY
  b0_.id ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2 FROM project p1_ INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id INNER JOIN building b0_ ON b0_.id = b2_.building_id WHERE p1_.id = 28 ORDER BY b0_.id ASC LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.description AS description_2
FROM
  project p1_
  INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id
  INNER JOIN building b0_ ON b0_.id = b2_.building_id
WHERE
  p1_.id = ?
ORDER BY
  b0_.id ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2 FROM project p1_ INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id INNER JOIN building b0_ ON b0_.id = b2_.building_id WHERE p1_.id = 65 ORDER BY b0_.id ASC LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.description AS description_2
FROM
  project p1_
  INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id
  INNER JOIN building b0_ ON b0_.id = b2_.building_id
WHERE
  p1_.id = ?
ORDER BY
  b0_.id ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2 FROM project p1_ INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id INNER JOIN building b0_ ON b0_.id = b2_.building_id WHERE p1_.id = 18 ORDER BY b0_.id ASC LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.description AS description_2
FROM
  project p1_
  INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id
  INNER JOIN building b0_ ON b0_.id = b2_.building_id
WHERE
  p1_.id = ?
ORDER BY
  b0_.id ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2 FROM project p1_ INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id INNER JOIN building b0_ ON b0_.id = b2_.building_id WHERE p1_.id = 19 ORDER BY b0_.id ASC LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.description AS description_2
FROM
  project p1_
  INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id
  INNER JOIN building b0_ ON b0_.id = b2_.building_id
WHERE
  p1_.id = ?
ORDER BY
  b0_.id ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2 FROM project p1_ INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id INNER JOIN building b0_ ON b0_.id = b2_.building_id WHERE p1_.id = 29 ORDER BY b0_.id ASC LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.description AS description_2
FROM
  project p1_
  INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id
  INNER JOIN building b0_ ON b0_.id = b2_.building_id
WHERE
  p1_.id = ?
ORDER BY
  b0_.id ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2 FROM project p1_ INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id INNER JOIN building b0_ ON b0_.id = b2_.building_id WHERE p1_.id = 40 ORDER BY b0_.id ASC LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.description AS description_2
FROM
  project p1_
  INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id
  INNER JOIN building b0_ ON b0_.id = b2_.building_id
WHERE
  p1_.id = ?
ORDER BY
  b0_.id ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2 FROM project p1_ INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id INNER JOIN building b0_ ON b0_.id = b2_.building_id WHERE p1_.id = 46 ORDER BY b0_.id ASC LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.description AS description_2
FROM
  project p1_
  INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id
  INNER JOIN building b0_ ON b0_.id = b2_.building_id
WHERE
  p1_.id = ?
ORDER BY
  b0_.id ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2 FROM project p1_ INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id INNER JOIN building b0_ ON b0_.id = b2_.building_id WHERE p1_.id = 99 ORDER BY b0_.id ASC LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.description AS description_2
FROM
  project p1_
  INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id
  INNER JOIN building b0_ ON b0_.id = b2_.building_id
WHERE
  p1_.id = ?
ORDER BY
  b0_.id ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2 FROM project p1_ INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id INNER JOIN building b0_ ON b0_.id = b2_.building_id WHERE p1_.id = 1 ORDER BY b0_.id ASC LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.description AS description_2
FROM
  project p1_
  INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id
  INNER JOIN building b0_ ON b0_.id = b2_.building_id
WHERE
  p1_.id = ?
ORDER BY
  b0_.id ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2 FROM project p1_ INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id INNER JOIN building b0_ ON b0_.id = b2_.building_id WHERE p1_.id = 2 ORDER BY b0_.id ASC LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.description AS description_2
FROM
  project p1_
  INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id
  INNER JOIN building b0_ ON b0_.id = b2_.building_id
WHERE
  p1_.id = ?
ORDER BY
  b0_.id ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2 FROM project p1_ INNER JOIN building_in_project_variants b2_ ON p1_.id = b2_.project_id INNER JOIN building b0_ ON b0_.id = b2_.building_id WHERE p1_.id = 3 ORDER BY b0_.id ASC LIMIT 1;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  project p0_
  INNER JOIN user u1_ ON (
    EXISTS (
      SELECT
        1
      FROM
        project_in_client p2_
      WHERE
        p2_.client_id = u1_.id
        AND p2_.project_id IN (p0_.id)
    )
  )
  AND u1_.discriminator IN ('client')
WHERE
  u1_.id = ?

SELECT COUNT(p0_.id) AS sclr_0 FROM project p0_ INNER JOIN user u1_ ON (EXISTS (SELECT 1 FROM project_in_client p2_ WHERE p2_.client_id = u1_.id AND p2_.project_id IN (p0_.id))) AND u1_.discriminator IN ('client') WHERE u1_.id = 1;