Query Metrics
4
Database Queries
3
Different statements
1.42 ms
Query time
1
Invalid entities
Queries
#▲ | 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 |
|
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. |