Query Metrics
4
Database Queries
3
Different statements
1.26 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.78 ms (61.47%) |
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 = ? LIMIT 1
Parameters:
[
"user1"
]
|
0.29 ms (22.76%) |
2 |
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 ] |
0.20 ms (15.77%) |
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 = ?
Parameters:
[
10
]
|
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\FrontendBundle\Entity\PaymentReference | No errors. |
Social\InternalBundle\Entity\Language | No errors. |
Social\InternalBundle\Entity\PaymentsBanEntity | No errors. |
Social\UserBundle\Entity\UserComponents\UserSignupPollData | No errors. |
Social\InternalBundle\Entity\EmailList |
|
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\FrontendBundle\Entity\PscConfirmationPayment | 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\TrafficPool | No errors. |
Social\InternalBundle\Entity\BoostProfileSetting | No errors. |