Symfony Profiler

SELECT
  (
    6371 * 2 * ASIN(
      SQRT(
        POWER(
          SIN(
            (? - p0_.lat) * PI() / 180 / 2
          ),
          2
        ) + COS(
          p0_.lat * PI() / 180
        ) * COS(
          ? * PI() / 180
        ) * POWER(
          SIN(
            (? - p0_.lng) * PI() / 180 / 2
          ),
          2
        )
      )
    )
  ) AS sclr_0,
  p0_.id AS id_1,
  p0_.country AS country_2,
  p0_.administrative AS administrative_3,
  p0_.city AS city_4,
  p0_.address AS address_5,
  p0_.postal_code AS postal_code_6,
  p0_.address_name AS address_name_7,
  p0_.lat AS lat_8,
  p0_.lng AS lng_9,
  p0_.person1_date_of_birth AS person1_date_of_birth_10,
  p0_.person2_date_of_birth AS person2_date_of_birth_11,
  p0_.person1_height AS person1_height_12,
  p0_.person2_height AS person2_height_13,
  p0_.person1_weight AS person1_weight_14,
  p0_.person2_weight AS person2_weight_15,
  p0_.facebook AS facebook_16,
  p0_.twitter AS twitter_17,
  p0_.rss AS rss_18,
  p0_.dribble AS dribble_19,
  p0_.spotify AS spotify_20,
  p0_.instagram AS instagram_21,
  p0_.description AS description_22,
  p0_.about AS about_23,
  p0_.avatar_name AS avatar_name_24,
  p0_.avatar_size AS avatar_size_25,
  p0_.cover_name AS cover_name_26,
  p0_.cover_size AS cover_size_27,
  p0_.avatar_mime_type AS avatar_mime_type_28,
  p0_.avatar_original_name AS avatar_original_name_29,
  p0_.cover_mime_type AS cover_mime_type_30,
  p0_.cover_original_name AS cover_original_name_31,
  p0_.mood AS mood_32,
  p0_.visibility_status AS visibility_status_33,
  p0_.created_at AS created_at_34,
  p0_.updated_at AS updated_at_35,
  u1_.id AS id_36,
  u1_.email AS email_37,
  u1_.roles AS roles_38,
  u1_.password AS password_39,
  u1_.is_verified AS is_verified_40,
  u1_.username AS username_41,
  u1_.allow_friend_request AS allow_friend_request_42,
  u1_.allow_post_view AS allow_post_view_43,
  u1_.notification_email AS notification_email_44,
  u1_.friend_birth_day_notification AS friend_birth_day_notification_45,
  u1_.last_activity_at AS last_activity_at_46,
  u1_.last_login_at AS last_login_at_47,
  u1_.enabled AS enabled_48,
  u1_.created_at AS created_at_49,
  u1_.updated_at AS updated_at_50,
  p0_.person1_eye_id AS person1_eye_id_51,
  p0_.person2_eye_id AS person2_eye_id_52,
  p0_.person1_hair_id AS person1_hair_id_53,
  p0_.person2_hair_id AS person2_hair_id_54,
  p0_.person1_silhouette_id AS person1_silhouette_id_55,
  p0_.person2_silhouette_id AS person2_silhouette_id_56,
  p0_.person1_occupation_id AS person1_occupation_id_57,
  p0_.person2_occupation_id AS person2_occupation_id_58,
  p0_.person1_smoker_id AS person1_smoker_id_59,
  p0_.person2_smoker_id AS person2_smoker_id_60,
  p0_.person1_origin_id AS person1_origin_id_61,
  p0_.person2_origin_id AS person2_origin_id_62,
  p0_.person1_sexual_orientation_id AS person1_sexual_orientation_id_63,
  p0_.person2_sexual_orientation_id AS person2_sexual_orientation_id_64,
  p0_.marital_status_id AS marital_status_id_65,
  p0_.experience_id AS experience_id_66,
  p0_.children_id AS children_id_67,
  p0_.habitual_mobility_id AS habitual_mobility_id_68,
  u1_.profile_id AS profile_id_69,
  u1_.profile_type_id AS profile_type_id_70,
  u1_.user_setting_id AS user_setting_id_71,
  u1_.user_privacy_id AS user_privacy_id_72,
  u1_.user_alert_id AS user_alert_id_73
FROM
  profile p0_
  LEFT JOIN user u1_ ON p0_.id = u1_.profile_id
WHERE
  p0_.lat IS NOT NULL
  AND p0_.lng IS NOT NULL
ORDER BY
  sclr_0 ASC
LIMIT
  5

SELECT (6371 * 2 * ASIN(SQRT(POWER(SIN((48.8566 - p0_.lat) * PI() / 180 / 2), 2) + COS(p0_.lat * PI() / 180) * COS(48.8566 * PI() / 180) * POWER(SIN((2.3522 - p0_.lng) * PI() / 180 / 2), 2)))) AS sclr_0, p0_.id AS id_1, p0_.country AS country_2, p0_.administrative AS administrative_3, p0_.city AS city_4, p0_.address AS address_5, p0_.postal_code AS postal_code_6, p0_.address_name AS address_name_7, p0_.lat AS lat_8, p0_.lng AS lng_9, p0_.person1_date_of_birth AS person1_date_of_birth_10, p0_.person2_date_of_birth AS person2_date_of_birth_11, p0_.person1_height AS person1_height_12, p0_.person2_height AS person2_height_13, p0_.person1_weight AS person1_weight_14, p0_.person2_weight AS person2_weight_15, p0_.facebook AS facebook_16, p0_.twitter AS twitter_17, p0_.rss AS rss_18, p0_.dribble AS dribble_19, p0_.spotify AS spotify_20, p0_.instagram AS instagram_21, p0_.description AS description_22, p0_.about AS about_23, p0_.avatar_name AS avatar_name_24, p0_.avatar_size AS avatar_size_25, p0_.cover_name AS cover_name_26, p0_.cover_size AS cover_size_27, p0_.avatar_mime_type AS avatar_mime_type_28, p0_.avatar_original_name AS avatar_original_name_29, p0_.cover_mime_type AS cover_mime_type_30, p0_.cover_original_name AS cover_original_name_31, p0_.mood AS mood_32, p0_.visibility_status AS visibility_status_33, p0_.created_at AS created_at_34, p0_.updated_at AS updated_at_35, u1_.id AS id_36, u1_.email AS email_37, u1_.roles AS roles_38, u1_.password AS password_39, u1_.is_verified AS is_verified_40, u1_.username AS username_41, u1_.allow_friend_request AS allow_friend_request_42, u1_.allow_post_view AS allow_post_view_43, u1_.notification_email AS notification_email_44, u1_.friend_birth_day_notification AS friend_birth_day_notification_45, u1_.last_activity_at AS last_activity_at_46, u1_.last_login_at AS last_login_at_47, u1_.enabled AS enabled_48, u1_.created_at AS created_at_49, u1_.updated_at AS updated_at_50, p0_.person1_eye_id AS person1_eye_id_51, p0_.person2_eye_id AS person2_eye_id_52, p0_.person1_hair_id AS person1_hair_id_53, p0_.person2_hair_id AS person2_hair_id_54, p0_.person1_silhouette_id AS person1_silhouette_id_55, p0_.person2_silhouette_id AS person2_silhouette_id_56, p0_.person1_occupation_id AS person1_occupation_id_57, p0_.person2_occupation_id AS person2_occupation_id_58, p0_.person1_smoker_id AS person1_smoker_id_59, p0_.person2_smoker_id AS person2_smoker_id_60, p0_.person1_origin_id AS person1_origin_id_61, p0_.person2_origin_id AS person2_origin_id_62, p0_.person1_sexual_orientation_id AS person1_sexual_orientation_id_63, p0_.person2_sexual_orientation_id AS person2_sexual_orientation_id_64, p0_.marital_status_id AS marital_status_id_65, p0_.experience_id AS experience_id_66, p0_.children_id AS children_id_67, p0_.habitual_mobility_id AS habitual_mobility_id_68, u1_.profile_id AS profile_id_69, u1_.profile_type_id AS profile_type_id_70, u1_.user_setting_id AS user_setting_id_71, u1_.user_privacy_id AS user_privacy_id_72, u1_.user_alert_id AS user_alert_id_73 FROM profile p0_ LEFT JOIN user u1_ ON p0_.id = u1_.profile_id WHERE p0_.lat IS NOT NULL AND p0_.lng IS NOT NULL ORDER BY sclr_0 ASC LIMIT 5;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.is_verified AS is_verified_4,
  u0_.username AS username_5,
  u0_.allow_friend_request AS allow_friend_request_6,
  u0_.allow_post_view AS allow_post_view_7,
  u0_.notification_email AS notification_email_8,
  u0_.friend_birth_day_notification AS friend_birth_day_notification_9,
  u0_.last_activity_at AS last_activity_at_10,
  u0_.last_login_at AS last_login_at_11,
  u0_.enabled AS enabled_12,
  u0_.created_at AS created_at_13,
  u0_.updated_at AS updated_at_14,
  u0_.profile_id AS profile_id_15,
  u0_.profile_type_id AS profile_type_id_16,
  u0_.user_setting_id AS user_setting_id_17,
  u0_.user_privacy_id AS user_privacy_id_18,
  u0_.user_alert_id AS user_alert_id_19
FROM
  user u0_
WHERE
  u0_.last_activity_at > ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.username AS username_5, u0_.allow_friend_request AS allow_friend_request_6, u0_.allow_post_view AS allow_post_view_7, u0_.notification_email AS notification_email_8, u0_.friend_birth_day_notification AS friend_birth_day_notification_9, u0_.last_activity_at AS last_activity_at_10, u0_.last_login_at AS last_login_at_11, u0_.enabled AS enabled_12, u0_.created_at AS created_at_13, u0_.updated_at AS updated_at_14, u0_.profile_id AS profile_id_15, u0_.profile_type_id AS profile_type_id_16, u0_.user_setting_id AS user_setting_id_17, u0_.user_privacy_id AS user_privacy_id_18, u0_.user_alert_id AS user_alert_id_19 FROM user u0_ WHERE u0_.last_activity_at > '2026-05-03 20:04:43';