Query Metrics

4 Database Queries
3 Different statements
1.42 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.90 ms
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.is_set_location_by_user AS is_set_location_by_user_47, t0.aws_bounce_or_complained AS aws_bounce_or_complained_48, t0.public_profile AS public_profile_49, t0.is_online AS is_online_50, t0.real_is_online AS real_is_online_51, t0.has_unread_alerts AS has_unread_alerts_52, t0.has_unseen_profile_views AS has_unseen_profile_views_53, t0.total_nbr_unseen_profile_views AS total_nbr_unseen_profile_views_54, t0.package_name AS package_name_55, t0.package_expires_on AS package_expires_on_56, t0.package_last_payment_made_on AS package_last_payment_made_on_57, t0.package_next_payment_due_on AS package_next_payment_due_on_58, t0.package_cancellation_mail_sent_on AS package_cancellation_mail_sent_on_59, t0.credits AS credits_60, t0.bonus_credits AS bonus_credits_61, t0.number_of_approved_friend_requests AS number_of_approved_friend_requests_62, t0.number_of_photo_likes_sent AS number_of_photo_likes_sent_63, t0.number_of_photo_comments_sent AS number_of_photo_comments_sent_64, t0.number_of_video_likes_sent AS number_of_video_likes_sent_65, t0.number_of_video_comments_sent AS number_of_video_comments_sent_66, t0.number_of_messages_sent AS number_of_messages_sent_67, t0.number_of_voice_calls_made AS number_of_voice_calls_made_68, t0.number_of_video_calls_made AS number_of_video_calls_made_69, t0.phone_number AS phone_number_70, t0.has_unread_messages AS has_unread_messages_71, t0.has_unread_friend_requests AS has_unread_friend_requests_72, t0.has_unread_profile_views AS has_unread_profile_views_73, t0.user_status AS user_status_74, t0.user_status_interval_start AS user_status_interval_start_75, t0.user_status_interval_end AS user_status_interval_end_76, t0.updated_at_by_alert AS updated_at_by_alert_77, t0.from_landing_page AS from_landing_page_78, t0.nbr_contacts_imported AS nbr_contacts_imported_79, t0.has_agreed_to_waive_rights AS has_agreed_to_waive_rights_80, t0.is_in_call AS is_in_call_81, t0.default_ordering AS default_ordering_82, t0.tour_completed AS tour_completed_83, t0.should_open_tour AS should_open_tour_84, t0.profile_complete_photo_upload AS profile_complete_photo_upload_85, t0.profile_complete_made_friends AS profile_complete_made_friends_86, t0.profile_complete_liked_photo AS profile_complete_liked_photo_87, t0.profile_complete_sent_message AS profile_complete_sent_message_88, t0.should_be_unsubscribed_according_to_gdpr AS should_be_unsubscribed_according_to_gdpr_89, t0.pin_code AS pin_code_90, t0.invite AS invite_91, t0.s_mode AS s_mode_92, t0.ban_payment AS ban_payment_93, t0.created_at AS created_at_94, t0.updated_at AS updated_at_95, t0.invite_updated_by AS invite_updated_by_96, t0.can_comment_or_chat AS can_comment_or_chat_97, t0.email_validation_hook AS email_validation_hook_98, t0.profile_boosted AS profile_boosted_99, t0.boosted_at AS boosted_at_100, t0.head_users AS head_users_101, t0.traffic_pool_campaigns AS traffic_pool_campaigns_102, t0.invite_updated_at AS invite_updated_at_103, t0.extend_period_signup_confirmation AS extend_period_signup_confirmation_104, t0.is_anon AS is_anon_105, t106.id AS id_107, t106.customer_id AS customer_id_108, t106.created_at AS created_at_109, t106.updated_at AS updated_at_110, t106.user_reference_id AS user_reference_id_111, t112.id AS id_113, t112.customer_id AS customer_id_114, t112.created_at AS created_at_115, t112.user_reference AS user_reference_116, t117.id AS id_118, t117.user_ip AS user_ip_119, t117.continent_code AS continent_code_120, t117.continent_name AS continent_name_121, t117.country_code AS country_code_122, t117.country_name AS country_name_123, t117.region_code AS region_code_124, t117.region_name AS region_name_125, t117.city_geo_name_id AS city_geo_name_id_126, t117.city AS city_127, t117.postal_code AS postal_code_128, t117.latitude AS latitude_129, t117.longitude AS longitude_130, t117.languages AS languages_131, t117.currency AS currency_132, t117.timezone AS timezone_133, t117.user_agent AS user_agent_134, t117.connection AS connection_135, t117.security AS security_136, t117.created_at AS created_at_137, t117.updated_at AS updated_at_138, t117.user_id AS user_id_139, t117.new_location_id AS new_location_id_140, t0.owner_id AS owner_id_141, t0.leader_id AS leader_id_142, t0.packages_list_id AS packages_list_id_143, t0.image_id AS image_id_144, t0.cover_image_id AS cover_image_id_145, t0.location_id AS location_id_146, t0.language_id AS language_id_147, t0.new_location_id AS new_location_id_148, t0.traffic_pool_id AS traffic_pool_id_149 FROM user t0 LEFT JOIN payment_centralPay_customers2 t106 ON t106.user_reference_id = t0.id LEFT JOIN payment_centralPay_customers t112 ON t112.user_reference = t0.id LEFT JOIN history_apiip t117 ON t117.user_id = t0.id WHERE t0.username = ? LIMIT 1
Parameters:
[
  "newfake5"
]
2 0.23 ms
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 = ?
Parameters:
[
  73
]
3 0.20 ms
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
Parameters:
[
  "Display Boost Modal Automatic Time In Seconds"
  1
]
4 0.09 ms
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
Parameters:
[
  "Activate The Boost Profile Functionality"
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
FOS\UserBundle\Model\User No errors.
Social\UserBundle\Entity\User No errors.
Social\FrontendBundle\Entity\Relationship No errors.
Social\InternalBundle\Entity\CentralPayPayment\CPCustomersEntity No errors.
Social\InternalBundle\Entity\CentralPayCustomersEntity No errors.
Social\FrontendBundle\Entity\HistoryApiip No errors.
Social\FrontendBundle\Entity\NewLocation No errors.
Social\InternalBundle\Entity\PackagesList No errors.
Social\FrontendBundle\Entity\Image No errors.
Social\FrontendBundle\Entity\Location No errors.
Social\InternalBundle\Entity\Language No errors.
Social\InternalBundle\Entity\TrafficPool No errors.
Social\InternalBundle\Entity\PaymentsBanEntity No errors.
Social\UserBundle\Entity\UserComponents\UserSignupPollData No errors.
Social\InternalBundle\Entity\EmailList
  • The association Social\InternalBundle\Entity\EmailList#emailLanguage refers to the inverse side field Social\InternalBundle\Entity\Language#emailLists which does not exist.
Social\InternalBundle\Entity\EmailSiteSource No errors.
Social\InternalBundle\Entity\EmailListStatus No errors.
Social\FrontendBundle\Entity\Album No errors.
Social\FrontendBundle\Entity\Audio No errors.
Social\FrontendBundle\Entity\Video No errors.
Social\InternalBundle\Entity\BannedCardsEntity No errors.
Social\FrontendBundle\Entity\ImageComment No errors.
Social\FrontendBundle\Entity\ImageLike No errors.
Social\FrontendBundle\Entity\VideoComment No errors.
Social\FrontendBundle\Entity\VideoLike No errors.
Social\UserBundle\Entity\UserChatConnection No errors.
Social\FrontendBundle\Entity\Alert No errors.
Social\FrontendBundle\Entity\Message No errors.
Social\FrontendBundle\Entity\Payment No errors.
Social\UserBundle\Entity\UserInterestedIn No errors.
Social\FrontendBundle\Entity\OpenTokSession No errors.
Social\InternalBundle\Entity\PaymentEntity No errors.
Social\CreditsBundle\Entity\CreditUserHistoryEntity No errors.
Social\CreditsBundle\Entity\CreditRefundRequestsEntity No errors.
Social\InternalBundle\Entity\CentralPayPaymentsEntity No errors.
Social\InternalBundle\Entity\CentralPayInstallmentsEntity No errors.
Social\InternalBundle\Entity\AdminAlertsEntity No errors.
Social\InternalBundle\Entity\MemberReport No errors.
Social\InternalBundle\Entity\TrafficPoolUsers No errors.
Social\InternalBundle\Entity\EmailSpamReportsEntity No errors.
Social\InternalBundle\Entity\SentsioApiDetail No errors.
Social\UserBundle\Entity\UserTracking No errors.
Social\UserBundle\Entity\UserBlockingQueue No errors.
Social\InternalBundle\Entity\BoostProfileSetting No errors.