Query Metrics
11
Database Queries
9
Different statements
91.92 ms
Query time
13
Invalid entities
Queries
#▲ | 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 |
|
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 |
|
App\Entity\Profile\ProfileInformation |
|
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 |
|
App\Entity\Package\PackageTransaction |
|
App\Entity\Package\PackageSongWriter | No errors. |
App\Entity\Profile\PaymentMethod\PaymentGateway |
|
App\Entity\Profile\PaymentMethod\PaymentGatewayEvent | No errors. |
App\Entity\Package\Invoice | No errors. |
App\Entity\Package\ReactivationAttempts |
|
App\Entity\Profile\Splits\RoyaltySplits | No errors. |
App\Entity\Profile\Splits\RoyaltySplitsTemplate |
|
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 |
|
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 |
|
App\Entity\Profile\Invitation | No errors. |
App\Entity\Profile\Contract |
|
App\Entity\Profile\Message\MessageReader | No errors. |
App\Entity\Profile\Message\Message |
|
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 |
|
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. |