Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.fullname AS fullname_1,
  s0_.age AS age_2,
  s0_.gender AS gender_3,
  s0_.intro AS intro_4,
  s0_.work AS work_5,
  s0_.target_date AS target_date_6,
  s0_.budget AS budget_7,
  s0_.neighbors AS neighbors_8,
  s0_.prefs AS prefs_9,
  s0_.title AS title_10,
  s0_.status AS status_11,
  s0_.lifestyle AS lifestyle_12,
  s0_.similarity_distance AS similarity_distance_13,
  s0_.country AS country_14,
  s0_.city AS city_15,
  s0_.region AS region_16,
  s0_.building_type AS building_type_17,
  s0_.accomm_type AS accomm_type_18,
  s0_.number_of_room_mates AS number_of_room_mates_19,
  s0_.room_mate_age_min AS room_mate_age_min_20,
  s0_.room_mate_age_max AS room_mate_age_max_21,
  s0_.lease_duration AS lease_duration_22,
  s0_.deposit AS deposit_23,
  s0_.room_mate_gender AS room_mate_gender_24,
  s0_.description AS description_25,
  s0_.user_id AS user_id_26
FROM
  seeker s0_
  INNER JOIN `user` u1_ ON (s0_.user_id = u1_.id)
WHERE
  s0_.status = 1

SELECT s0_.id AS id_0, s0_.fullname AS fullname_1, s0_.age AS age_2, s0_.gender AS gender_3, s0_.intro AS intro_4, s0_.work AS work_5, s0_.target_date AS target_date_6, s0_.budget AS budget_7, s0_.neighbors AS neighbors_8, s0_.prefs AS prefs_9, s0_.title AS title_10, s0_.status AS status_11, s0_.lifestyle AS lifestyle_12, s0_.similarity_distance AS similarity_distance_13, s0_.country AS country_14, s0_.city AS city_15, s0_.region AS region_16, s0_.building_type AS building_type_17, s0_.accomm_type AS accomm_type_18, s0_.number_of_room_mates AS number_of_room_mates_19, s0_.room_mate_age_min AS room_mate_age_min_20, s0_.room_mate_age_max AS room_mate_age_max_21, s0_.lease_duration AS lease_duration_22, s0_.deposit AS deposit_23, s0_.room_mate_gender AS room_mate_gender_24, s0_.description AS description_25, s0_.user_id AS user_id_26 FROM seeker s0_ INNER JOIN `user` u1_ ON (s0_.user_id = u1_.id) WHERE s0_.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,
  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 = 3;

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 = 3;

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;