Query Metrics
11
Database Queries
7
Different statements
89.61 ms
Query time
11
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
80.44 ms (0.00%) |
1 |
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.90 ms (0.00%) |
3 |
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
]
|
2.80 ms (0.00%) |
3 |
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
]
|
1.04 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.id = ?
Parameters:
[
"416"
]
|
1.02 ms (0.00%) |
1 |
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
]
|
0.77 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"
]
|
0.64 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM profile_type t0 WHERE t0.id = ?
Parameters:
[
4
]
|
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 |
|
App\Entity\Profile\Profile |
|
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 |
|
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 |
|
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\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 |
|
App\Entity\Composition\ExternalSongWriter | No errors. |
App\Entity\Composition\Territory | No errors. |
App\Entity\Composition\ProAffiliation | No errors. |
App\Entity\Publishing\CwrFile |
|
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 |
|
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. |