http://api.mmpz.myclientzone.com/user/for-mmaz

Query Metrics

11 Database Queries
9 Different statements
91.92 ms Query time
13 Invalid entities

Queries

Group similar statements

# Time Info
1 1.09 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 33.66 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:
[
  "copyrightcontrol3@gmail.com"
]
3 16.92 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:
[
  "mauricioloayzas@gmail.com"
]
4 0.67 ms
"START TRANSACTION"
Parameters:
[]
5 0.80 ms
INSERT INTO event_log (object_id, object_fqcn, blame_object_id, blame_object_fqcn, data, log_type, created_at) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => 1003412
  2 => "App\Entity\User\User"
  3 => 1003412
  4 => "App\Entity\User\User"
  5 => "{"iat":1760729886,"exp":1761334686,"email":"copyrightcontrol3@gmail.com","enabled":false,"status":0,"created_at":"2025-10-17T21:38:03+02:00","report_encoding":1,"currency_code":"GBP","two_factor_authentication_enabled":false,"signed_up_to_mailing_list":true,"user_profile_first_name":"Team","user_profile_last_name":"MG","user_profile_email_gc":"copyrightcontrol3@gmail.com","user_profile_country_name":"India","user_profile_timezone":"Asia\/Kolkata","user_profile_language_code":"en","applications":["mmdz"]}"
  6 => "Before User revoked MMAZ"
  7 => "2025-10-17 21:38:07"
]
6 1.77 ms
"COMMIT"
Parameters:
[]
7 33.48 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:
[
  "copyrightcontrol3@gmail.com"
]
8 0.81 ms
SELECT t0.id AS id_1, t0.accessed_at AS accessed_at_2, t0.profile_id AS profile_id_3, t0.user_id AS user_id_4 FROM log_profile_access t0 WHERE t0.user_id = ? ORDER BY t0.accessed_at DESC
Parameters:
[
  1023592
]
9 0.96 ms
SELECT t0.id AS id_1, t0.country AS country_2, t0.code AS code_3, t0.code_a3 AS code_a3_4, t0.code_iso3 AS code_iso3_5, t0.is_eu AS is_eu_6, t0.region AS region_7, t0.sub_region AS sub_region_8, t0.licensed_territory_id AS licensed_territory_id_9 FROM country t0 WHERE t0.id = ?
Parameters:
[
  115
]
10 0.96 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.code_uppercase AS code_uppercase_4 FROM language t0 WHERE t0.id = ?
Parameters:
[
  30
]
11 0.79 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.profile_id AS profile_id_4, t0.role_id AS role_id_5 FROM profile_rbac t0 WHERE t0.user_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  1023592
]

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\Logs\EventLog 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\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\ProfileRBAC No errors.
App\Entity\Profile\ProfileAccessLog No 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\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\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\Composition\SongWriter 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\App\Miscellaneous No errors.
App\Entity\Profile\ProfileSocialMedia No errors.
App\Entity\Profile\ProfileCommunicationSettings No errors.
App\Entity\Profile\Splits\RoyaltyImporterFile No errors.
App\Entity\Profile\Splits\DeliverySplits No errors.
App\Entity\Profile\ProfileNote 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\ProAffiliation No errors.
App\Entity\Composition\ExternalSongWriter No errors.
App\Entity\App\PaymentType No errors.
App\Entity\Publishing\Platform No errors.
App\Entity\Composition\CompositionTerritory No errors.
App\Entity\Composition\CompositionUnsubmissionLog No errors.
App\Entity\Composition\CompositionNote No errors.
App\Entity\Composition\CompositionPlatform No errors.
App\Entity\Composition\CompositionCwrFile No errors.
App\Entity\Composition\CompositionSignature No errors.
App\Entity\Composition\Territory 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\Profile\Invitation No errors.
App\Entity\Profile\Contract
  • The association App\Entity\Profile\Contract#profile refers to the inverse side field App\Entity\Profile\Profile#contracts which does not exist.
  • The association App\Entity\Profile\Contract#profileType refers to the inverse side field App\Entity\Profile\ProfileType#contracts which does not exist.
App\Entity\Profile\Message\MessageReader No errors.
App\Entity\Profile\Message\Message
  • The field App\Entity\Profile\Message\Message#readers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Profile\Message\MessageReader#message does not contain the required 'inversedBy="readers"' attribute.
App\Entity\Profile\Splits\RoyaltyDue No errors.
App\Entity\Profile\Splits\RoyaltyDueAdjust No errors.
App\Entity\Profile\Splits\RoyaltyConsolidation 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\Notifications\EmailNotification No errors.
App\Entity\Notifications\ProfileEmailNotification No errors.
App\Entity\App\Currency No errors.
App\Entity\App\UnSubmitReason No errors.
App\Entity\App\CustomLanguage No errors.
App\Entity\Song\Performer No errors.
App\Entity\Song\RecordingArtist No errors.
App\Entity\Song\Tags\Type No errors.
App\Entity\Song\Tags\LyricalTheme No errors.
App\Entity\Song\Tags\Instrument No errors.
App\Entity\Song\Tags\Vocals No errors.
App\Entity\Song\Tags\Tempo No errors.
App\Entity\Song\Tags\Mood No errors.
App\Entity\Song\Tags\Genre No errors.
App\Entity\Song\Artwork No errors.
App\Entity\Song\Song No errors.
App\Entity\Song\Versions\ExtraInstrumentalSongVersion No errors.
App\Entity\Song\Versions\FullSongVersion No errors.
App\Entity\Song\Versions\InstrumentalSongVersion No errors.
App\Entity\Song\Versions\CleanSongVersion No errors.
App\Entity\Song\Artist No errors.