Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.describ AS describ_3
FROM
  category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.describ AS describ_3 FROM category t0;

SELECT
  p0_.id AS id_0,
  p0_.room_number AS room_number_1,
  p0_.rent AS rent_2,
  p0_.price AS price_3,
  p0_.garden AS garden_4,
  p0_.title AS title_5,
  p0_.content AS content_6,
  p0_.created_at AS created_at_7,
  p0_.harea AS harea_8,
  p0_.year_built AS year_built_9,
  p0_.heating AS heating_10,
  p0_.favorit_number AS favorit_number_11,
  p0_.is_available AS is_available_12,
  p0_.housing_type_id AS housing_type_id_13,
  p0_.user_id AS user_id_14,
  p0_.address_id AS address_id_15,
  p0_.category_id AS category_id_16,
  p0_.sub_type_id AS sub_type_id_17
FROM
  properties p0_
WHERE
  p0_.category_id = ?
ORDER BY
  p0_.created_at DESC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.room_number AS room_number_1, p0_.rent AS rent_2, p0_.price AS price_3, p0_.garden AS garden_4, p0_.title AS title_5, p0_.content AS content_6, p0_.created_at AS created_at_7, p0_.harea AS harea_8, p0_.year_built AS year_built_9, p0_.heating AS heating_10, p0_.favorit_number AS favorit_number_11, p0_.is_available AS is_available_12, p0_.housing_type_id AS housing_type_id_13, p0_.user_id AS user_id_14, p0_.address_id AS address_id_15, p0_.category_id AS category_id_16, p0_.sub_type_id AS sub_type_id_17 FROM properties p0_ WHERE p0_.category_id = 2 ORDER BY p0_.created_at DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.date_start AS date_start_2,
  t0.date_end AS date_end_3,
  t0.tenant_id AS tenant_id_4,
  t0.property_id AS property_id_5,
  t6.id AS id_7,
  t6.payment_date AS payment_date_8,
  t6.paid AS paid_9,
  t6.amount_paid AS amount_paid_10,
  t6.amount_remaining AS amount_remaining_11,
  t6.comment AS comment_12,
  t6.payment_method AS payment_method_13,
  t6.rental_id AS rental_id_14
FROM
  rental t0
  LEFT JOIN rent t6 ON t6.rental_id = t0.id
WHERE
  t0.property_id = ?

SELECT t0.id AS id_1, t0.date_start AS date_start_2, t0.date_end AS date_end_3, t0.tenant_id AS tenant_id_4, t0.property_id AS property_id_5, t6.id AS id_7, t6.payment_date AS payment_date_8, t6.paid AS paid_9, t6.amount_paid AS amount_paid_10, t6.amount_remaining AS amount_remaining_11, t6.comment AS comment_12, t6.payment_method AS payment_method_13, t6.rental_id AS rental_id_14 FROM rental t0 LEFT JOIN rent t6 ON t6.rental_id = t0.id WHERE t0.property_id = 8;

SELECT
  t0.id AS id_1,
  t0.date_start AS date_start_2,
  t0.date_end AS date_end_3,
  t0.tenant_id AS tenant_id_4,
  t0.property_id AS property_id_5,
  t6.id AS id_7,
  t6.payment_date AS payment_date_8,
  t6.paid AS paid_9,
  t6.amount_paid AS amount_paid_10,
  t6.amount_remaining AS amount_remaining_11,
  t6.comment AS comment_12,
  t6.payment_method AS payment_method_13,
  t6.rental_id AS rental_id_14
FROM
  rental t0
  LEFT JOIN rent t6 ON t6.rental_id = t0.id
WHERE
  t0.property_id = ?

SELECT t0.id AS id_1, t0.date_start AS date_start_2, t0.date_end AS date_end_3, t0.tenant_id AS tenant_id_4, t0.property_id AS property_id_5, t6.id AS id_7, t6.payment_date AS payment_date_8, t6.paid AS paid_9, t6.amount_paid AS amount_paid_10, t6.amount_remaining AS amount_remaining_11, t6.comment AS comment_12, t6.payment_method AS payment_method_13, t6.rental_id AS rental_id_14 FROM rental t0 LEFT JOIN rent t6 ON t6.rental_id = t0.id WHERE t0.property_id = 5;

SELECT
  p0_.id AS id_0,
  p0_.room_number AS room_number_1,
  p0_.rent AS rent_2,
  p0_.price AS price_3,
  p0_.garden AS garden_4,
  p0_.title AS title_5,
  p0_.content AS content_6,
  p0_.created_at AS created_at_7,
  p0_.harea AS harea_8,
  p0_.year_built AS year_built_9,
  p0_.heating AS heating_10,
  p0_.favorit_number AS favorit_number_11,
  p0_.is_available AS is_available_12,
  p0_.housing_type_id AS housing_type_id_13,
  p0_.user_id AS user_id_14,
  p0_.address_id AS address_id_15,
  p0_.category_id AS category_id_16,
  p0_.sub_type_id AS sub_type_id_17
FROM
  properties p0_
WHERE
  p0_.category_id = ?
ORDER BY
  p0_.created_at DESC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.room_number AS room_number_1, p0_.rent AS rent_2, p0_.price AS price_3, p0_.garden AS garden_4, p0_.title AS title_5, p0_.content AS content_6, p0_.created_at AS created_at_7, p0_.harea AS harea_8, p0_.year_built AS year_built_9, p0_.heating AS heating_10, p0_.favorit_number AS favorit_number_11, p0_.is_available AS is_available_12, p0_.housing_type_id AS housing_type_id_13, p0_.user_id AS user_id_14, p0_.address_id AS address_id_15, p0_.category_id AS category_id_16, p0_.sub_type_id AS sub_type_id_17 FROM properties p0_ WHERE p0_.category_id = 3 ORDER BY p0_.created_at DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.date_start AS date_start_2,
  t0.date_end AS date_end_3,
  t0.tenant_id AS tenant_id_4,
  t0.property_id AS property_id_5,
  t6.id AS id_7,
  t6.payment_date AS payment_date_8,
  t6.paid AS paid_9,
  t6.amount_paid AS amount_paid_10,
  t6.amount_remaining AS amount_remaining_11,
  t6.comment AS comment_12,
  t6.payment_method AS payment_method_13,
  t6.rental_id AS rental_id_14
FROM
  rental t0
  LEFT JOIN rent t6 ON t6.rental_id = t0.id
WHERE
  t0.property_id = ?

SELECT t0.id AS id_1, t0.date_start AS date_start_2, t0.date_end AS date_end_3, t0.tenant_id AS tenant_id_4, t0.property_id AS property_id_5, t6.id AS id_7, t6.payment_date AS payment_date_8, t6.paid AS paid_9, t6.amount_paid AS amount_paid_10, t6.amount_remaining AS amount_remaining_11, t6.comment AS comment_12, t6.payment_method AS payment_method_13, t6.rental_id AS rental_id_14 FROM rental t0 LEFT JOIN rent t6 ON t6.rental_id = t0.id WHERE t0.property_id = 10;

SELECT
  t0.id AS id_1,
  t0.date_start AS date_start_2,
  t0.date_end AS date_end_3,
  t0.tenant_id AS tenant_id_4,
  t0.property_id AS property_id_5,
  t6.id AS id_7,
  t6.payment_date AS payment_date_8,
  t6.paid AS paid_9,
  t6.amount_paid AS amount_paid_10,
  t6.amount_remaining AS amount_remaining_11,
  t6.comment AS comment_12,
  t6.payment_method AS payment_method_13,
  t6.rental_id AS rental_id_14
FROM
  rental t0
  LEFT JOIN rent t6 ON t6.rental_id = t0.id
WHERE
  t0.property_id = ?

SELECT t0.id AS id_1, t0.date_start AS date_start_2, t0.date_end AS date_end_3, t0.tenant_id AS tenant_id_4, t0.property_id AS property_id_5, t6.id AS id_7, t6.payment_date AS payment_date_8, t6.paid AS paid_9, t6.amount_paid AS amount_paid_10, t6.amount_remaining AS amount_remaining_11, t6.comment AS comment_12, t6.payment_method AS payment_method_13, t6.rental_id AS rental_id_14 FROM rental t0 LEFT JOIN rent t6 ON t6.rental_id = t0.id WHERE t0.property_id = 9;

SELECT
  t0.id AS id_1,
  t0.date_start AS date_start_2,
  t0.date_end AS date_end_3,
  t0.tenant_id AS tenant_id_4,
  t0.property_id AS property_id_5,
  t6.id AS id_7,
  t6.payment_date AS payment_date_8,
  t6.paid AS paid_9,
  t6.amount_paid AS amount_paid_10,
  t6.amount_remaining AS amount_remaining_11,
  t6.comment AS comment_12,
  t6.payment_method AS payment_method_13,
  t6.rental_id AS rental_id_14
FROM
  rental t0
  LEFT JOIN rent t6 ON t6.rental_id = t0.id
WHERE
  t0.property_id = ?

SELECT t0.id AS id_1, t0.date_start AS date_start_2, t0.date_end AS date_end_3, t0.tenant_id AS tenant_id_4, t0.property_id AS property_id_5, t6.id AS id_7, t6.payment_date AS payment_date_8, t6.paid AS paid_9, t6.amount_paid AS amount_paid_10, t6.amount_remaining AS amount_remaining_11, t6.comment AS comment_12, t6.payment_method AS payment_method_13, t6.rental_id AS rental_id_14 FROM rental t0 LEFT JOIN rent t6 ON t6.rental_id = t0.id WHERE t0.property_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.describ AS describ_3
FROM
  category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.describ AS describ_3 FROM category t0;

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.describ AS describ_2
FROM
  housing_type h0_

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.describ AS describ_2 FROM housing_type h0_;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.describ AS describ_2
FROM
  category c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.describ AS describ_2 FROM category c0_;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.updated_at AS updated_at_4,
  t0.properties_id AS properties_id_5
FROM
  image t0
WHERE
  t0.properties_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated_at AS updated_at_4, t0.properties_id AS properties_id_5 FROM image t0 WHERE t0.properties_id = 8;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.updated_at AS updated_at_4,
  t0.properties_id AS properties_id_5
FROM
  image t0
WHERE
  t0.properties_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated_at AS updated_at_4, t0.properties_id AS properties_id_5 FROM image t0 WHERE t0.properties_id = 5;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.updated_at AS updated_at_4,
  t0.properties_id AS properties_id_5
FROM
  image t0
WHERE
  t0.properties_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated_at AS updated_at_4, t0.properties_id AS properties_id_5 FROM image t0 WHERE t0.properties_id = 10;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.updated_at AS updated_at_4,
  t0.properties_id AS properties_id_5
FROM
  image t0
WHERE
  t0.properties_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated_at AS updated_at_4, t0.properties_id AS properties_id_5 FROM image t0 WHERE t0.properties_id = 9;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.updated_at AS updated_at_4,
  t0.properties_id AS properties_id_5
FROM
  image t0
WHERE
  t0.properties_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated_at AS updated_at_4, t0.properties_id AS properties_id_5 FROM image t0 WHERE t0.properties_id = 7;

SELECT
  t0.id AS id_1,
  t0.zip_code AS zip_code_2,
  t0.street AS street_3,
  t0.city AS city_4,
  t0.place_type AS place_type_5,
  t0.place_number AS place_number_6
FROM
  address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.zip_code AS zip_code_2, t0.street AS street_3, t0.city AS city_4, t0.place_type AS place_type_5, t0.place_number AS place_number_6 FROM address t0 WHERE t0.id = 53;

SELECT
  t0.id AS id_1,
  t0.zip_code AS zip_code_2,
  t0.street AS street_3,
  t0.city AS city_4,
  t0.place_type AS place_type_5,
  t0.place_number AS place_number_6
FROM
  address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.zip_code AS zip_code_2, t0.street AS street_3, t0.city AS city_4, t0.place_type AS place_type_5, t0.place_number AS place_number_6 FROM address t0 WHERE t0.id = 49;

SELECT
  t0.id AS id_1,
  t0.zip_code AS zip_code_2,
  t0.street AS street_3,
  t0.city AS city_4,
  t0.place_type AS place_type_5,
  t0.place_number AS place_number_6
FROM
  address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.zip_code AS zip_code_2, t0.street AS street_3, t0.city AS city_4, t0.place_type AS place_type_5, t0.place_number AS place_number_6 FROM address t0 WHERE t0.id = 56;

SELECT
  t0.id AS id_1,
  t0.zip_code AS zip_code_2,
  t0.street AS street_3,
  t0.city AS city_4,
  t0.place_type AS place_type_5,
  t0.place_number AS place_number_6
FROM
  address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.zip_code AS zip_code_2, t0.street AS street_3, t0.city AS city_4, t0.place_type AS place_type_5, t0.place_number AS place_number_6 FROM address t0 WHERE t0.id = 55;

SELECT
  t0.id AS id_1,
  t0.zip_code AS zip_code_2,
  t0.street AS street_3,
  t0.city AS city_4,
  t0.place_type AS place_type_5,
  t0.place_number AS place_number_6
FROM
  address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.zip_code AS zip_code_2, t0.street AS street_3, t0.city AS city_4, t0.place_type AS place_type_5, t0.place_number AS place_number_6 FROM address t0 WHERE t0.id = 52;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  sub_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM sub_type t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  sub_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM sub_type t0 WHERE t0.id = 2;