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

Method
GET
HTTP Status
200
IP
172.20.0.1
Profiled on
Token
2298a7

Query Metrics

49 Database Queries
22 Different statements
324.63 ms Query time
10 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 157.62 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.87 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.11 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
4 23.54 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.18 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 0.96 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 35.61 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: 
[
  94
]
View formatted query    View runnable query    Explain query
8 0.93 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: 
[
  94
]
View formatted query    View runnable query    Explain query
9 0.60 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM profile_type t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
10 3.32 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: 
[
  94
]
View formatted query    View runnable query    Explain query
11 0.69 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM role t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
12 0.82 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
13 1.20 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: 
[
  247
]
View formatted query    View runnable query    Explain query
14 1.63 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
15 0.95 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.id = ?
Parameters: 
[
  1003412
]
View formatted query    View runnable query    Explain query
16 1.07 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.id = ?
Parameters: 
[
  2607
]
View formatted query    View runnable query    Explain query
17 0.77 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.id = ?
Parameters: 
[
  1004264
]
View formatted query    View runnable query    Explain query
18 0.60 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM role t0 WHERE t0.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
19 0.74 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.id = ?
Parameters: 
[
  1020425
]
View formatted query    View runnable query    Explain query
20 0.54 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM role t0 WHERE t0.id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
21 0.92 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: 
[
  94
]
View formatted query    View runnable query    Explain query
22 0.93 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: 
[
  94
]
View formatted query    View runnable query    Explain query
23 0.93 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.status AS status_4, t0.published AS published_5, t0.order_number AS order_number_6, t0.helper_id AS helper_id_7 FROM profile_helper_article t0 WHERE t0.helper_id = ? ORDER BY t0.order_number ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
24 0.92 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.status AS status_4, t0.published AS published_5, t0.order_number AS order_number_6, t0.helper_id AS helper_id_7 FROM profile_helper_article t0 WHERE t0.helper_id = ? ORDER BY t0.order_number ASC
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
25 0.66 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.status AS status_4, t0.published AS published_5, t0.order_number AS order_number_6, t0.helper_id AS helper_id_7 FROM profile_helper_article t0 WHERE t0.helper_id = ? ORDER BY t0.order_number ASC
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
26 0.76 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.status AS status_4, t0.published AS published_5, t0.order_number AS order_number_6, t0.helper_id AS helper_id_7 FROM profile_helper_article t0 WHERE t0.helper_id = ? ORDER BY t0.order_number ASC
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
27 0.57 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.status AS status_4, t0.published AS published_5, t0.order_number AS order_number_6, t0.helper_id AS helper_id_7 FROM profile_helper_article t0 WHERE t0.helper_id = ? ORDER BY t0.order_number ASC
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
28 0.93 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.status AS status_4, t0.published AS published_5, t0.order_number AS order_number_6, t0.helper_id AS helper_id_7 FROM profile_helper_article t0 WHERE t0.helper_id = ? ORDER BY t0.order_number ASC
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query
29 0.91 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.status AS status_4, t0.published AS published_5, t0.order_number AS order_number_6, t0.helper_id AS helper_id_7 FROM profile_helper_article t0 WHERE t0.helper_id = ? ORDER BY t0.order_number ASC
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query
30 0.69 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.status AS status_4, t0.published AS published_5, t0.order_number AS order_number_6, t0.helper_id AS helper_id_7 FROM profile_helper_article t0 WHERE t0.helper_id = ? ORDER BY t0.order_number ASC
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query
31 0.83 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.status AS status_4, t0.published AS published_5, t0.order_number AS order_number_6, t0.helper_id AS helper_id_7 FROM profile_helper_article t0 WHERE t0.helper_id = ? ORDER BY t0.order_number ASC
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
32 0.80 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: 
[
  94
]
View formatted query    View runnable query    Explain query
33 0.86 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM payment_type t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
34 63.80 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: 
[
  2
]
View formatted query    View runnable query    Explain query
35 0.89 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
36 4.30 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
37 1.82 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: 
[
  94
]
View formatted query    View runnable query    Explain query
38 1.21 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: 
[
  94
]
View formatted query    View runnable query    Explain query
39 0.88 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.format AS format_4, t0.active AS active_5 FROM platform t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
40 0.78 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.format AS format_4, t0.active AS active_5 FROM platform t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
41 0.62 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.format AS format_4, t0.active AS active_5 FROM platform t0 WHERE t0.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
42 0.53 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.format AS format_4, t0.active AS active_5 FROM platform t0 WHERE t0.id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
43 0.53 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.format AS format_4, t0.active AS active_5 FROM platform t0 WHERE t0.id = ?
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query
44 0.48 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.format AS format_4, t0.active AS active_5 FROM platform t0 WHERE t0.id = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query
45 0.53 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.format AS format_4, t0.active AS active_5 FROM platform t0 WHERE t0.id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query
46 0.67 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.format AS format_4, t0.active AS active_5 FROM platform t0 WHERE t0.id = ?
Parameters: 
[
  18
]
View formatted query    View runnable query    Explain query
47 0.48 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.format AS format_4, t0.active AS active_5 FROM platform t0 WHERE t0.id = ?
Parameters: 
[
  19
]
View formatted query    View runnable query    Explain query
48 0.88 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.format AS format_4, t0.active AS active_5 FROM platform t0 WHERE t0.id = ?
Parameters: 
[
  20
]
View formatted query    View runnable query    Explain query
49 0.79 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: 
[
  94
]
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\Profile\Helper\Article No errors.
App\Entity\App\PaymentType No errors.
App\Entity\Profile\PaymentMethod\PaymentGatewayEvent No errors.
App\Entity\Publishing\Platform No errors.
App\Entity\Composition\CompositionPlatform No errors.
App\Entity\Profile\ProfileSignature No errors.
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\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.