Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.type AS type_2, 
  t0.language AS language_3, 
  t0.active AS active_4, 
  t0.created_at AS created_at_5, 
  t0.updated_at AS updated_at_6 
FROM 
  language_setting t0 
WHERE 
  t0.type = ? 
  AND t0.active = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.language AS language_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM language_setting t0 WHERE t0.type = 'From User Browser Language' AND t0.active = 1 LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.type AS type_2, 
  t0.language AS language_3, 
  t0.active AS active_4, 
  t0.created_at AS created_at_5, 
  t0.updated_at AS updated_at_6 
FROM 
  language_setting t0 
WHERE 
  t0.type = ? 
  AND t0.active = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.language AS language_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM language_setting t0 WHERE t0.type = 'From APIIP' AND t0.active = 1 LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.type AS type_2, 
  t0.language AS language_3, 
  t0.active AS active_4, 
  t0.created_at AS created_at_5, 
  t0.updated_at AS updated_at_6 
FROM 
  language_setting t0 
WHERE 
  t0.type = ? 
  AND t0.active = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.language AS language_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM language_setting t0 WHERE t0.type = 'Set Static Language' 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.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 = 'terms_and_conditions' 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 = 'privacy' 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 
  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 
  d0_.id AS id_0, 
  d0_.title AS title_1, 
  d0_.date AS date_2, 
  d0_.from_time AS from_time_3, 
  d0_.to_time AS to_time_4, 
  d0_.user_id AS user_id_5 
FROM 
  display_user_search d0_ 
WHERE 
  d0_.date = ? 
  AND d0_.from_time <= ? 
  AND d0_.to_time >= ?

SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.date AS date_2, d0_.from_time AS from_time_3, d0_.to_time AS to_time_4, d0_.user_id AS user_id_5 FROM display_user_search d0_ WHERE d0_.date = '2024-11-13' AND d0_.from_time <= '18:09:05' AND d0_.to_time >= '18:09:05';

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_.is_anon AS is_anon_103, 
  u0_.owner_id AS owner_id_104, 
  u0_.leader_id AS leader_id_105, 
  u0_.packages_list_id AS packages_list_id_106, 
  u0_.image_id AS image_id_107, 
  u0_.cover_image_id AS cover_image_id_108, 
  u0_.location_id AS location_id_109, 
  u0_.payment_reference_id AS payment_reference_id_110, 
  u0_.language_id AS language_id_111, 
  u0_.new_location_id AS new_location_id_112 
FROM 
  user u0_ 
WHERE 
  u0_.confirmed = ? 
  AND u0_.enabled = ? 
  AND u0_.locked = ? 
  AND u0_.created_at >= ? 
  AND u0_.image_id IS NOT NULL 
  AND u0_.public_profile = ? 
ORDER BY 
  u0_.number_of_photos DESC, 
  u0_.number_of_friends DESC, 
  u0_.number_logins DESC, 
  u0_.image_id DESC, 
  RAND() ASC 
LIMIT 
  13

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_.is_anon AS is_anon_103, u0_.owner_id AS owner_id_104, u0_.leader_id AS leader_id_105, u0_.packages_list_id AS packages_list_id_106, u0_.image_id AS image_id_107, u0_.cover_image_id AS cover_image_id_108, u0_.location_id AS location_id_109, u0_.payment_reference_id AS payment_reference_id_110, u0_.language_id AS language_id_111, u0_.new_location_id AS new_location_id_112 FROM user u0_ WHERE u0_.confirmed = 1 AND u0_.enabled = 1 AND u0_.locked = 0 AND u0_.created_at >= '2024-11-06 18:09:05' AND u0_.image_id IS NOT NULL AND u0_.public_profile = 1 ORDER BY u0_.number_of_photos DESC, u0_.number_of_friends DESC, u0_.number_logins DESC, u0_.image_id DESC, RAND() ASC LIMIT 13;

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 
  d0_.id AS id_0, 
  d0_.title AS title_1, 
  d0_.date AS date_2, 
  d0_.from_time AS from_time_3, 
  d0_.to_time AS to_time_4, 
  d0_.user_id AS user_id_5 
FROM 
  display_user_search d0_ 
WHERE 
  d0_.date = ? 
  AND d0_.from_time <= ? 
  AND d0_.to_time >= ?

SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.date AS date_2, d0_.from_time AS from_time_3, d0_.to_time AS to_time_4, d0_.user_id AS user_id_5 FROM display_user_search d0_ WHERE d0_.date = '2024-11-13' AND d0_.from_time <= '18:09:05' AND d0_.to_time >= '18:09:05';

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_.is_anon AS is_anon_103, 
  u0_.owner_id AS owner_id_104, 
  u0_.leader_id AS leader_id_105, 
  u0_.packages_list_id AS packages_list_id_106, 
  u0_.image_id AS image_id_107, 
  u0_.cover_image_id AS cover_image_id_108, 
  u0_.location_id AS location_id_109, 
  u0_.payment_reference_id AS payment_reference_id_110, 
  u0_.language_id AS language_id_111, 
  u0_.new_location_id AS new_location_id_112 
FROM 
  user u0_ 
WHERE 
  u0_.confirmed = ? 
  AND u0_.enabled = ? 
  AND u0_.locked = ? 
  AND u0_.is_online = 1 
  AND u0_.image_id IS NOT NULL 
  AND u0_.public_profile = ? 
ORDER BY 
  u0_.number_of_photos DESC, 
  u0_.number_of_friends DESC, 
  u0_.number_logins DESC, 
  u0_.image_id DESC, 
  RAND() ASC 
LIMIT 
  13

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_.is_anon AS is_anon_103, u0_.owner_id AS owner_id_104, u0_.leader_id AS leader_id_105, u0_.packages_list_id AS packages_list_id_106, u0_.image_id AS image_id_107, u0_.cover_image_id AS cover_image_id_108, u0_.location_id AS location_id_109, u0_.payment_reference_id AS payment_reference_id_110, u0_.language_id AS language_id_111, u0_.new_location_id AS new_location_id_112 FROM user u0_ WHERE u0_.confirmed = 1 AND u0_.enabled = 1 AND u0_.locked = 0 AND u0_.is_online = 1 AND u0_.image_id IS NOT NULL AND u0_.public_profile = 1 ORDER BY u0_.number_of_photos DESC, u0_.number_of_friends DESC, u0_.number_logins DESC, u0_.image_id DESC, RAND() ASC LIMIT 13;

SELECT 
  t0.id AS id_1, 
  t0.customer_id AS customer_id_2, 
  t0.created_at AS created_at_3, 
  t0.updated_at AS updated_at_4, 
  t0.user_reference_id AS user_reference_id_5 
FROM 
  payment_centralPay_customers2 t0 
WHERE 
  t0.user_reference_id = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_reference_id AS user_reference_id_5 FROM payment_centralPay_customers2 t0 WHERE t0.user_reference_id = 10;

SELECT 
  t0.id AS id_1, 
  t0.customer_id AS customer_id_2, 
  t0.created_at AS created_at_3, 
  t0.user_reference AS user_reference_4 
FROM 
  payment_centralPay_customers t0 
WHERE 
  t0.user_reference = ?

SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.created_at AS created_at_3, t0.user_reference AS user_reference_4 FROM payment_centralPay_customers t0 WHERE t0.user_reference = 10;

SELECT 
  t0.id AS id_1, 
  t0.user_ip AS user_ip_2, 
  t0.continent_code AS continent_code_3, 
  t0.continent_name AS continent_name_4, 
  t0.country_code AS country_code_5, 
  t0.country_name AS country_name_6, 
  t0.region_code AS region_code_7, 
  t0.region_name AS region_name_8, 
  t0.city_geo_name_id AS city_geo_name_id_9, 
  t0.city AS city_10, 
  t0.postal_code AS postal_code_11, 
  t0.latitude AS latitude_12, 
  t0.longitude AS longitude_13, 
  t0.languages AS languages_14, 
  t0.currency AS currency_15, 
  t0.timezone AS timezone_16, 
  t0.user_agent AS user_agent_17, 
  t0.connection AS connection_18, 
  t0.security AS security_19, 
  t0.created_at AS created_at_20, 
  t0.updated_at AS updated_at_21, 
  t0.user_id AS user_id_22, 
  t0.new_location_id AS new_location_id_23 
FROM 
  history_apiip t0 
WHERE 
  t0.user_id = ?

SELECT t0.id AS id_1, t0.user_ip AS user_ip_2, t0.continent_code AS continent_code_3, t0.continent_name AS continent_name_4, t0.country_code AS country_code_5, t0.country_name AS country_name_6, t0.region_code AS region_code_7, t0.region_name AS region_name_8, t0.city_geo_name_id AS city_geo_name_id_9, t0.city AS city_10, t0.postal_code AS postal_code_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.languages AS languages_14, t0.currency AS currency_15, t0.timezone AS timezone_16, t0.user_agent AS user_agent_17, t0.connection AS connection_18, t0.security AS security_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.user_id AS user_id_22, t0.new_location_id AS new_location_id_23 FROM history_apiip t0 WHERE t0.user_id = 10;