Query Metrics
4
Database Queries
4
Different statements
5.51 ms
Query time
10
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.45 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 | 1.71 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.url_name = ? LIMIT 1
Parameters:
[
"horus-music-publishing"
]
|
3 | 1.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM profile_type t0 WHERE t0.id = ?
Parameters:
[
2
]
|
4 | 1.21 ms |
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
]
|
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 |
|
App\Entity\App\Miscellaneous | No errors. |
App\Entity\User\User |
|
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 |
|
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 |
|
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 |
|
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 |
|
App\Entity\Package\PackageTransaction |
|
App\Entity\Profile\PaymentMethod\PaymentGatewayEvent | No errors. |
App\Entity\Package\Invoice | No errors. |
App\Entity\Package\ReactivationAttempts |
|
App\Entity\Composition\Composition |
|
App\Entity\Publishing\Platform | No errors. |
App\Entity\Song\Song | No errors. |
App\Entity\Composition\ProAffiliation | No errors. |
App\Entity\Publishing\CwrFile |
|
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. |