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.views AS views_38,
  t0.address_id AS address_id_39,
  t0.user_id AS user_id_40
FROM
  `leasehold` t0
WHERE
  t0.category = ?

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.views AS views_38, t0.address_id AS address_id_39, t0.user_id AS user_id_40 FROM `leasehold` t0 WHERE t0.category = 2;

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,
  t0.referral_code AS referral_code_9,
  t10.id AS id_11,
  t10.fullname AS fullname_12,
  t10.phone AS phone_13,
  t10.address AS address_14,
  t10.facebook_id AS facebook_id_15,
  t10.instagram_id AS instagram_id_16,
  t10.bio AS bio_17,
  t10.avatar AS avatar_18,
  t10.gender AS gender_19,
  t10.age AS age_20,
  t10.education AS education_21,
  t10.languages AS languages_22,
  t10.job AS job_23,
  t10.relationship AS relationship_24,
  t10.idcard_no AS idcard_no_25,
  t10.ems_phone_number AS ems_phone_number_26,
  t10.profile_type AS profile_type_27,
  t10.skills AS skills_28,
  t10.created_at AS created_at_29,
  t10.viewed AS viewed_30,
  t10.company_name AS company_name_31,
  t10.telegram_id AS telegram_id_32,
  t10.linkedin_id AS linkedin_id_33,
  t10.whatsapp_number AS whatsapp_number_34,
  t10.website AS website_35,
  t10.email AS email_36,
  t10.conditions_and_rules AS conditions_and_rules_37,
  t10.lifestyle AS lifestyle_38,
  t10.interests AS interests_39,
  t10.country AS country_40,
  t10.city AS city_41,
  t10.active_since AS active_since_42,
  t10.has_tick_badge AS has_tick_badge_43,
  t10.user_id AS user_id_44,
  t45.id AS id_46,
  t45.fullname AS fullname_47,
  t45.age AS age_48,
  t45.gender AS gender_49,
  t45.intro AS intro_50,
  t45.work AS work_51,
  t45.target_date AS target_date_52,
  t45.budget AS budget_53,
  t45.neighbors AS neighbors_54,
  t45.prefs AS prefs_55,
  t45.title AS title_56,
  t45.status AS status_57,
  t45.lifestyle AS lifestyle_58,
  t45.similarity_distance AS similarity_distance_59,
  t45.country AS country_60,
  t45.city AS city_61,
  t45.region AS region_62,
  t45.building_type AS building_type_63,
  t45.accomm_type AS accomm_type_64,
  t45.number_of_room_mates AS number_of_room_mates_65,
  t45.room_mate_age_min AS room_mate_age_min_66,
  t45.room_mate_age_max AS room_mate_age_max_67,
  t45.lease_duration AS lease_duration_68,
  t45.deposit AS deposit_69,
  t45.room_mate_gender AS room_mate_gender_70,
  t45.description AS description_71,
  t45.user_id AS user_id_72
FROM
  `user` t0
  LEFT JOIN profile t10 ON t10.user_id = t0.id
  LEFT JOIN seeker t45 ON t45.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, t0.referral_code AS referral_code_9, t10.id AS id_11, t10.fullname AS fullname_12, t10.phone AS phone_13, t10.address AS address_14, t10.facebook_id AS facebook_id_15, t10.instagram_id AS instagram_id_16, t10.bio AS bio_17, t10.avatar AS avatar_18, t10.gender AS gender_19, t10.age AS age_20, t10.education AS education_21, t10.languages AS languages_22, t10.job AS job_23, t10.relationship AS relationship_24, t10.idcard_no AS idcard_no_25, t10.ems_phone_number AS ems_phone_number_26, t10.profile_type AS profile_type_27, t10.skills AS skills_28, t10.created_at AS created_at_29, t10.viewed AS viewed_30, t10.company_name AS company_name_31, t10.telegram_id AS telegram_id_32, t10.linkedin_id AS linkedin_id_33, t10.whatsapp_number AS whatsapp_number_34, t10.website AS website_35, t10.email AS email_36, t10.conditions_and_rules AS conditions_and_rules_37, t10.lifestyle AS lifestyle_38, t10.interests AS interests_39, t10.country AS country_40, t10.city AS city_41, t10.active_since AS active_since_42, t10.has_tick_badge AS has_tick_badge_43, t10.user_id AS user_id_44, t45.id AS id_46, t45.fullname AS fullname_47, t45.age AS age_48, t45.gender AS gender_49, t45.intro AS intro_50, t45.work AS work_51, t45.target_date AS target_date_52, t45.budget AS budget_53, t45.neighbors AS neighbors_54, t45.prefs AS prefs_55, t45.title AS title_56, t45.status AS status_57, t45.lifestyle AS lifestyle_58, t45.similarity_distance AS similarity_distance_59, t45.country AS country_60, t45.city AS city_61, t45.region AS region_62, t45.building_type AS building_type_63, t45.accomm_type AS accomm_type_64, t45.number_of_room_mates AS number_of_room_mates_65, t45.room_mate_age_min AS room_mate_age_min_66, t45.room_mate_age_max AS room_mate_age_max_67, t45.lease_duration AS lease_duration_68, t45.deposit AS deposit_69, t45.room_mate_gender AS room_mate_gender_70, t45.description AS description_71, t45.user_id AS user_id_72 FROM `user` t0 LEFT JOIN profile t10 ON t10.user_id = t0.id LEFT JOIN seeker t45 ON t45.user_id = t0.id WHERE t0.id = 1;

SELECT
  AVG(r0_.score) AS sclr_0
FROM
  rating r0_
WHERE
  r0_.rated_id = ?

SELECT AVG(r0_.score) AS sclr_0 FROM rating r0_ WHERE r0_.rated_id = 1;

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 = 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,
  t0.map_zoom AS map_zoom_9,
  t10.id AS id_11,
  t10.title AS title_12,
  t10.category AS category_13,
  t10.type AS type_14,
  t10.area AS area_15,
  t10.bedrooms AS bedrooms_16,
  t10.bathrooms AS bathrooms_17,
  t10.parking AS parking_18,
  t10.options AS options_19,
  t10.description AS description_20,
  t10.price AS price_21,
  t10.currency AS currency_22,
  t10.payment_period AS payment_period_23,
  t10.status AS status_24,
  t10.created_date AS created_date_25,
  t10.address_id AS address_id_26,
  t10.user_id AS user_id_27
FROM
  `address` t0
  LEFT JOIN roomie t10 ON t10.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, t0.map_zoom AS map_zoom_9, t10.id AS id_11, t10.title AS title_12, t10.category AS category_13, t10.type AS type_14, t10.area AS area_15, t10.bedrooms AS bedrooms_16, t10.bathrooms AS bathrooms_17, t10.parking AS parking_18, t10.options AS options_19, t10.description AS description_20, t10.price AS price_21, t10.currency AS currency_22, t10.payment_period AS payment_period_23, t10.status AS status_24, t10.created_date AS created_date_25, t10.address_id AS address_id_26, t10.user_id AS user_id_27 FROM `address` t0 LEFT JOIN roomie t10 ON t10.address_id = t0.id WHERE t0.id = 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,
  t0.referral_code AS referral_code_9,
  t10.id AS id_11,
  t10.fullname AS fullname_12,
  t10.phone AS phone_13,
  t10.address AS address_14,
  t10.facebook_id AS facebook_id_15,
  t10.instagram_id AS instagram_id_16,
  t10.bio AS bio_17,
  t10.avatar AS avatar_18,
  t10.gender AS gender_19,
  t10.age AS age_20,
  t10.education AS education_21,
  t10.languages AS languages_22,
  t10.job AS job_23,
  t10.relationship AS relationship_24,
  t10.idcard_no AS idcard_no_25,
  t10.ems_phone_number AS ems_phone_number_26,
  t10.profile_type AS profile_type_27,
  t10.skills AS skills_28,
  t10.created_at AS created_at_29,
  t10.viewed AS viewed_30,
  t10.company_name AS company_name_31,
  t10.telegram_id AS telegram_id_32,
  t10.linkedin_id AS linkedin_id_33,
  t10.whatsapp_number AS whatsapp_number_34,
  t10.website AS website_35,
  t10.email AS email_36,
  t10.conditions_and_rules AS conditions_and_rules_37,
  t10.lifestyle AS lifestyle_38,
  t10.interests AS interests_39,
  t10.country AS country_40,
  t10.city AS city_41,
  t10.active_since AS active_since_42,
  t10.has_tick_badge AS has_tick_badge_43,
  t10.user_id AS user_id_44,
  t45.id AS id_46,
  t45.fullname AS fullname_47,
  t45.age AS age_48,
  t45.gender AS gender_49,
  t45.intro AS intro_50,
  t45.work AS work_51,
  t45.target_date AS target_date_52,
  t45.budget AS budget_53,
  t45.neighbors AS neighbors_54,
  t45.prefs AS prefs_55,
  t45.title AS title_56,
  t45.status AS status_57,
  t45.lifestyle AS lifestyle_58,
  t45.similarity_distance AS similarity_distance_59,
  t45.country AS country_60,
  t45.city AS city_61,
  t45.region AS region_62,
  t45.building_type AS building_type_63,
  t45.accomm_type AS accomm_type_64,
  t45.number_of_room_mates AS number_of_room_mates_65,
  t45.room_mate_age_min AS room_mate_age_min_66,
  t45.room_mate_age_max AS room_mate_age_max_67,
  t45.lease_duration AS lease_duration_68,
  t45.deposit AS deposit_69,
  t45.room_mate_gender AS room_mate_gender_70,
  t45.description AS description_71,
  t45.user_id AS user_id_72
FROM
  `user` t0
  LEFT JOIN profile t10 ON t10.user_id = t0.id
  LEFT JOIN seeker t45 ON t45.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, t0.referral_code AS referral_code_9, t10.id AS id_11, t10.fullname AS fullname_12, t10.phone AS phone_13, t10.address AS address_14, t10.facebook_id AS facebook_id_15, t10.instagram_id AS instagram_id_16, t10.bio AS bio_17, t10.avatar AS avatar_18, t10.gender AS gender_19, t10.age AS age_20, t10.education AS education_21, t10.languages AS languages_22, t10.job AS job_23, t10.relationship AS relationship_24, t10.idcard_no AS idcard_no_25, t10.ems_phone_number AS ems_phone_number_26, t10.profile_type AS profile_type_27, t10.skills AS skills_28, t10.created_at AS created_at_29, t10.viewed AS viewed_30, t10.company_name AS company_name_31, t10.telegram_id AS telegram_id_32, t10.linkedin_id AS linkedin_id_33, t10.whatsapp_number AS whatsapp_number_34, t10.website AS website_35, t10.email AS email_36, t10.conditions_and_rules AS conditions_and_rules_37, t10.lifestyle AS lifestyle_38, t10.interests AS interests_39, t10.country AS country_40, t10.city AS city_41, t10.active_since AS active_since_42, t10.has_tick_badge AS has_tick_badge_43, t10.user_id AS user_id_44, t45.id AS id_46, t45.fullname AS fullname_47, t45.age AS age_48, t45.gender AS gender_49, t45.intro AS intro_50, t45.work AS work_51, t45.target_date AS target_date_52, t45.budget AS budget_53, t45.neighbors AS neighbors_54, t45.prefs AS prefs_55, t45.title AS title_56, t45.status AS status_57, t45.lifestyle AS lifestyle_58, t45.similarity_distance AS similarity_distance_59, t45.country AS country_60, t45.city AS city_61, t45.region AS region_62, t45.building_type AS building_type_63, t45.accomm_type AS accomm_type_64, t45.number_of_room_mates AS number_of_room_mates_65, t45.room_mate_age_min AS room_mate_age_min_66, t45.room_mate_age_max AS room_mate_age_max_67, t45.lease_duration AS lease_duration_68, t45.deposit AS deposit_69, t45.room_mate_gender AS room_mate_gender_70, t45.description AS description_71, t45.user_id AS user_id_72 FROM `user` t0 LEFT JOIN profile t10 ON t10.user_id = t0.id LEFT JOIN seeker t45 ON t45.user_id = t0.id WHERE t0.id = 5;

SELECT
  AVG(r0_.score) AS sclr_0
FROM
  rating r0_
WHERE
  r0_.rated_id = ?

SELECT AVG(r0_.score) AS sclr_0 FROM rating r0_ WHERE r0_.rated_id = 5;

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.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,
  t0.map_zoom AS map_zoom_9,
  t10.id AS id_11,
  t10.title AS title_12,
  t10.category AS category_13,
  t10.type AS type_14,
  t10.area AS area_15,
  t10.bedrooms AS bedrooms_16,
  t10.bathrooms AS bathrooms_17,
  t10.parking AS parking_18,
  t10.options AS options_19,
  t10.description AS description_20,
  t10.price AS price_21,
  t10.currency AS currency_22,
  t10.payment_period AS payment_period_23,
  t10.status AS status_24,
  t10.created_date AS created_date_25,
  t10.address_id AS address_id_26,
  t10.user_id AS user_id_27
FROM
  `address` t0
  LEFT JOIN roomie t10 ON t10.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, t0.map_zoom AS map_zoom_9, t10.id AS id_11, t10.title AS title_12, t10.category AS category_13, t10.type AS type_14, t10.area AS area_15, t10.bedrooms AS bedrooms_16, t10.bathrooms AS bathrooms_17, t10.parking AS parking_18, t10.options AS options_19, t10.description AS description_20, t10.price AS price_21, t10.currency AS currency_22, t10.payment_period AS payment_period_23, t10.status AS status_24, t10.created_date AS created_date_25, t10.address_id AS address_id_26, t10.user_id AS user_id_27 FROM `address` t0 LEFT JOIN roomie t10 ON t10.address_id = t0.id WHERE t0.id = 2;