Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.residential_development AS residential_development_2,
  t0.extra_data AS extra_data_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  residential_dev_data t0
WHERE
  t0.residential_development = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = 'perspektiva' LIMIT 1;

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0
FROM
  apartment a0_
WHERE
  a0_.deleted_at IS NULL
  AND a0_.room_count = ?
  AND a0_.residential_development = ?

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM apartment a0_ WHERE a0_.deleted_at IS NULL AND a0_.room_count = 2 AND a0_.residential_development = 'perspektiva';

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.price AS price_1
FROM
  apartment a0_
WHERE
  a0_.deleted_at IS NULL
  AND a0_.room_count = ?
  AND a0_.residential_development = ?
ORDER BY
  a0_.price ASC
LIMIT
  15

SELECT DISTINCT a0_.id AS id_0, a0_.price AS price_1 FROM apartment a0_ WHERE a0_.deleted_at IS NULL AND a0_.room_count = 2 AND a0_.residential_development = 'perspektiva' ORDER BY a0_.price ASC LIMIT 15;

SELECT
  a0_.id AS id_0,
  a0_.residential_development AS residential_development_1,
  a0_.room_count AS room_count_2,
  a0_.price AS price_3,
  a0_.square AS square_4,
  a0_.floor AS floor_5,
  a0_.business AS business_6,
  a0_.tags AS tags_7,
  a0_.side_window AS side_window_8,
  a0_.images AS images_9,
  a0_.created_at AS created_at_10,
  a0_.updated_at AS updated_at_11,
  a0_.extra_data AS extra_data_12,
  a0_.deleted_at AS deleted_at_13
FROM
  apartment a0_
WHERE
  a0_.deleted_at IS NULL
  AND a0_.room_count = ?
  AND a0_.residential_development = ?
  AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  a0_.price ASC

SELECT a0_.id AS id_0, a0_.residential_development AS residential_development_1, a0_.room_count AS room_count_2, a0_.price AS price_3, a0_.square AS square_4, a0_.floor AS floor_5, a0_.business AS business_6, a0_.tags AS tags_7, a0_.side_window AS side_window_8, a0_.images AS images_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.extra_data AS extra_data_12, a0_.deleted_at AS deleted_at_13 FROM apartment a0_ WHERE a0_.deleted_at IS NULL AND a0_.room_count = 2 AND a0_.residential_development = 'perspektiva' AND a0_.id IN (92, 91, 40, 95, 93, 39, 16, 38, 23, 94, 90, 35, 36, 37, 15) ORDER BY a0_.price ASC;

SELECT
  DISTINCT a0_.room_count AS room_count_0
FROM
  apartment a0_
WHERE
  a0_.residential_development = ?
ORDER BY
  room_count_0 ASC

SELECT DISTINCT a0_.room_count AS room_count_0 FROM apartment a0_ WHERE a0_.residential_development = 'perspektiva' ORDER BY room_count_0 ASC;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  apartment a0_
WHERE
  a0_.business = 1
  AND a0_.residential_development = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM apartment a0_ WHERE a0_.business = 1 AND a0_.residential_development = 'perspektiva';

SELECT
  t0.id AS id_1,
  t0.residential_development AS residential_development_2,
  t0.extra_data AS extra_data_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  residential_dev_data t0
WHERE
  t0.residential_development = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = 'perspektiva' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.residential_development AS residential_development_2,
  t0.extra_data AS extra_data_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  residential_dev_data t0
WHERE
  t0.residential_development = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = 'perspektiva' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.residential_development AS residential_development_2,
  t0.extra_data AS extra_data_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  residential_dev_data t0
WHERE
  t0.residential_development = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = 'perspektiva' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.residential_development AS residential_development_2,
  t0.extra_data AS extra_data_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  residential_dev_data t0
WHERE
  t0.residential_development = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = 'perspektiva' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.residential_development AS residential_development_2,
  t0.extra_data AS extra_data_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  residential_dev_data t0
WHERE
  t0.residential_development = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = 'perspektiva' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.residential_development AS residential_development_2,
  t0.extra_data AS extra_data_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  residential_dev_data t0
WHERE
  t0.residential_development = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = 'perspektiva' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.residential_development AS residential_development_2,
  t0.extra_data AS extra_data_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  residential_dev_data t0
WHERE
  t0.residential_development = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = 'perspektiva' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.residential_development AS residential_development_2,
  t0.extra_data AS extra_data_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  residential_dev_data t0
WHERE
  t0.residential_development = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = 'perspektiva' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.residential_development AS residential_development_2,
  t0.extra_data AS extra_data_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  residential_dev_data t0
WHERE
  t0.residential_development = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.residential_development AS residential_development_2, t0.extra_data AS extra_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM residential_dev_data t0 WHERE t0.residential_development = 'perspektiva' LIMIT 1;