http://api.mmpz.myclientzone.com/payment/2/webhook

Query Metrics

8 Database Queries
7 Different statements
9.40 ms Query time
11 Invalid entities

Queries

Group similar statements

# Time Info
1 1.10 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"
]
2 0.81 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.website AS website_3, t0.provider_params AS provider_params_4, t0.status AS status_5, t0.created_at AS created_at_6, t0.profile_id AS profile_id_7, t0.payment_type_id AS payment_type_id_8 FROM profile_payment_gateway t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
3 1.05 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM payment_type t0 WHERE t0.id = ?
Parameters:
[
  2
]
4 1.22 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:
[
  94
]
5 0.82 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM profile_type t0 WHERE t0.id = ?
Parameters:
[
  2
]
6 0.65 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.website AS website_3, t0.provider_params AS provider_params_4, t0.status AS status_5, t0.created_at AS created_at_6, t0.profile_id AS profile_id_7, t0.payment_type_id AS payment_type_id_8 FROM profile_payment_gateway t0 WHERE t0.profile_id = ?
Parameters:
[
  94
]
7 0.64 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM payment_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 3.12 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.payment_gateway_create AS payment_gateway_create_3, t0.payment_gateway_process AS payment_gateway_process_4, t0.payment_gateway_external_id AS payment_gateway_external_id_5, t0.return_url AS return_url_6, t0.cancel_url AS cancel_url_7, t0.created_at AS created_at_8, t0.processed_at AS processed_at_9, t0.transition_reason AS transition_reason_10, t0.cancel_message_sent AS cancel_message_sent_11, t0.resume_message_sent AS resume_message_sent_12, t0.manual AS manual_13, t0.profile_id AS profile_id_14, t0.package_id AS package_id_15, t0.package_songwriter_id AS package_songwriter_id_16, t0.payment_gateway_id AS payment_gateway_id_17, t0.transition_transaction_id AS transition_transaction_id_18 FROM packages_transactions t0 WHERE t0.payment_gateway_external_id = ? LIMIT 1
Parameters:
[
  "in_1SIYyLLO1J98DZHqxi3s0VNW"
]

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\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\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\App\Miscellaneous No errors.
App\Entity\App\PaymentType 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\Profile\Helper\Helper No errors.
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\Helper\Article No errors.
App\Entity\User\Role No errors.
App\Entity\Profile\ProfileSignature 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\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.
App\Entity\Composition\ExternalSongWriter 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\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\RecordingArtist No errors.
App\Entity\Song\Artist No errors.
App\Entity\Song\Performer No errors.
App\Entity\Composition\Territory No errors.