Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.category AS category_3,
  t0.type AS type_4,
  t0.area AS area_5,
  t0.bedrooms AS bedrooms_6,
  t0.bathrooms AS bathrooms_7,
  t0.parking AS parking_8,
  t0.options AS options_9,
  t0.description AS description_10,
  t0.price AS price_11,
  t0.currency AS currency_12,
  t0.payment_period AS payment_period_13,
  t0.status AS status_14,
  t0.floor_count AS floor_count_15,
  t0.floor_no AS floor_no_16,
  t0.building_type AS building_type_17,
  t0.building_age AS building_age_18,
  t0.building_status AS building_status_19,
  t0.balcony_type AS balcony_type_20,
  t0.balcony_status AS balcony_status_21,
  t0.heating_system AS heating_system_22,
  t0.furniture_status AS furniture_status_23,
  t0.living_room_size AS living_room_size_24,
  t0.is_complex AS is_complex_25,
  t0.is_designed AS is_designed_26,
  t0.created_date AS created_date_27,
  t0.place_distances AS place_distances_28,
  t0.contract_party AS contract_party_29,
  t0.lease_duration_year AS lease_duration_year_30,
  t0.lease_duration_remaining_months AS lease_duration_remaining_months_31,
  t0.price_deposit AS price_deposit_32,
  t0.bed_type AS bed_type_33,
  t0.living_room AS living_room_34,
  t0.facilities_and_conditions AS facilities_and_conditions_35,
  t0.room_mate_gender AS room_mate_gender_36,
  t0.number_of_room_mates AS number_of_room_mates_37,
  t0.address_id AS address_id_38,
  t0.user_id AS user_id_39
FROM
  `leasehold` t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.category AS category_3, t0.type AS type_4, t0.area AS area_5, t0.bedrooms AS bedrooms_6, t0.bathrooms AS bathrooms_7, t0.parking AS parking_8, t0.options AS options_9, t0.description AS description_10, t0.price AS price_11, t0.currency AS currency_12, t0.payment_period AS payment_period_13, t0.status AS status_14, t0.floor_count AS floor_count_15, t0.floor_no AS floor_no_16, t0.building_type AS building_type_17, t0.building_age AS building_age_18, t0.building_status AS building_status_19, t0.balcony_type AS balcony_type_20, t0.balcony_status AS balcony_status_21, t0.heating_system AS heating_system_22, t0.furniture_status AS furniture_status_23, t0.living_room_size AS living_room_size_24, t0.is_complex AS is_complex_25, t0.is_designed AS is_designed_26, t0.created_date AS created_date_27, t0.place_distances AS place_distances_28, t0.contract_party AS contract_party_29, t0.lease_duration_year AS lease_duration_year_30, t0.lease_duration_remaining_months AS lease_duration_remaining_months_31, t0.price_deposit AS price_deposit_32, t0.bed_type AS bed_type_33, t0.living_room AS living_room_34, t0.facilities_and_conditions AS facilities_and_conditions_35, t0.room_mate_gender AS room_mate_gender_36, t0.number_of_room_mates AS number_of_room_mates_37, t0.address_id AS address_id_38, t0.user_id AS user_id_39 FROM `leasehold` t0 WHERE t0.id = '2' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.country AS country_2,
  t0.province AS province_3,
  t0.city AS city_4,
  t0.zip_code AS zip_code_5,
  t0.address AS address_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8,
  t9.id AS id_10,
  t9.title AS title_11,
  t9.category AS category_12,
  t9.type AS type_13,
  t9.area AS area_14,
  t9.bedrooms AS bedrooms_15,
  t9.bathrooms AS bathrooms_16,
  t9.parking AS parking_17,
  t9.options AS options_18,
  t9.description AS description_19,
  t9.price AS price_20,
  t9.currency AS currency_21,
  t9.payment_period AS payment_period_22,
  t9.status AS status_23,
  t9.created_date AS created_date_24,
  t9.address_id AS address_id_25,
  t9.user_id AS user_id_26
FROM
  `address` t0
  LEFT JOIN roomie t9 ON t9.address_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.country AS country_2, t0.province AS province_3, t0.city AS city_4, t0.zip_code AS zip_code_5, t0.address AS address_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t9.id AS id_10, t9.title AS title_11, t9.category AS category_12, t9.type AS type_13, t9.area AS area_14, t9.bedrooms AS bedrooms_15, t9.bathrooms AS bathrooms_16, t9.parking AS parking_17, t9.options AS options_18, t9.description AS description_19, t9.price AS price_20, t9.currency AS currency_21, t9.payment_period AS payment_period_22, t9.status AS status_23, t9.created_date AS created_date_24, t9.address_id AS address_id_25, t9.user_id AS user_id_26 FROM `address` t0 LEFT JOIN roomie t9 ON t9.address_id = t0.id WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.image_path AS image_path_2,
  t0.size AS size_3,
  t0.lease_hold_id AS lease_hold_id_4,
  t0.roomie_id AS roomie_id_5
FROM
  `gallery` t0
WHERE
  t0.lease_hold_id = ?

SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.size AS size_3, t0.lease_hold_id AS lease_hold_id_4, t0.roomie_id AS roomie_id_5 FROM `gallery` t0 WHERE t0.lease_hold_id = 2;

SELECT
  t0.id AS id_1,
  t0.entity_id AS entity_id_2,
  t0.entity_type AS entity_type_3,
  t0.text AS text_4,
  t0.status AS status_5,
  t0.created_at AS created_at_6,
  t0.owner_id AS owner_id_7
FROM
  comment t0
WHERE
  t0.entity_type = ?
  AND t0.entity_id = ?
  AND t0.status = ?

SELECT t0.id AS id_1, t0.entity_id AS entity_id_2, t0.entity_type AS entity_type_3, t0.text AS text_4, t0.status AS status_5, t0.created_at AS created_at_6, t0.owner_id AS owner_id_7 FROM comment t0 WHERE t0.entity_type = 1 AND t0.entity_id = '2' AND t0.status = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.type AS type_6,
  t0.status AS status_7,
  t0.token AS token_8,
  t9.id AS id_10,
  t9.fullname AS fullname_11,
  t9.phone AS phone_12,
  t9.address AS address_13,
  t9.facebook_id AS facebook_id_14,
  t9.instagram_id AS instagram_id_15,
  t9.bio AS bio_16,
  t9.avatar AS avatar_17,
  t9.gender AS gender_18,
  t9.age AS age_19,
  t9.education AS education_20,
  t9.languages AS languages_21,
  t9.job AS job_22,
  t9.relationship AS relationship_23,
  t9.idcard_no AS idcard_no_24,
  t9.ems_phone_number AS ems_phone_number_25,
  t9.profile_type AS profile_type_26,
  t9.skills AS skills_27,
  t9.created_at AS created_at_28,
  t9.viewed AS viewed_29,
  t9.company_name AS company_name_30,
  t9.telegram_id AS telegram_id_31,
  t9.linkedin_id AS linkedin_id_32,
  t9.whatsapp_number AS whatsapp_number_33,
  t9.website AS website_34,
  t9.email AS email_35,
  t9.conditions_and_rules AS conditions_and_rules_36,
  t9.user_id AS user_id_37,
  t38.id AS id_39,
  t38.fullname AS fullname_40,
  t38.age AS age_41,
  t38.gender AS gender_42,
  t38.intro AS intro_43,
  t38.work AS work_44,
  t38.target_date AS target_date_45,
  t38.budget AS budget_46,
  t38.neighbors AS neighbors_47,
  t38.prefs AS prefs_48,
  t38.title AS title_49,
  t38.status AS status_50,
  t38.lifestyle AS lifestyle_51,
  t38.similarity_distance AS similarity_distance_52,
  t38.country AS country_53,
  t38.city AS city_54,
  t38.region AS region_55,
  t38.building_type AS building_type_56,
  t38.accomm_type AS accomm_type_57,
  t38.number_of_room_mates AS number_of_room_mates_58,
  t38.room_mate_age_min AS room_mate_age_min_59,
  t38.room_mate_age_max AS room_mate_age_max_60,
  t38.lease_duration AS lease_duration_61,
  t38.deposit AS deposit_62,
  t38.room_mate_gender AS room_mate_gender_63,
  t38.description AS description_64,
  t38.user_id AS user_id_65
FROM
  `user` t0
  LEFT JOIN profile t9 ON t9.user_id = t0.id
  LEFT JOIN seeker t38 ON t38.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.type AS type_6, t0.status AS status_7, t0.token AS token_8, t9.id AS id_10, t9.fullname AS fullname_11, t9.phone AS phone_12, t9.address AS address_13, t9.facebook_id AS facebook_id_14, t9.instagram_id AS instagram_id_15, t9.bio AS bio_16, t9.avatar AS avatar_17, t9.gender AS gender_18, t9.age AS age_19, t9.education AS education_20, t9.languages AS languages_21, t9.job AS job_22, t9.relationship AS relationship_23, t9.idcard_no AS idcard_no_24, t9.ems_phone_number AS ems_phone_number_25, t9.profile_type AS profile_type_26, t9.skills AS skills_27, t9.created_at AS created_at_28, t9.viewed AS viewed_29, t9.company_name AS company_name_30, t9.telegram_id AS telegram_id_31, t9.linkedin_id AS linkedin_id_32, t9.whatsapp_number AS whatsapp_number_33, t9.website AS website_34, t9.email AS email_35, t9.conditions_and_rules AS conditions_and_rules_36, t9.user_id AS user_id_37, t38.id AS id_39, t38.fullname AS fullname_40, t38.age AS age_41, t38.gender AS gender_42, t38.intro AS intro_43, t38.work AS work_44, t38.target_date AS target_date_45, t38.budget AS budget_46, t38.neighbors AS neighbors_47, t38.prefs AS prefs_48, t38.title AS title_49, t38.status AS status_50, t38.lifestyle AS lifestyle_51, t38.similarity_distance AS similarity_distance_52, t38.country AS country_53, t38.city AS city_54, t38.region AS region_55, t38.building_type AS building_type_56, t38.accomm_type AS accomm_type_57, t38.number_of_room_mates AS number_of_room_mates_58, t38.room_mate_age_min AS room_mate_age_min_59, t38.room_mate_age_max AS room_mate_age_max_60, t38.lease_duration AS lease_duration_61, t38.deposit AS deposit_62, t38.room_mate_gender AS room_mate_gender_63, t38.description AS description_64, t38.user_id AS user_id_65 FROM `user` t0 LEFT JOIN profile t9 ON t9.user_id = t0.id LEFT JOIN seeker t38 ON t38.user_id = t0.id WHERE t0.id = 1;