Symfony Profiler

SELECT 
  t0.username AS username_1, 
  t0.username_canonical AS username_canonical_2, 
  t0.email AS email_3, 
  t0.email_canonical AS email_canonical_4, 
  t0.enabled AS enabled_5, 
  t0.salt AS salt_6, 
  t0.password AS password_7, 
  t0.last_login AS last_login_8, 
  t0.confirmation_token AS confirmation_token_9, 
  t0.password_requested_at AS password_requested_at_10, 
  t0.roles AS roles_11, 
  t0.id AS id_12, 
  t0.first_name AS first_name_13, 
  t0.last_name AS last_name_14, 
  t0.gender AS gender_15, 
  t0.notified_for_finalise_account AS notified_for_finalise_account_16, 
  t0.birthday AS birthday_17, 
  t0.is_fake AS is_fake_18, 
  t0.from_sentsio AS from_sentsio_19, 
  t0.profile_slug AS profile_slug_20, 
  t0.number_logins AS number_logins_21, 
  t0.login_dates AS login_dates_22, 
  t0.last_activity AS last_activity_23, 
  t0.number_conversions AS number_conversions_24, 
  t0.number_fake_users AS number_fake_users_25, 
  t0.profile_views AS profile_views_26, 
  t0.confirmed AS confirmed_27, 
  t0.last_registration_step AS last_registration_step_28, 
  t0.address AS address_29, 
  t0.relationship_status AS relationship_status_30, 
  t0.workplace AS workplace_31, 
  t0.short_bio AS short_bio_32, 
  t0.interested_in_long AS interested_in_long_33, 
  t0.motto AS motto_34, 
  t0.number_of_friends AS number_of_friends_35, 
  t0.number_of_photos AS number_of_photos_36, 
  t0.number_of_videos AS number_of_videos_37, 
  t0.number_of_albums AS number_of_albums_38, 
  t0.receive_email_notification_friend_request AS receive_email_notification_friend_request_39, 
  t0.receive_email_notification_comment_photo AS receive_email_notification_comment_photo_40, 
  t0.receive_email_notification_like_photo AS receive_email_notification_like_photo_41, 
  t0.receive_email_notification_other_user_comment_photo AS receive_email_notification_other_user_comment_photo_42, 
  t0.receive_email_notification_missed_messages AS receive_email_notification_missed_messages_43, 
  t0.receive_email_notification_promotions AS receive_email_notification_promotions_44, 
  t0.locked AS locked_45, 
  t0.receive_email_notifications AS receive_email_notifications_46, 
  t0.aws_bounce_or_complained AS aws_bounce_or_complained_47, 
  t0.public_profile AS public_profile_48, 
  t0.is_online AS is_online_49, 
  t0.real_is_online AS real_is_online_50, 
  t0.has_unread_alerts AS has_unread_alerts_51, 
  t0.has_unseen_profile_views AS has_unseen_profile_views_52, 
  t0.total_nbr_unseen_profile_views AS total_nbr_unseen_profile_views_53, 
  t0.package_name AS package_name_54, 
  t0.package_expires_on AS package_expires_on_55, 
  t0.package_last_payment_made_on AS package_last_payment_made_on_56, 
  t0.package_next_payment_due_on AS package_next_payment_due_on_57, 
  t0.package_cancellation_mail_sent_on AS package_cancellation_mail_sent_on_58, 
  t0.credits AS credits_59, 
  t0.bonus_credits AS bonus_credits_60, 
  t0.number_of_approved_friend_requests AS number_of_approved_friend_requests_61, 
  t0.number_of_photo_likes_sent AS number_of_photo_likes_sent_62, 
  t0.number_of_photo_comments_sent AS number_of_photo_comments_sent_63, 
  t0.number_of_video_likes_sent AS number_of_video_likes_sent_64, 
  t0.number_of_video_comments_sent AS number_of_video_comments_sent_65, 
  t0.number_of_messages_sent AS number_of_messages_sent_66, 
  t0.number_of_voice_calls_made AS number_of_voice_calls_made_67, 
  t0.number_of_video_calls_made AS number_of_video_calls_made_68, 
  t0.phone_number AS phone_number_69, 
  t0.has_unread_messages AS has_unread_messages_70, 
  t0.has_unread_friend_requests AS has_unread_friend_requests_71, 
  t0.has_unread_profile_views AS has_unread_profile_views_72, 
  t0.user_status AS user_status_73, 
  t0.user_status_interval_start AS user_status_interval_start_74, 
  t0.user_status_interval_end AS user_status_interval_end_75, 
  t0.updated_at_by_alert AS updated_at_by_alert_76, 
  t0.from_landing_page AS from_landing_page_77, 
  t0.nbr_contacts_imported AS nbr_contacts_imported_78, 
  t0.has_agreed_to_waive_rights AS has_agreed_to_waive_rights_79, 
  t0.is_in_call AS is_in_call_80, 
  t0.default_ordering AS default_ordering_81, 
  t0.tour_completed AS tour_completed_82, 
  t0.should_open_tour AS should_open_tour_83, 
  t0.profile_complete_photo_upload AS profile_complete_photo_upload_84, 
  t0.profile_complete_made_friends AS profile_complete_made_friends_85, 
  t0.profile_complete_liked_photo AS profile_complete_liked_photo_86, 
  t0.profile_complete_sent_message AS profile_complete_sent_message_87, 
  t0.should_be_unsubscribed_according_to_gdpr AS should_be_unsubscribed_according_to_gdpr_88, 
  t0.pin_code AS pin_code_89, 
  t0.invite AS invite_90, 
  t0.s_mode AS s_mode_91, 
  t0.ban_payment AS ban_payment_92, 
  t0.created_at AS created_at_93, 
  t0.updated_at AS updated_at_94, 
  t0.invite_updated_by AS invite_updated_by_95, 
  t0.can_comment_or_chat AS can_comment_or_chat_96, 
  t0.email_validation_hook AS email_validation_hook_97, 
  t0.profile_boosted AS profile_boosted_98, 
  t0.boosted_at AS boosted_at_99, 
  t0.head_users AS head_users_100, 
  t0.traffic_pool_campaigns AS traffic_pool_campaigns_101, 
  t0.invite_updated_at AS invite_updated_at_102, 
  t0.extend_period_signup_confirmation AS extend_period_signup_confirmation_103, 
  t104.id AS id_105, 
  t104.customer_id AS customer_id_106, 
  t104.created_at AS created_at_107, 
  t104.updated_at AS updated_at_108, 
  t104.user_reference_id AS user_reference_id_109, 
  t110.id AS id_111, 
  t110.customer_id AS customer_id_112, 
  t110.created_at AS created_at_113, 
  t110.user_reference AS user_reference_114, 
  t115.id AS id_116, 
  t115.user_ip AS user_ip_117, 
  t115.continent_code AS continent_code_118, 
  t115.continent_name AS continent_name_119, 
  t115.country_code AS country_code_120, 
  t115.country_name AS country_name_121, 
  t115.region_code AS region_code_122, 
  t115.region_name AS region_name_123, 
  t115.city_geo_name_id AS city_geo_name_id_124, 
  t115.city AS city_125, 
  t115.postal_code AS postal_code_126, 
  t115.latitude AS latitude_127, 
  t115.longitude AS longitude_128, 
  t115.languages AS languages_129, 
  t115.currency AS currency_130, 
  t115.timezone AS timezone_131, 
  t115.user_agent AS user_agent_132, 
  t115.connection AS connection_133, 
  t115.security AS security_134, 
  t115.created_at AS created_at_135, 
  t115.updated_at AS updated_at_136, 
  t115.user_id AS user_id_137, 
  t115.new_location_id AS new_location_id_138, 
  t0.owner_id AS owner_id_139, 
  t0.leader_id AS leader_id_140, 
  t0.packages_list_id AS packages_list_id_141, 
  t0.image_id AS image_id_142, 
  t0.cover_image_id AS cover_image_id_143, 
  t0.location_id AS location_id_144, 
  t0.payment_reference_id AS payment_reference_id_145, 
  t0.language_id AS language_id_146, 
  t0.new_location_id AS new_location_id_147 
FROM 
  user t0 
  LEFT JOIN payment_centralPay_customers2 t104 ON t104.user_reference_id = t0.id 
  LEFT JOIN payment_centralPay_customers t110 ON t110.user_reference = t0.id 
  LEFT JOIN history_apiip t115 ON t115.user_id = t0.id 
WHERE 
  t0.username = ? 
LIMIT 
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.gender AS gender_15, t0.notified_for_finalise_account AS notified_for_finalise_account_16, t0.birthday AS birthday_17, t0.is_fake AS is_fake_18, t0.from_sentsio AS from_sentsio_19, t0.profile_slug AS profile_slug_20, t0.number_logins AS number_logins_21, t0.login_dates AS login_dates_22, t0.last_activity AS last_activity_23, t0.number_conversions AS number_conversions_24, t0.number_fake_users AS number_fake_users_25, t0.profile_views AS profile_views_26, t0.confirmed AS confirmed_27, t0.last_registration_step AS last_registration_step_28, t0.address AS address_29, t0.relationship_status AS relationship_status_30, t0.workplace AS workplace_31, t0.short_bio AS short_bio_32, t0.interested_in_long AS interested_in_long_33, t0.motto AS motto_34, t0.number_of_friends AS number_of_friends_35, t0.number_of_photos AS number_of_photos_36, t0.number_of_videos AS number_of_videos_37, t0.number_of_albums AS number_of_albums_38, t0.receive_email_notification_friend_request AS receive_email_notification_friend_request_39, t0.receive_email_notification_comment_photo AS receive_email_notification_comment_photo_40, t0.receive_email_notification_like_photo AS receive_email_notification_like_photo_41, t0.receive_email_notification_other_user_comment_photo AS receive_email_notification_other_user_comment_photo_42, t0.receive_email_notification_missed_messages AS receive_email_notification_missed_messages_43, t0.receive_email_notification_promotions AS receive_email_notification_promotions_44, t0.locked AS locked_45, t0.receive_email_notifications AS receive_email_notifications_46, t0.aws_bounce_or_complained AS aws_bounce_or_complained_47, t0.public_profile AS public_profile_48, t0.is_online AS is_online_49, t0.real_is_online AS real_is_online_50, t0.has_unread_alerts AS has_unread_alerts_51, t0.has_unseen_profile_views AS has_unseen_profile_views_52, t0.total_nbr_unseen_profile_views AS total_nbr_unseen_profile_views_53, t0.package_name AS package_name_54, t0.package_expires_on AS package_expires_on_55, t0.package_last_payment_made_on AS package_last_payment_made_on_56, t0.package_next_payment_due_on AS package_next_payment_due_on_57, t0.package_cancellation_mail_sent_on AS package_cancellation_mail_sent_on_58, t0.credits AS credits_59, t0.bonus_credits AS bonus_credits_60, t0.number_of_approved_friend_requests AS number_of_approved_friend_requests_61, t0.number_of_photo_likes_sent AS number_of_photo_likes_sent_62, t0.number_of_photo_comments_sent AS number_of_photo_comments_sent_63, t0.number_of_video_likes_sent AS number_of_video_likes_sent_64, t0.number_of_video_comments_sent AS number_of_video_comments_sent_65, t0.number_of_messages_sent AS number_of_messages_sent_66, t0.number_of_voice_calls_made AS number_of_voice_calls_made_67, t0.number_of_video_calls_made AS number_of_video_calls_made_68, t0.phone_number AS phone_number_69, t0.has_unread_messages AS has_unread_messages_70, t0.has_unread_friend_requests AS has_unread_friend_requests_71, t0.has_unread_profile_views AS has_unread_profile_views_72, t0.user_status AS user_status_73, t0.user_status_interval_start AS user_status_interval_start_74, t0.user_status_interval_end AS user_status_interval_end_75, t0.updated_at_by_alert AS updated_at_by_alert_76, t0.from_landing_page AS from_landing_page_77, t0.nbr_contacts_imported AS nbr_contacts_imported_78, t0.has_agreed_to_waive_rights AS has_agreed_to_waive_rights_79, t0.is_in_call AS is_in_call_80, t0.default_ordering AS default_ordering_81, t0.tour_completed AS tour_completed_82, t0.should_open_tour AS should_open_tour_83, t0.profile_complete_photo_upload AS profile_complete_photo_upload_84, t0.profile_complete_made_friends AS profile_complete_made_friends_85, t0.profile_complete_liked_photo AS profile_complete_liked_photo_86, t0.profile_complete_sent_message AS profile_complete_sent_message_87, t0.should_be_unsubscribed_according_to_gdpr AS should_be_unsubscribed_according_to_gdpr_88, t0.pin_code AS pin_code_89, t0.invite AS invite_90, t0.s_mode AS s_mode_91, t0.ban_payment AS ban_payment_92, t0.created_at AS created_at_93, t0.updated_at AS updated_at_94, t0.invite_updated_by AS invite_updated_by_95, t0.can_comment_or_chat AS can_comment_or_chat_96, t0.email_validation_hook AS email_validation_hook_97, t0.profile_boosted AS profile_boosted_98, t0.boosted_at AS boosted_at_99, t0.head_users AS head_users_100, t0.traffic_pool_campaigns AS traffic_pool_campaigns_101, t0.invite_updated_at AS invite_updated_at_102, t0.extend_period_signup_confirmation AS extend_period_signup_confirmation_103, t104.id AS id_105, t104.customer_id AS customer_id_106, t104.created_at AS created_at_107, t104.updated_at AS updated_at_108, t104.user_reference_id AS user_reference_id_109, t110.id AS id_111, t110.customer_id AS customer_id_112, t110.created_at AS created_at_113, t110.user_reference AS user_reference_114, t115.id AS id_116, t115.user_ip AS user_ip_117, t115.continent_code AS continent_code_118, t115.continent_name AS continent_name_119, t115.country_code AS country_code_120, t115.country_name AS country_name_121, t115.region_code AS region_code_122, t115.region_name AS region_name_123, t115.city_geo_name_id AS city_geo_name_id_124, t115.city AS city_125, t115.postal_code AS postal_code_126, t115.latitude AS latitude_127, t115.longitude AS longitude_128, t115.languages AS languages_129, t115.currency AS currency_130, t115.timezone AS timezone_131, t115.user_agent AS user_agent_132, t115.connection AS connection_133, t115.security AS security_134, t115.created_at AS created_at_135, t115.updated_at AS updated_at_136, t115.user_id AS user_id_137, t115.new_location_id AS new_location_id_138, t0.owner_id AS owner_id_139, t0.leader_id AS leader_id_140, t0.packages_list_id AS packages_list_id_141, t0.image_id AS image_id_142, t0.cover_image_id AS cover_image_id_143, t0.location_id AS location_id_144, t0.payment_reference_id AS payment_reference_id_145, t0.language_id AS language_id_146, t0.new_location_id AS new_location_id_147 FROM user t0 LEFT JOIN payment_centralPay_customers2 t104 ON t104.user_reference_id = t0.id LEFT JOIN payment_centralPay_customers t110 ON t110.user_reference = t0.id LEFT JOIN history_apiip t115 ON t115.user_id = t0.id WHERE t0.username = 'user1' LIMIT 1;

SELECT 
  i0_.id AS id_0, 
  i0_.filename AS filename_1, 
  i0_.mime_type AS mime_type_2, 
  i0_.original_filename AS original_filename_3, 
  i0_.hash AS hash_4, 
  i0_.width AS width_5, 
  i0_.height AS height_6, 
  i0_.is_main AS is_main_7, 
  i0_.is_private AS is_private_8, 
  i0_.number_of_views AS number_of_views_9, 
  i0_.number_of_comments AS number_of_comments_10, 
  i0_.number_of_likes AS number_of_likes_11, 
  i0_.should_be_hidden AS should_be_hidden_12, 
  i0_.is_deleted AS is_deleted_13, 
  i0_.created_at AS created_at_14, 
  i0_.updated_at AS updated_at_15, 
  i0_.from_user_id AS from_user_id_16, 
  i0_.album_id AS album_id_17 
FROM 
  image i0_ 
WHERE 
  i0_.from_user_id = ? 
  AND i0_.is_deleted = 0 
  AND i0_.should_be_hidden = 0 
ORDER BY 
  i0_.created_at DESC 
LIMIT 
  3

SELECT i0_.id AS id_0, i0_.filename AS filename_1, i0_.mime_type AS mime_type_2, i0_.original_filename AS original_filename_3, i0_.hash AS hash_4, i0_.width AS width_5, i0_.height AS height_6, i0_.is_main AS is_main_7, i0_.is_private AS is_private_8, i0_.number_of_views AS number_of_views_9, i0_.number_of_comments AS number_of_comments_10, i0_.number_of_likes AS number_of_likes_11, i0_.should_be_hidden AS should_be_hidden_12, i0_.is_deleted AS is_deleted_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.from_user_id AS from_user_id_16, i0_.album_id AS album_id_17 FROM image i0_ WHERE i0_.from_user_id = 10 AND i0_.is_deleted = 0 AND i0_.should_be_hidden = 0 ORDER BY i0_.created_at DESC LIMIT 3;

SELECT 
  u0_.username AS username_0, 
  u0_.username_canonical AS username_canonical_1, 
  u0_.email AS email_2, 
  u0_.email_canonical AS email_canonical_3, 
  u0_.enabled AS enabled_4, 
  u0_.salt AS salt_5, 
  u0_.password AS password_6, 
  u0_.last_login AS last_login_7, 
  u0_.confirmation_token AS confirmation_token_8, 
  u0_.password_requested_at AS password_requested_at_9, 
  u0_.roles AS roles_10, 
  u0_.id AS id_11, 
  u0_.first_name AS first_name_12, 
  u0_.last_name AS last_name_13, 
  u0_.gender AS gender_14, 
  u0_.notified_for_finalise_account AS notified_for_finalise_account_15, 
  u0_.birthday AS birthday_16, 
  u0_.is_fake AS is_fake_17, 
  u0_.from_sentsio AS from_sentsio_18, 
  u0_.profile_slug AS profile_slug_19, 
  u0_.number_logins AS number_logins_20, 
  u0_.login_dates AS login_dates_21, 
  u0_.last_activity AS last_activity_22, 
  u0_.number_conversions AS number_conversions_23, 
  u0_.number_fake_users AS number_fake_users_24, 
  u0_.profile_views AS profile_views_25, 
  u0_.confirmed AS confirmed_26, 
  u0_.last_registration_step AS last_registration_step_27, 
  u0_.address AS address_28, 
  u0_.relationship_status AS relationship_status_29, 
  u0_.workplace AS workplace_30, 
  u0_.short_bio AS short_bio_31, 
  u0_.interested_in_long AS interested_in_long_32, 
  u0_.motto AS motto_33, 
  u0_.number_of_friends AS number_of_friends_34, 
  u0_.number_of_photos AS number_of_photos_35, 
  u0_.number_of_videos AS number_of_videos_36, 
  u0_.number_of_albums AS number_of_albums_37, 
  u0_.receive_email_notification_friend_request AS receive_email_notification_friend_request_38, 
  u0_.receive_email_notification_comment_photo AS receive_email_notification_comment_photo_39, 
  u0_.receive_email_notification_like_photo AS receive_email_notification_like_photo_40, 
  u0_.receive_email_notification_other_user_comment_photo AS receive_email_notification_other_user_comment_photo_41, 
  u0_.receive_email_notification_missed_messages AS receive_email_notification_missed_messages_42, 
  u0_.receive_email_notification_promotions AS receive_email_notification_promotions_43, 
  u0_.locked AS locked_44, 
  u0_.receive_email_notifications AS receive_email_notifications_45, 
  u0_.aws_bounce_or_complained AS aws_bounce_or_complained_46, 
  u0_.public_profile AS public_profile_47, 
  u0_.is_online AS is_online_48, 
  u0_.real_is_online AS real_is_online_49, 
  u0_.has_unread_alerts AS has_unread_alerts_50, 
  u0_.has_unseen_profile_views AS has_unseen_profile_views_51, 
  u0_.total_nbr_unseen_profile_views AS total_nbr_unseen_profile_views_52, 
  u0_.package_name AS package_name_53, 
  u0_.package_expires_on AS package_expires_on_54, 
  u0_.package_last_payment_made_on AS package_last_payment_made_on_55, 
  u0_.package_next_payment_due_on AS package_next_payment_due_on_56, 
  u0_.package_cancellation_mail_sent_on AS package_cancellation_mail_sent_on_57, 
  u0_.credits AS credits_58, 
  u0_.bonus_credits AS bonus_credits_59, 
  u0_.number_of_approved_friend_requests AS number_of_approved_friend_requests_60, 
  u0_.number_of_photo_likes_sent AS number_of_photo_likes_sent_61, 
  u0_.number_of_photo_comments_sent AS number_of_photo_comments_sent_62, 
  u0_.number_of_video_likes_sent AS number_of_video_likes_sent_63, 
  u0_.number_of_video_comments_sent AS number_of_video_comments_sent_64, 
  u0_.number_of_messages_sent AS number_of_messages_sent_65, 
  u0_.number_of_voice_calls_made AS number_of_voice_calls_made_66, 
  u0_.number_of_video_calls_made AS number_of_video_calls_made_67, 
  u0_.phone_number AS phone_number_68, 
  u0_.has_unread_messages AS has_unread_messages_69, 
  u0_.has_unread_friend_requests AS has_unread_friend_requests_70, 
  u0_.has_unread_profile_views AS has_unread_profile_views_71, 
  u0_.user_status AS user_status_72, 
  u0_.user_status_interval_start AS user_status_interval_start_73, 
  u0_.user_status_interval_end AS user_status_interval_end_74, 
  u0_.updated_at_by_alert AS updated_at_by_alert_75, 
  u0_.from_landing_page AS from_landing_page_76, 
  u0_.nbr_contacts_imported AS nbr_contacts_imported_77, 
  u0_.has_agreed_to_waive_rights AS has_agreed_to_waive_rights_78, 
  u0_.is_in_call AS is_in_call_79, 
  u0_.default_ordering AS default_ordering_80, 
  u0_.tour_completed AS tour_completed_81, 
  u0_.should_open_tour AS should_open_tour_82, 
  u0_.profile_complete_photo_upload AS profile_complete_photo_upload_83, 
  u0_.profile_complete_made_friends AS profile_complete_made_friends_84, 
  u0_.profile_complete_liked_photo AS profile_complete_liked_photo_85, 
  u0_.profile_complete_sent_message AS profile_complete_sent_message_86, 
  u0_.should_be_unsubscribed_according_to_gdpr AS should_be_unsubscribed_according_to_gdpr_87, 
  u0_.pin_code AS pin_code_88, 
  u0_.invite AS invite_89, 
  u0_.s_mode AS s_mode_90, 
  u0_.ban_payment AS ban_payment_91, 
  u0_.created_at AS created_at_92, 
  u0_.updated_at AS updated_at_93, 
  u0_.invite_updated_by AS invite_updated_by_94, 
  u0_.can_comment_or_chat AS can_comment_or_chat_95, 
  u0_.email_validation_hook AS email_validation_hook_96, 
  u0_.profile_boosted AS profile_boosted_97, 
  u0_.boosted_at AS boosted_at_98, 
  u0_.head_users AS head_users_99, 
  u0_.traffic_pool_campaigns AS traffic_pool_campaigns_100, 
  u0_.invite_updated_at AS invite_updated_at_101, 
  u0_.extend_period_signup_confirmation AS extend_period_signup_confirmation_102, 
  u0_.owner_id AS owner_id_103, 
  u0_.leader_id AS leader_id_104, 
  u0_.packages_list_id AS packages_list_id_105, 
  u0_.image_id AS image_id_106, 
  u0_.cover_image_id AS cover_image_id_107, 
  u0_.location_id AS location_id_108, 
  u0_.payment_reference_id AS payment_reference_id_109, 
  u0_.language_id AS language_id_110, 
  u0_.new_location_id AS new_location_id_111 
FROM 
  user u0_ 
WHERE 
  u0_.profile_boosted = 1 
  AND u0_.boosted_at >= ? 
  AND u0_.image_id IS NOT NULL 
ORDER BY 
  RAND() ASC, 
  u0_.number_of_photos DESC, 
  u0_.number_of_friends DESC, 
  u0_.number_logins DESC, 
  u0_.image_id DESC 
LIMIT 
  4

SELECT u0_.username AS username_0, u0_.username_canonical AS username_canonical_1, u0_.email AS email_2, u0_.email_canonical AS email_canonical_3, u0_.enabled AS enabled_4, u0_.salt AS salt_5, u0_.password AS password_6, u0_.last_login AS last_login_7, u0_.confirmation_token AS confirmation_token_8, u0_.password_requested_at AS password_requested_at_9, u0_.roles AS roles_10, u0_.id AS id_11, u0_.first_name AS first_name_12, u0_.last_name AS last_name_13, u0_.gender AS gender_14, u0_.notified_for_finalise_account AS notified_for_finalise_account_15, u0_.birthday AS birthday_16, u0_.is_fake AS is_fake_17, u0_.from_sentsio AS from_sentsio_18, u0_.profile_slug AS profile_slug_19, u0_.number_logins AS number_logins_20, u0_.login_dates AS login_dates_21, u0_.last_activity AS last_activity_22, u0_.number_conversions AS number_conversions_23, u0_.number_fake_users AS number_fake_users_24, u0_.profile_views AS profile_views_25, u0_.confirmed AS confirmed_26, u0_.last_registration_step AS last_registration_step_27, u0_.address AS address_28, u0_.relationship_status AS relationship_status_29, u0_.workplace AS workplace_30, u0_.short_bio AS short_bio_31, u0_.interested_in_long AS interested_in_long_32, u0_.motto AS motto_33, u0_.number_of_friends AS number_of_friends_34, u0_.number_of_photos AS number_of_photos_35, u0_.number_of_videos AS number_of_videos_36, u0_.number_of_albums AS number_of_albums_37, u0_.receive_email_notification_friend_request AS receive_email_notification_friend_request_38, u0_.receive_email_notification_comment_photo AS receive_email_notification_comment_photo_39, u0_.receive_email_notification_like_photo AS receive_email_notification_like_photo_40, u0_.receive_email_notification_other_user_comment_photo AS receive_email_notification_other_user_comment_photo_41, u0_.receive_email_notification_missed_messages AS receive_email_notification_missed_messages_42, u0_.receive_email_notification_promotions AS receive_email_notification_promotions_43, u0_.locked AS locked_44, u0_.receive_email_notifications AS receive_email_notifications_45, u0_.aws_bounce_or_complained AS aws_bounce_or_complained_46, u0_.public_profile AS public_profile_47, u0_.is_online AS is_online_48, u0_.real_is_online AS real_is_online_49, u0_.has_unread_alerts AS has_unread_alerts_50, u0_.has_unseen_profile_views AS has_unseen_profile_views_51, u0_.total_nbr_unseen_profile_views AS total_nbr_unseen_profile_views_52, u0_.package_name AS package_name_53, u0_.package_expires_on AS package_expires_on_54, u0_.package_last_payment_made_on AS package_last_payment_made_on_55, u0_.package_next_payment_due_on AS package_next_payment_due_on_56, u0_.package_cancellation_mail_sent_on AS package_cancellation_mail_sent_on_57, u0_.credits AS credits_58, u0_.bonus_credits AS bonus_credits_59, u0_.number_of_approved_friend_requests AS number_of_approved_friend_requests_60, u0_.number_of_photo_likes_sent AS number_of_photo_likes_sent_61, u0_.number_of_photo_comments_sent AS number_of_photo_comments_sent_62, u0_.number_of_video_likes_sent AS number_of_video_likes_sent_63, u0_.number_of_video_comments_sent AS number_of_video_comments_sent_64, u0_.number_of_messages_sent AS number_of_messages_sent_65, u0_.number_of_voice_calls_made AS number_of_voice_calls_made_66, u0_.number_of_video_calls_made AS number_of_video_calls_made_67, u0_.phone_number AS phone_number_68, u0_.has_unread_messages AS has_unread_messages_69, u0_.has_unread_friend_requests AS has_unread_friend_requests_70, u0_.has_unread_profile_views AS has_unread_profile_views_71, u0_.user_status AS user_status_72, u0_.user_status_interval_start AS user_status_interval_start_73, u0_.user_status_interval_end AS user_status_interval_end_74, u0_.updated_at_by_alert AS updated_at_by_alert_75, u0_.from_landing_page AS from_landing_page_76, u0_.nbr_contacts_imported AS nbr_contacts_imported_77, u0_.has_agreed_to_waive_rights AS has_agreed_to_waive_rights_78, u0_.is_in_call AS is_in_call_79, u0_.default_ordering AS default_ordering_80, u0_.tour_completed AS tour_completed_81, u0_.should_open_tour AS should_open_tour_82, u0_.profile_complete_photo_upload AS profile_complete_photo_upload_83, u0_.profile_complete_made_friends AS profile_complete_made_friends_84, u0_.profile_complete_liked_photo AS profile_complete_liked_photo_85, u0_.profile_complete_sent_message AS profile_complete_sent_message_86, u0_.should_be_unsubscribed_according_to_gdpr AS should_be_unsubscribed_according_to_gdpr_87, u0_.pin_code AS pin_code_88, u0_.invite AS invite_89, u0_.s_mode AS s_mode_90, u0_.ban_payment AS ban_payment_91, u0_.created_at AS created_at_92, u0_.updated_at AS updated_at_93, u0_.invite_updated_by AS invite_updated_by_94, u0_.can_comment_or_chat AS can_comment_or_chat_95, u0_.email_validation_hook AS email_validation_hook_96, u0_.profile_boosted AS profile_boosted_97, u0_.boosted_at AS boosted_at_98, u0_.head_users AS head_users_99, u0_.traffic_pool_campaigns AS traffic_pool_campaigns_100, u0_.invite_updated_at AS invite_updated_at_101, u0_.extend_period_signup_confirmation AS extend_period_signup_confirmation_102, u0_.owner_id AS owner_id_103, u0_.leader_id AS leader_id_104, u0_.packages_list_id AS packages_list_id_105, u0_.image_id AS image_id_106, u0_.cover_image_id AS cover_image_id_107, u0_.location_id AS location_id_108, u0_.payment_reference_id AS payment_reference_id_109, u0_.language_id AS language_id_110, u0_.new_location_id AS new_location_id_111 FROM user u0_ WHERE u0_.profile_boosted = 1 AND u0_.boosted_at >= '2024-09-19 09:52:02' AND u0_.image_id IS NOT NULL ORDER BY RAND() ASC, u0_.number_of_photos DESC, u0_.number_of_friends DESC, u0_.number_logins DESC, u0_.image_id DESC LIMIT 4;

SELECT 
  t0.id AS id_1, 
  t0.type AS type_2, 
  t0.action AS action_3, 
  t0.active AS active_4, 
  t0.value AS value_5, 
  t0.packages AS packages_6, 
  t0.created_at AS created_at_7, 
  t0.updated_at AS updated_at_8 
FROM 
  media_setting t0 
WHERE 
  t0.type = ? 
  AND t0.action = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.action AS action_3, t0.active AS active_4, t0.value AS value_5, t0.packages AS packages_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM media_setting t0 WHERE t0.type = 'Image' AND t0.action = 'Content For Packages Upgrade Modal' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.type AS type_2, 
  t0.value AS value_3, 
  t0.packages AS packages_4, 
  t0.active AS active_5, 
  t0.created_at AS created_at_6, 
  t0.updated_at AS updated_at_7 
FROM 
  boost_profile_setting t0 
WHERE 
  t0.type = ? 
  AND t0.active = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.packages AS packages_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM boost_profile_setting t0 WHERE t0.type = 'Display Boost Modal Automatic Time In Seconds' AND t0.active = 1 LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.code AS code_2, 
  t0.title AS title_3, 
  t0.menu_icon AS menu_icon_4, 
  t0.slug AS slug_5, 
  t0.content AS content_6, 
  t0.active AS active_7, 
  t0.active_until AS active_until_8, 
  t0.created_at AS created_at_9, 
  t0.last_updated_at AS last_updated_at_10, 
  t0.custom_js_code AS custom_js_code_11, 
  t0.custom_css_code AS custom_css_code_12, 
  t0.created_by AS created_by_13, 
  t0.include_in_menu AS include_in_menu_14, 
  t0.last_modified_by AS last_modified_by_15, 
  t0.revision AS revision_16 
FROM 
  soc_cms_pages t0 
WHERE 
  t0.code = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.menu_icon AS menu_icon_4, t0.slug AS slug_5, t0.content AS content_6, t0.active AS active_7, t0.active_until AS active_until_8, t0.created_at AS created_at_9, t0.last_updated_at AS last_updated_at_10, t0.custom_js_code AS custom_js_code_11, t0.custom_css_code AS custom_css_code_12, t0.created_by AS created_by_13, t0.include_in_menu AS include_in_menu_14, t0.last_modified_by AS last_modified_by_15, t0.revision AS revision_16 FROM soc_cms_pages t0 WHERE t0.code = 'social_support' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.type AS type_2, 
  t0.value AS value_3, 
  t0.packages AS packages_4, 
  t0.active AS active_5, 
  t0.created_at AS created_at_6, 
  t0.updated_at AS updated_at_7 
FROM 
  boost_profile_setting t0 
WHERE 
  t0.type = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.packages AS packages_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM boost_profile_setting t0 WHERE t0.type = 'Display Boosted Profile in Hours' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.code AS code_2, 
  t0.title AS title_3, 
  t0.menu_icon AS menu_icon_4, 
  t0.slug AS slug_5, 
  t0.content AS content_6, 
  t0.active AS active_7, 
  t0.active_until AS active_until_8, 
  t0.created_at AS created_at_9, 
  t0.last_updated_at AS last_updated_at_10, 
  t0.custom_js_code AS custom_js_code_11, 
  t0.custom_css_code AS custom_css_code_12, 
  t0.created_by AS created_by_13, 
  t0.include_in_menu AS include_in_menu_14, 
  t0.last_modified_by AS last_modified_by_15, 
  t0.revision AS revision_16 
FROM 
  soc_cms_pages t0 
WHERE 
  t0.include_in_menu = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.menu_icon AS menu_icon_4, t0.slug AS slug_5, t0.content AS content_6, t0.active AS active_7, t0.active_until AS active_until_8, t0.created_at AS created_at_9, t0.last_updated_at AS last_updated_at_10, t0.custom_js_code AS custom_js_code_11, t0.custom_css_code AS custom_css_code_12, t0.created_by AS created_by_13, t0.include_in_menu AS include_in_menu_14, t0.last_modified_by AS last_modified_by_15, t0.revision AS revision_16 FROM soc_cms_pages t0 WHERE t0.include_in_menu = 1;

SELECT 
  count(u0_.id) AS sclr_0 
FROM 
  user u0_ 
WHERE 
  (
    (
      u0_.roles = ? 
      OR u0_.roles = ?
    )
  ) 
  AND u0_.enabled = ? 
  AND u0_.confirmed = ? 
  AND u0_.is_online = ?

SELECT count(u0_.id) AS sclr_0 FROM user u0_ WHERE ((u0_.roles = 'a:1:{i:0;s:9:\"ROLE_USER\";}' OR u0_.roles = 'a:0:{}')) AND u0_.enabled = 1 AND u0_.confirmed = 1 AND u0_.is_online = 1;

SELECT 
  t0.id AS id_1, 
  t0.email_uuid AS email_uuid_2, 
  t0.email AS email_3, 
  t0.skype AS skype_4, 
  t0.nickname AS nickname_5, 
  t0.first_name AS first_name_6, 
  t0.last_name AS last_name_7, 
  t0.location AS location_8, 
  t0.gender AS gender_9, 
  t0.discussion AS discussion_10, 
  t0.more_details AS more_details_11, 
  t0.credentials_username AS credentials_username_12, 
  t0.credentials_password AS credentials_password_13, 
  t0.email_obtained_from_flag AS email_obtained_from_flag_14, 
  t0.user_dificil AS user_dificil_15, 
  t0.added_in_sentsio AS added_in_sentsio_16, 
  t0.created_at AS created_at_17, 
  t0.updated_at AS updated_at_18, 
  t0.email_site_source_id AS email_site_source_id_19, 
  t0.from_user_id AS from_user_id_20, 
  t0.profile_lp_id AS profile_lp_id_21, 
  t0.to_user_id AS to_user_id_22, 
  t0.signed_up_user_id AS signed_up_user_id_23, 
  t0.profile_sent_id AS profile_sent_id_24, 
  t0.email_list_status_id AS email_list_status_id_25, 
  t0.email_language_id AS email_language_id_26 
FROM 
  email_list t0 
WHERE 
  t0.from_user_id = ?

SELECT t0.id AS id_1, t0.email_uuid AS email_uuid_2, t0.email AS email_3, t0.skype AS skype_4, t0.nickname AS nickname_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.location AS location_8, t0.gender AS gender_9, t0.discussion AS discussion_10, t0.more_details AS more_details_11, t0.credentials_username AS credentials_username_12, t0.credentials_password AS credentials_password_13, t0.email_obtained_from_flag AS email_obtained_from_flag_14, t0.user_dificil AS user_dificil_15, t0.added_in_sentsio AS added_in_sentsio_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.email_site_source_id AS email_site_source_id_19, t0.from_user_id AS from_user_id_20, t0.profile_lp_id AS profile_lp_id_21, t0.to_user_id AS to_user_id_22, t0.signed_up_user_id AS signed_up_user_id_23, t0.profile_sent_id AS profile_sent_id_24, t0.email_list_status_id AS email_list_status_id_25, t0.email_language_id AS email_language_id_26 FROM email_list t0 WHERE t0.from_user_id = 10;

SELECT 
  i0_.id AS id_0, 
  i0_.filename AS filename_1, 
  i0_.mime_type AS mime_type_2, 
  i0_.original_filename AS original_filename_3, 
  i0_.hash AS hash_4, 
  i0_.width AS width_5, 
  i0_.height AS height_6, 
  i0_.is_main AS is_main_7, 
  i0_.is_private AS is_private_8, 
  i0_.number_of_views AS number_of_views_9, 
  i0_.number_of_comments AS number_of_comments_10, 
  i0_.number_of_likes AS number_of_likes_11, 
  i0_.should_be_hidden AS should_be_hidden_12, 
  i0_.is_deleted AS is_deleted_13, 
  i0_.created_at AS created_at_14, 
  i0_.updated_at AS updated_at_15, 
  i0_.from_user_id AS from_user_id_16, 
  i0_.album_id AS album_id_17 
FROM 
  image i0_ 
WHERE 
  i0_.from_user_id = ? 
  AND i0_.is_deleted = 0 
  AND i0_.should_be_hidden = 0 
ORDER BY 
  i0_.created_at DESC 
LIMIT 
  50

SELECT i0_.id AS id_0, i0_.filename AS filename_1, i0_.mime_type AS mime_type_2, i0_.original_filename AS original_filename_3, i0_.hash AS hash_4, i0_.width AS width_5, i0_.height AS height_6, i0_.is_main AS is_main_7, i0_.is_private AS is_private_8, i0_.number_of_views AS number_of_views_9, i0_.number_of_comments AS number_of_comments_10, i0_.number_of_likes AS number_of_likes_11, i0_.should_be_hidden AS should_be_hidden_12, i0_.is_deleted AS is_deleted_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.from_user_id AS from_user_id_16, i0_.album_id AS album_id_17 FROM image i0_ WHERE i0_.from_user_id = 10 AND i0_.is_deleted = 0 AND i0_.should_be_hidden = 0 ORDER BY i0_.created_at DESC LIMIT 50;