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;