http://api.mmpz.myclientzone.com/api/v1/profile/416/earning-songs

Query Metrics

11 Database Queries
7 Different statements
89.61 ms Query time
11 Invalid entities

Queries

Group similar statements

# Time Info
1 80.44 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.roles AS roles_4, t0.status AS status_5, t0.created_at AS created_at_6, t0.close_at AS close_at_7, t0.suspend_at AS suspend_at_8, t0.terminate_at AS terminate_at_9, t0.two_factor_authentication_enabled AS two_factor_authentication_enabled_10, t11.id AS id_12, t11.first_name AS first_name_13, t11.last_name AS last_name_14, t11.applications AS applications_15, t11.user_id AS user_id_16, t11.country_id AS country_id_17, t11.language_id AS language_id_18 FROM user t0 LEFT JOIN user_profile t11 ON t11.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
  "kerby.kellem@gmail.com"
]
2 0.77 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM miscellaneous t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "disable_all_users"
]
3 1.04 ms
SELECT t0.id AS id_1, t0.url_name AS url_name_2, t0.related_mmdz_profile_id AS related_mmdz_profile_id_3, t0.enabled AS enabled_4, t0.status AS status_5, t0.cae_number AS cae_number_6, t0.has_cae_number AS has_cae_number_7, t0.works_prefix AS works_prefix_8, t0.interested_party_number AS interested_party_number_9, t0.signup_private AS signup_private_10, t0.created_at AS created_at_11, t0.confirmation_token AS confirmation_token_12, t0.profile_type_id AS profile_type_id_13, t0.parent_id AS parent_id_14, t15.id AS id_16, t15.name AS name_17, t15.first_name AS first_name_18, t15.last_name AS last_name_19, t15.email AS email_20, t15.city AS city_21, t15.address AS address_22, t15.phone_number AS phone_number_23, t15.zip_code AS zip_code_24, t15.notes AS notes_25, t15.main_color AS main_color_26, t15.text_color AS text_color_27, t15.background_color AS background_color_28, t15.inner_color AS inner_color_29, t15.button_color AS button_color_30, t15.image_name AS image_name_31, t15.stripe_id AS stripe_id_32, t15.company_registration_number AS company_registration_number_33, t15.profile_id AS profile_id_34, t15.country_id AS country_id_35, t15.file_id AS file_id_36, t37.id AS id_38, t37.facebook_url AS facebook_url_39, t37.twitter_url AS twitter_url_40, t37.instagram_url AS instagram_url_41, t37.youtube_url AS youtube_url_42, t37.soundcloud_url AS soundcloud_url_43, t37.profile_id AS profile_id_44, t45.id AS id_46, t45.performance_rights_split_profile AS performance_rights_split_profile_47, t45.performance_rights_split_parent AS performance_rights_split_parent_48, t45.sync_rights_split_profile AS sync_rights_split_profile_49, t45.sync_rights_split_parent AS sync_rights_split_parent_50, t45.mechanical_rights_split_profile AS mechanical_rights_split_profile_51, t45.mechanical_rights_split_parent AS mechanical_rights_split_parent_52, t45.profile_id AS profile_id_53, t54.id AS id_55, t54.performance_royalty_split_profile AS performance_royalty_split_profile_56, t54.performance_royalty_split_profile_date AS performance_royalty_split_profile_date_57, t54.performance_royalty_split_parent AS performance_royalty_split_parent_58, t54.performance_royalty_split_parent_date AS performance_royalty_split_parent_date_59, t54.sync_royalty_split_profile AS sync_royalty_split_profile_60, t54.sync_royalty_split_profile_date AS sync_royalty_split_profile_date_61, t54.sync_royalty_split_parent AS sync_royalty_split_parent_62, t54.sync_royalty_split_parent_date AS sync_royalty_split_parent_date_63, t54.mechanical_royalty_split_profile AS mechanical_royalty_split_profile_64, t54.mechanical_royalty_split_profile_date AS mechanical_royalty_split_profile_date_65, t54.mechanical_royalty_split_parent AS mechanical_royalty_split_parent_66, t54.mechanical_royalty_split_parent_date AS mechanical_royalty_split_parent_date_67, t54.lyrics_royalty_split_profile AS lyrics_royalty_split_profile_68, t54.lyrics_royalty_split_profile_date AS lyrics_royalty_split_profile_date_69, t54.lyrics_royalty_split_parent AS lyrics_royalty_split_parent_70, t54.lyrics_royalty_split_parent_date AS lyrics_royalty_split_parent_date_71, t54.is_custom_edition_lyrics AS is_custom_edition_lyrics_72, t54.is_custom_edition_mechanical AS is_custom_edition_mechanical_73, t54.is_custom_edition_performance AS is_custom_edition_performance_74, t54.is_custom_edition_sync AS is_custom_edition_sync_75, t54.minimum_payment AS minimum_payment_76, t54.minimum_payment_date AS minimum_payment_date_77, t54.profile_id AS profile_id_78 FROM profile t0 LEFT JOIN profile_information t15 ON t15.profile_id = t0.id LEFT JOIN profile_social_media t37 ON t37.profile_id = t0.id LEFT JOIN profile_delivery_splits t45 ON t45.profile_id = t0.id LEFT JOIN profile_royalty_splits t54 ON t54.profile_id = t0.id WHERE t0.id = ?
Parameters:
[
  "416"
]
4 0.64 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM profile_type t0 WHERE t0.id = ?
Parameters:
[
  4
]
5 1.02 ms
SELECT t0.id AS id_1, t0.share AS share_2, t0.songwriter_cae_number AS songwriter_cae_number_3, t0.publisher_name AS publisher_name_4, t0.publisher_cae_number AS publisher_cae_number_5, t0.music_contribution AS music_contribution_6, t0.lyrics_contribution AS lyrics_contribution_7, t0.composition_id AS composition_id_8, t0.profile_id AS profile_id_9, t0.pro_affiliation_id AS pro_affiliation_id_10, t11.id AS id_12, t11.first_name AS first_name_13, t11.last_name AS last_name_14, t11.song_writer_id AS song_writer_id_15 FROM song_writer t0 LEFT JOIN song_writer_external t11 ON t11.song_writer_id = t0.id WHERE t0.profile_id = ?
Parameters:
[
  416
]
6 1.00 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.alternative_title AS alternative_title_3, t0.lyrics AS lyrics_4, t0.unsubmission_message AS unsubmission_message_5, t0.tunecode AS tunecode_6, t0.iswc AS iswc_7, t0.iswc_clean AS iswc_clean_8, t0.imro AS imro_9, t0.status AS status_10, t0.is_instrumental AS is_instrumental_11, t0.work_number_id AS work_number_id_12, t0.work_number_id_counter AS work_number_id_counter_13, t0.created_at AS created_at_14, t0.submitted_at AS submitted_at_15, t0.published_at AS published_at_16, t0.title_language_id AS title_language_id_17, t0.processed_by AS processed_by_18, t0.created_by AS created_by_19, t0.published_by AS published_by_20 FROM song_composition t0 WHERE t0.id = ?
Parameters:
[
  2714
]
7 1.03 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.work_number AS work_number_3, t0.isrc AS isrc_4, t0.isrc_clean AS isrc_clean_5, t0.release_name AS release_name_6, t0.release_date AS release_date_7, t0.is_ppl_registered AS is_ppl_registered_8, t0.ppl_id AS ppl_id_9, t0.duration AS duration_10, t0.bpm AS bpm_11, t0.url AS url_12, t0.youtube_asset_id AS youtube_asset_id_13, t0.spotify_id AS spotify_id_14, t0.label AS label_15, t0.musiio_data AS musiio_data_16, t0.barcode AS barcode_17, t18.id AS id_19, t18.song_id AS song_id_20, t18.file_id AS file_id_21, t22.id AS id_23, t22.song_id AS song_id_24, t22.file_id AS file_id_25, t26.id AS id_27, t26.song_id AS song_id_28, t26.file_id AS file_id_29, t30.id AS id_31, t30.song_id AS song_id_32, t30.file_id AS file_id_33, t34.id AS id_35, t34.song_id AS song_id_36, t34.file_id AS file_id_37, t0.recording_artist_id AS recording_artist_id_38, t0.composition_id AS composition_id_39 FROM song t0 LEFT JOIN song_version_full t18 ON t18.song_id = t0.id LEFT JOIN song_version_instrumental t22 ON t22.song_id = t0.id LEFT JOIN song_version_instrumental_extra t26 ON t26.song_id = t0.id LEFT JOIN song_version_clean t30 ON t30.song_id = t0.id LEFT JOIN song_artwork t34 ON t34.song_id = t0.id WHERE t0.composition_id = ?
Parameters:
[
  2714
]
8 1.02 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.alternative_title AS alternative_title_3, t0.lyrics AS lyrics_4, t0.unsubmission_message AS unsubmission_message_5, t0.tunecode AS tunecode_6, t0.iswc AS iswc_7, t0.iswc_clean AS iswc_clean_8, t0.imro AS imro_9, t0.status AS status_10, t0.is_instrumental AS is_instrumental_11, t0.work_number_id AS work_number_id_12, t0.work_number_id_counter AS work_number_id_counter_13, t0.created_at AS created_at_14, t0.submitted_at AS submitted_at_15, t0.published_at AS published_at_16, t0.title_language_id AS title_language_id_17, t0.processed_by AS processed_by_18, t0.created_by AS created_by_19, t0.published_by AS published_by_20 FROM song_composition t0 WHERE t0.id = ?
Parameters:
[
  2733
]
9 1.01 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.work_number AS work_number_3, t0.isrc AS isrc_4, t0.isrc_clean AS isrc_clean_5, t0.release_name AS release_name_6, t0.release_date AS release_date_7, t0.is_ppl_registered AS is_ppl_registered_8, t0.ppl_id AS ppl_id_9, t0.duration AS duration_10, t0.bpm AS bpm_11, t0.url AS url_12, t0.youtube_asset_id AS youtube_asset_id_13, t0.spotify_id AS spotify_id_14, t0.label AS label_15, t0.musiio_data AS musiio_data_16, t0.barcode AS barcode_17, t18.id AS id_19, t18.song_id AS song_id_20, t18.file_id AS file_id_21, t22.id AS id_23, t22.song_id AS song_id_24, t22.file_id AS file_id_25, t26.id AS id_27, t26.song_id AS song_id_28, t26.file_id AS file_id_29, t30.id AS id_31, t30.song_id AS song_id_32, t30.file_id AS file_id_33, t34.id AS id_35, t34.song_id AS song_id_36, t34.file_id AS file_id_37, t0.recording_artist_id AS recording_artist_id_38, t0.composition_id AS composition_id_39 FROM song t0 LEFT JOIN song_version_full t18 ON t18.song_id = t0.id LEFT JOIN song_version_instrumental t22 ON t22.song_id = t0.id LEFT JOIN song_version_instrumental_extra t26 ON t26.song_id = t0.id LEFT JOIN song_version_clean t30 ON t30.song_id = t0.id LEFT JOIN song_artwork t34 ON t34.song_id = t0.id WHERE t0.composition_id = ?
Parameters:
[
  2733
]
10 0.78 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.alternative_title AS alternative_title_3, t0.lyrics AS lyrics_4, t0.unsubmission_message AS unsubmission_message_5, t0.tunecode AS tunecode_6, t0.iswc AS iswc_7, t0.iswc_clean AS iswc_clean_8, t0.imro AS imro_9, t0.status AS status_10, t0.is_instrumental AS is_instrumental_11, t0.work_number_id AS work_number_id_12, t0.work_number_id_counter AS work_number_id_counter_13, t0.created_at AS created_at_14, t0.submitted_at AS submitted_at_15, t0.published_at AS published_at_16, t0.title_language_id AS title_language_id_17, t0.processed_by AS processed_by_18, t0.created_by AS created_by_19, t0.published_by AS published_by_20 FROM song_composition t0 WHERE t0.id = ?
Parameters:
[
  2734
]
11 0.86 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.work_number AS work_number_3, t0.isrc AS isrc_4, t0.isrc_clean AS isrc_clean_5, t0.release_name AS release_name_6, t0.release_date AS release_date_7, t0.is_ppl_registered AS is_ppl_registered_8, t0.ppl_id AS ppl_id_9, t0.duration AS duration_10, t0.bpm AS bpm_11, t0.url AS url_12, t0.youtube_asset_id AS youtube_asset_id_13, t0.spotify_id AS spotify_id_14, t0.label AS label_15, t0.musiio_data AS musiio_data_16, t0.barcode AS barcode_17, t18.id AS id_19, t18.song_id AS song_id_20, t18.file_id AS file_id_21, t22.id AS id_23, t22.song_id AS song_id_24, t22.file_id AS file_id_25, t26.id AS id_27, t26.song_id AS song_id_28, t26.file_id AS file_id_29, t30.id AS id_31, t30.song_id AS song_id_32, t30.file_id AS file_id_33, t34.id AS id_35, t34.song_id AS song_id_36, t34.file_id AS file_id_37, t0.recording_artist_id AS recording_artist_id_38, t0.composition_id AS composition_id_39 FROM song t0 LEFT JOIN song_version_full t18 ON t18.song_id = t0.id LEFT JOIN song_version_instrumental t22 ON t22.song_id = t0.id LEFT JOIN song_version_instrumental_extra t26 ON t26.song_id = t0.id LEFT JOIN song_version_clean t30 ON t30.song_id = t0.id LEFT JOIN song_artwork t34 ON t34.song_id = t0.id WHERE t0.composition_id = ?
Parameters:
[
  2734
]

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
App\Entity\User\User
  • The field App\Entity\User\User#profileAccessLog is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Profile\ProfileAccessLog#user does not contain the required 'inversedBy="profileAccessLog"' attribute.
App\Entity\Profile\Profile
  • The mappings App\Entity\Profile\Profile#royaltySplitsTemplates and App\Entity\Profile\Splits\RoyaltySplitsTemplate#profile are inconsistent with each other.
  • The field App\Entity\Profile\Profile#profileNotes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Profile\ProfileNote#profile does not contain the required 'inversedBy="profileNotes"' attribute.
App\Entity\Profile\ProfileRBAC No errors.
App\Entity\Logs\EventLog No errors.
App\Entity\User\UserProfile No errors.
App\Entity\App\Country No errors.
App\Entity\App\Language No errors.
App\Entity\Notifications\Notification No errors.
App\Entity\Profile\ProfileAccessLog No errors.
App\Entity\Publishing\Platform No errors.
App\Entity\Composition\SongWriter No errors.
App\Entity\Profile\ProfileInformation
  • The association App\Entity\Profile\ProfileInformation#file refers to the inverse side field App\Entity\App\File#logo which does not exist.
App\Entity\Profile\ProfileType No errors.
App\Entity\App\Currency No errors.
App\Entity\Profile\Helper\Helper No errors.
App\Entity\Profile\Helper\Article No errors.
App\Entity\User\Role No errors.
App\Entity\Profile\ProfileSignature No errors.
App\Entity\Package\Package
  • The association App\Entity\Package\Package#profile refers to the inverse side field App\Entity\Profile\Profile#packages which does not exist.
  • The association App\Entity\Package\Package#profileType refers to the inverse side field App\Entity\Profile\ProfileType#packages which does not exist.
  • The association App\Entity\Package\Package#file refers to the inverse side field App\Entity\App\File#packages which does not exist.
  • The field App\Entity\Package\Package#subPackages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Package\Package#parent does not contain the required 'inversedBy="subPackages"' attribute.
App\Entity\Package\PackageTransaction
  • The association App\Entity\Package\PackageTransaction#profile refers to the inverse side field App\Entity\Profile\Profile#packageTransactions which does not exist.
  • The mappings App\Entity\Package\PackageTransaction#reactivationAttempts and App\Entity\Package\ReactivationAttempts#packageTransaction are inconsistent with each other.
  • The association App\Entity\Package\PackageTransaction#paymentGateway refers to the inverse side field App\Entity\Profile\PaymentMethod\PaymentGateway#packageTransactions which does not exist.
App\Entity\Package\PackageSongWriter No errors.
App\Entity\Profile\PaymentMethod\PaymentGateway
  • The association App\Entity\Profile\PaymentMethod\PaymentGateway#paymentType refers to the inverse side field App\Entity\App\PaymentType#paymentTypes which does not exist.
App\Entity\Profile\PaymentMethod\PaymentGatewayEvent No errors.
App\Entity\Package\Invoice No errors.
App\Entity\Package\ReactivationAttempts
  • The association App\Entity\Package\ReactivationAttempts#packageTransaction refers to the inverse side field App\Entity\Package\PackageTransaction#reactivationAttemps which does not exist.
App\Entity\Profile\Splits\RoyaltySplits No errors.
App\Entity\Profile\Splits\RoyaltySplitsTemplate
  • The association App\Entity\Profile\Splits\RoyaltySplitsTemplate#profile refers to the inverse side field App\Entity\Profile\Profile#royaltySplitsMasks which does not exist.
App\Entity\App\File No errors.
App\Entity\Logs\ProfileHierarchyHistoryLog No errors.
App\Entity\Profile\PlatformIpiNumber No errors.
App\Entity\Song\Song No errors.
App\Entity\Song\Versions\FullSongVersion No errors.
App\Entity\Song\Versions\InstrumentalSongVersion No errors.
App\Entity\Song\Versions\ExtraInstrumentalSongVersion No errors.
App\Entity\Song\Artwork No errors.
App\Entity\Song\Versions\CleanSongVersion No errors.
App\Entity\Composition\Composition
  • The association App\Entity\Composition\Composition#createdBy refers to the inverse side field App\Entity\User\User#compositions which does not exist.
  • The association App\Entity\Composition\Composition#publishedBy refers to the inverse side field App\Entity\User\User#compositions which does not exist.
  • The mappings App\Entity\Composition\Composition#compositionLanguages and App\Entity\Composition\CompositionLanguage#composition are inconsistent with each other.
App\Entity\Composition\ExternalSongWriter No errors.
App\Entity\Composition\Territory No errors.
App\Entity\Composition\ProAffiliation No errors.
App\Entity\Publishing\CwrFile
  • The association App\Entity\Publishing\CwrFile#platform refers to the inverse side field App\Entity\Publishing\Platform#cwrFile which does not exist.
App\Entity\Profile\Splits\DeliverySplits No errors.
App\Entity\Publishing\FeedLog No errors.
App\Entity\Composition\CompositionCwrFile No errors.
App\Entity\Composition\CompositionSignature No errors.
App\Entity\Composition\CompositionTerritory No errors.
App\Entity\Profile\Splits\RoyaltyImporterFile No errors.
App\Entity\Profile\Splits\RoyaltyDue No errors.
App\Entity\Profile\Splits\RoyaltyDueAdjust No errors.
App\Entity\Profile\Splits\RoyaltyConsolidation No errors.
App\Entity\App\Miscellaneous No errors.
App\Entity\Profile\ProfileSocialMedia No errors.
App\Entity\Profile\ProfileCommunicationSettings No errors.
App\Entity\Profile\ProfileNote No errors.
App\Entity\Composition\CompositionPlatform No errors.
App\Entity\Composition\CompositionLanguage
  • The association App\Entity\Composition\CompositionLanguage#composition refers to the inverse side field App\Entity\Composition\Composition#languages which does not exist.
App\Entity\App\CustomLanguage No errors.
App\Entity\Song\RecordingArtist No errors.
App\Entity\Song\Tags\LyricalTheme No errors.
App\Entity\Song\Tags\Instrument No errors.
App\Entity\Song\Tags\Genre No errors.
App\Entity\Song\Tags\Mood No errors.
App\Entity\Song\Tags\Tempo No errors.
App\Entity\Song\Tags\Vocals No errors.
App\Entity\Song\Tags\Type No errors.
App\Entity\Song\Artist No errors.
App\Entity\Song\Performer No errors.