http://api.mmpz.myclientzone.com/api/v1/public/profile/horus-music-publishing

Query Metrics

4 Database Queries
4 Different statements
5.51 ms Query time
10 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.71 ms
(0.00%)
1
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.url_name = ? LIMIT 1
Parameters:
[
  "horus-music-publishing"
]
1.45 ms
(0.00%)
1
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"
]
1.21 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.object_id AS object_id_2, t0.object_fqcn AS object_fqcn_3, t0.adapter AS adapter_4, t0.original_name AS original_name_5, t0.stored_name AS stored_name_6, t0.stored_folder AS stored_folder_7, t0.extension AS extension_8, t0.size AS size_9, t0.mime_type AS mime_type_10, t0.created_at AS created_at_11, t0.uploaded_by AS uploaded_by_12 FROM file t0 WHERE t0.id = ?
Parameters:
[
  2814
]
1.14 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM profile_type t0 WHERE t0.id = ?
Parameters:
[
  2
]

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\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\App\Miscellaneous No 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\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\ProfileType 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\App\File No errors.
App\Entity\Profile\ProfileSocialMedia No errors.
App\Entity\Profile\Splits\DeliverySplits No errors.
App\Entity\Profile\Splits\RoyaltySplits No errors.
App\Entity\Package\PackageSongWriter No errors.
App\Entity\Profile\Helper\Helper 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\ProfileCommunicationSettings No errors.
App\Entity\Logs\ProfileHierarchyHistoryLog No errors.
App\Entity\Composition\SongWriter No errors.
App\Entity\Profile\PlatformIpiNumber No errors.
App\Entity\Profile\Splits\RoyaltyImporterFile 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\Profile\ProfileNote No errors.
App\Entity\Profile\ProfileAccessLog 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\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\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\Publishing\Platform No errors.
App\Entity\Song\Song 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\Publishing\FeedLog No errors.
App\Entity\Composition\CompositionCwrFile No errors.
App\Entity\Composition\CompositionSignature No errors.
App\Entity\Composition\CompositionTerritory 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\App\Currency No errors.