http://api.mmpz.myclientzone.com/api/v1/profile/416

Method
GET
HTTP Status
200
IP
172.20.0.1
Profiled on
Token
bc787c

Query Metrics

30 Database Queries
24 Different statements
76.05 ms Query time
10 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 24.76 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: 
[
  "kerby.kellem@gmail.com"
]
View formatted query    View runnable query    Explain query
2 0.90 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"
]
View formatted query    View runnable query    Explain query
3 1.30 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.id = ?
Parameters: 
[
  "416"
]
View formatted query    View runnable query    Explain query
4 24.47 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: 
[
  "kerby.kellem@gmail.com"
]
View formatted query    View runnable query    Explain query
5 1.19 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: 
[
  "service"
]
View formatted query    View runnable query    Explain query
6 1.24 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.profile_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
7 1.12 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.parent_id = ?
Parameters: 
[
  416
]
View formatted query    View runnable query    Explain query
8 0.60 ms 
SELECT t0.id AS id_1, t0.note AS note_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.profile_id AS profile_id_6, t0.created_by AS created_by_7 FROM profile_notes t0 WHERE t0.profile_id = ?
Parameters: 
[
  416
]
View formatted query    View runnable query    Explain query
9 0.89 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.id = ?
Parameters: 
[
  94
]
View formatted query    View runnable query    Explain query
10 0.50 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM profile_type t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
11 0.53 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.profile_id = ?
Parameters: 
[
  416
]
View formatted query    View runnable query    Explain query
12 0.59 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM role t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
13 0.84 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM profile_type t0 WHERE t0.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
14 0.86 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: 
[
  249
]
View formatted query    View runnable query    Explain query
15 0.79 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
]
View formatted query    View runnable query    Explain query
16 1.05 ms 
SELECT t0.id AS id_1, t0.active AS active_2, t0.status AS status_3, t0.avialable_on AS avialable_on_4, t0.avialable_off AS avialable_off_5, t0.type_subcription AS type_subcription_6, t0.profile_id AS profile_id_7, t0.package_id AS package_id_8, t0.package_transaction_id AS package_transaction_id_9 FROM packages_song_writers t0 WHERE t0.profile_id = ?
Parameters: 
[
  416
]
View formatted query    View runnable query    Explain query
17 0.82 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.description AS description_4, t0.image_name AS image_name_5, t0.duration AS duration_6, t0.is_monthly AS is_monthly_7, t0.is_semester AS is_semester_8, t0.is_annual AS is_annual_9, t0.composition_limit AS composition_limit_10, t0.subprofile_limit AS subprofile_limit_11, t0.enabled AS enabled_12, t0.admin_percentage AS admin_percentage_13, t0.price AS price_14, t0.visible AS visible_15, t0.quantity_sold AS quantity_sold_16, t0.impressions_count AS impressions_count_17, t0.type AS type_18, t0.discount AS discount_19, t0.allow_extras AS allow_extras_20, t0.is_basic AS is_basic_21, t0.visible_to_admin_only AS visible_to_admin_only_22, t0.has_standard AS has_standard_23, t0.has_plus AS has_plus_24, t0.paypal_product_id AS paypal_product_id_25, t0.paypal_plan_id AS paypal_plan_id_26, t0.stripe_product_id AS stripe_product_id_27, t0.stripe_plan_id AS stripe_plan_id_28, t0.package_standard_id AS package_standard_id_29, t0.package_plus_id AS package_plus_id_30, t0.profile_id AS profile_id_31, t0.profile_type_id AS profile_type_id_32, t0.file_id AS file_id_33, t0.parent_id AS parent_id_34 FROM package t0 WHERE t0.id = ?
Parameters: 
[
  143
]
View formatted query    View runnable query    Explain query
18 0.67 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.description AS description_4, t0.image_name AS image_name_5, t0.duration AS duration_6, t0.is_monthly AS is_monthly_7, t0.is_semester AS is_semester_8, t0.is_annual AS is_annual_9, t0.composition_limit AS composition_limit_10, t0.subprofile_limit AS subprofile_limit_11, t0.enabled AS enabled_12, t0.admin_percentage AS admin_percentage_13, t0.price AS price_14, t0.visible AS visible_15, t0.quantity_sold AS quantity_sold_16, t0.impressions_count AS impressions_count_17, t0.type AS type_18, t0.discount AS discount_19, t0.allow_extras AS allow_extras_20, t0.is_basic AS is_basic_21, t0.visible_to_admin_only AS visible_to_admin_only_22, t0.has_standard AS has_standard_23, t0.has_plus AS has_plus_24, t0.paypal_product_id AS paypal_product_id_25, t0.paypal_plan_id AS paypal_plan_id_26, t0.stripe_product_id AS stripe_product_id_27, t0.stripe_plan_id AS stripe_plan_id_28, t0.package_standard_id AS package_standard_id_29, t0.package_plus_id AS package_plus_id_30, t0.profile_id AS profile_id_31, t0.profile_type_id AS profile_type_id_32, t0.file_id AS file_id_33, t0.parent_id AS parent_id_34 FROM package t0 WHERE t0.id = ?
Parameters: 
[
  124
]
View formatted query    View runnable query    Explain query
19 0.55 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: 
[
  5577
]
View formatted query    View runnable query    Explain query
20 0.86 ms 
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.id = ?
Parameters: 
[
  999
]
View formatted query    View runnable query    Explain query
21 0.88 ms 
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: 
[
  8
]
View formatted query    View runnable query    Explain query
22 0.66 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM payment_type t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
23 4.39 ms 
SELECT t0.id AS id_1, t0.event AS event_2, t0.website AS website_3, t0.extenal_id AS extenal_id_4, t0.created_at AS created_at_5, t0.payment_gateway_id AS payment_gateway_id_6 FROM profile_payment_gateway_events t0 WHERE t0.payment_gateway_id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query
24 1.05 ms 
SELECT t0.id AS id_1, t0.payment_gateway_status AS payment_gateway_status_2, t0.payment_gateway_name AS payment_gateway_name_3, t0.attempt_date AS attempt_date_4, t0.next_attempt_date AS next_attempt_date_5, t0.resume_message_sent AS resume_message_sent_6, t0.package_transaction_id AS package_transaction_id_7 FROM packages_reactive_attempts t0 WHERE t0.package_transaction_id = ?
Parameters: 
[
  999
]
View formatted query    View runnable query    Explain query
25 0.88 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.horus_number AS horus_number_3, t0.billing_date AS billing_date_4, t0.subtotal AS subtotal_5, t0.discount AS discount_6, t0.taxes AS taxes_7, t0.total AS total_8, t0.items AS items_9, t0.status AS status_10, t0.avialable_on AS avialable_on_11, t0.avialable_off AS avialable_off_12, t0.package_song_writer_id AS package_song_writer_id_13 FROM invoices t0 WHERE t0.package_song_writer_id = ?
Parameters: 
[
  382
]
View formatted query    View runnable query    Explain query
26 0.89 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.status AS status_3, t0.published AS published_4, t0.order_number AS order_number_5, t0.profile_id AS profile_id_6 FROM profile_helper t0 WHERE t0.profile_id = ? ORDER BY t0.order_number ASC
Parameters: 
[
  416
]
View formatted query    View runnable query    Explain query
27 0.67 ms 
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: 
[
  416
]
View formatted query    View runnable query    Explain query
28 0.66 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.type AS type_3, t0.profile_id AS profile_id_4 FROM profile_communication_settings t0 WHERE t0.profile_id = ?
Parameters: 
[
  416
]
View formatted query    View runnable query    Explain query
29 0.68 ms 
SELECT t0.id AS id_1, t0.ipi_number AS ipi_number_2, t0.agreetment_number AS agreetment_number_3, t0.sender_code AS sender_code_4, t0.receiver_code AS receiver_code_5, t0.ftp_unsername AS ftp_unsername_6, t0.ftp_password AS ftp_password_7, t0.specification AS specification_8, t0.client_name AS client_name_9, t0.password AS password_10, t0.active AS active_11, t0.profile_id AS profile_id_12, t0.platform_id AS platform_id_13 FROM platform_ipi_number t0 WHERE t0.profile_id = ?
Parameters: 
[
  416
]
View formatted query    View runnable query    Explain query
30 0.75 ms 
SELECT t0.id AS id_1, t0.type AS type_2, t0.status AS status_3, t0.date_from AS date_from_4, t0.date_to AS date_to_5, t0.entered_at AS entered_at_6, t0.gbp AS gbp_7, t0.total_rows AS total_rows_8, t0.imported_rows AS imported_rows_9, t0.error_rows AS error_rows_10, t0.created_at AS created_at_11, t0.due_date AS due_date_12, t0.quantity_sum AS quantity_sum_13, t0.quantity_sum_imported AS quantity_sum_imported_14, t0.quantity_sum_eror AS quantity_sum_eror_15, t0.income_sum AS income_sum_16, t0.income_sum_imported AS income_sum_imported_17, t0.income_sum_error AS income_sum_error_18, t0.tax_percentage AS tax_percentage_19, t0.tax_amount AS tax_amount_20, t0.updated_rowa AS updated_rowa_21, t0.income_conversion_rate AS income_conversion_rate_22, t0.tax_conversion_rate AS tax_conversion_rate_23, t0.profile_id AS profile_id_24, t0.platform_id AS platform_id_25, t0.file_id AS file_id_26, t0.error_file_id AS error_file_id_27, t0.created_by_id AS created_by_id_28, t0.tax_country_id AS tax_country_id_29 FROM profile_royalty_importer_file t0 WHERE t0.profile_id = ?
Parameters: 
[
  416
]
View formatted query    View runnable query    Explain query

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
  • 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\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\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\Profile\ProfileType No errors.
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\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
  • 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\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
  • 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\Profile\ProfileNote No errors.
App\Entity\User\Role 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\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\App\PaymentType No errors.
App\Entity\Profile\PaymentMethod\PaymentGatewayEvent No errors.
App\Entity\Publishing\Platform No errors.
App\Entity\Profile\Helper\Article No errors.
App\Entity\Profile\ProfileSignature 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\Song\Song No errors.
App\Entity\Composition\ProAffiliation 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\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.