Query Metrics
8
Database Queries
7
Different statements
9.40 ms
Query time
11
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.12 ms (0.00%) |
1 |
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"
]
|
1.69 ms (0.00%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM payment_type t0 WHERE t0.id = ?
Parameters:
[
2
]
|
1.22 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:
[
94
]
|
1.10 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.82 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM profile_type t0 WHERE t0.id = ?
Parameters:
[
2
]
|
0.81 ms (0.00%) |
1 |
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"
]
|
0.65 ms (0.00%) |
1 |
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
]
|
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 |
|
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\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\App\Miscellaneous | No errors. |
App\Entity\App\PaymentType | 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\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 |
|
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 |
|
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. |
App\Entity\Composition\ExternalSongWriter | No errors. |
App\Entity\Composition\CompositionPlatform | No errors. |
App\Entity\Composition\CompositionLanguage |
|
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. |