https://preprod.inquize.net/api/media/26

Query Metrics

5 Database Queries
5 Different statements
4.41 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.70 ms
(38.64%)
1
SELECT t0.email AS email_1, t0.email_confirmed AS email_confirmed_2, t0.hide_email AS hide_email_3, t0.email_confirmed_recover AS email_confirmed_recover_4, t0.username AS username_5, t0.firstname AS firstname_6, t0.tel AS tel_7, t0.address AS address_8, t0.website AS website_9, t0.following AS following_10, t0.participations AS participations_11, t0.lastname AS lastname_12, t0.languages AS languages_13, t0.roles AS roles_14, t0.password AS password_15, t0.picture AS picture_16, t0.api_token AS api_token_17, t0.facebook AS facebook_18, t0.facebook_id AS facebook_id_19, t0.facebook_token AS facebook_token_20, t0.google_id AS google_id_21, t0.google_token AS google_token_22, t0.instagram AS instagram_23, t0.instagram_id AS instagram_id_24, t0.instagram_token AS instagram_token_25, t0.twitter AS twitter_26, t0.twitter_id AS twitter_id_27, t0.twitter_token AS twitter_token_28, t0.snapchat AS snapchat_29, t0.snapchat_id AS snapchat_id_30, t0.snapchat_token AS snapchat_token_31, t0.youtube AS youtube_32, t0.youtube_id AS youtube_id_33, t0.youtube_token AS youtube_token_34, t0.password_recover AS password_recover_35, t0.last_login AS last_login_36, t0.date_of_birth AS date_of_birth_37, t0.nationality AS nationality_38, t0.country AS country_39, t0.zone AS zone_40, t0.zip_code AS zip_code_41, t0.address1 AS address1_42, t0.address2 AS address2_43, t0.address3 AS address3_44, t0.civility AS civility_45, t0.city AS city_46, t0.id AS id_47, t0.created_at AS created_at_48, t0.updated_at AS updated_at_49, t0.is_deleted AS is_deleted_50, t51.average_number_of_followrs AS average_number_of_followrs_52, t51.website AS website_53, t51.contact_option AS contact_option_54, t51.username AS username_55, t51.time_from AS time_from_56, t51.time_to AS time_to_57, t51.type AS type_58, t51.category AS category_59, t51.state AS state_60, t51.media AS media_61, t51.email_contact AS email_contact_62, t51.skype_contact AS skype_contact_63, t51.insta_contact AS insta_contact_64, t51.wats_contact AS wats_contact_65, t51.phone_contact AS phone_contact_66, t51.twitter_contact AS twitter_contact_67, t51.validate_at AS validate_at_68, t51.id AS id_69, t51.created_at AS created_at_70, t51.updated_at AS updated_at_71, t51.is_deleted AS is_deleted_72, t51.user_id AS user_id_73, t51.validate_by_id AS validate_by_id_74, t75.balance AS balance_76, t75.pending AS pending_77, t75.incoming AS incoming_78, t75.id AS id_79, t75.created_at AS created_at_80, t75.updated_at AS updated_at_81, t75.is_deleted AS is_deleted_82, t75.user_id AS user_id_83 FROM user t0 LEFT JOIN adhesion t51 ON t51.user_id = t0.id LEFT JOIN wallet t75 ON t75.user_id = t0.id WHERE t0.api_token = ? LIMIT 1
Parameters:
[
  "eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoyOSwidXNlcm5hbWUiOiJGcm9tYWdlIiwiaWF0IjoxNjU2MzU0MzAwfQ.nbfYxD0uUwwiV7mIzGaCrycp9FMZ8158PvCN4pkf7s4"
]
0.74 ms
(16.77%)
1
SELECT t0.logo AS logo_1, t0.name AS name_2, t0.about AS about_3, t0.url AS url_4, t0.dynamic_link AS dynamic_link_5, t0.short_dynamic_link AS short_dynamic_link_6, t0.website AS website_7, t0.type AS type_8, t0.category AS category_9, t0.languages AS languages_10, t0.zones AS zones_11, t0.tel AS tel_12, t0.email1 AS email1_13, t0.email2 AS email2_14, t0.address AS address_15, t0.city AS city_16, t0.zip_code AS zip_code_17, t0.country AS country_18, t0.nbr_followers AS nbr_followers_19, t0.score AS score_20, t0.number_chats_non_lu AS number_chats_non_lu_21, t0.number_participation AS number_participation_22, t0.level AS level_23, t0.id AS id_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.is_deleted AS is_deleted_27, t0.social_media_id AS social_media_id_28, t0.created_by_id AS created_by_id_29 FROM media t0 WHERE t0.id = ?
Parameters:
[
  "26"
]
0.69 ms
(15.62%)
1
SELECT t0.id AS id_1, t0.facebook AS facebook_2, t0.instagram AS instagram_3, t0.twitter AS twitter_4, t0.snapchat AS snapchat_5, t0.youtube AS youtube_6, t7.logo AS logo_8, t7.name AS name_9, t7.about AS about_10, t7.url AS url_11, t7.dynamic_link AS dynamic_link_12, t7.short_dynamic_link AS short_dynamic_link_13, t7.website AS website_14, t7.type AS type_15, t7.category AS category_16, t7.languages AS languages_17, t7.zones AS zones_18, t7.tel AS tel_19, t7.email1 AS email1_20, t7.email2 AS email2_21, t7.address AS address_22, t7.city AS city_23, t7.zip_code AS zip_code_24, t7.country AS country_25, t7.nbr_followers AS nbr_followers_26, t7.score AS score_27, t7.number_chats_non_lu AS number_chats_non_lu_28, t7.number_participation AS number_participation_29, t7.level AS level_30, t7.id AS id_31, t7.created_at AS created_at_32, t7.updated_at AS updated_at_33, t7.is_deleted AS is_deleted_34, t7.social_media_id AS social_media_id_35, t7.created_by_id AS created_by_id_36, t37.is_suspended AS is_suspended_38, t37.logo AS logo_39, t37.name AS name_40, t37.about AS about_41, t37.url AS url_42, t37.dynamic_link AS dynamic_link_43, t37.short_dynamic_link AS short_dynamic_link_44, t37.xr_code AS xr_code_45, t37.website AS website_46, t37.tel AS tel_47, t37.email AS email_48, t37.genre AS genre_49, t37.languages AS languages_50, t37.is24h AS is24h_51, t37.time_from AS time_from_52, t37.time_to AS time_to_53, t37.day AS day_54, t37.date_from AS date_from_55, t37.date_to AS date_to_56, t37.nbr_followers AS nbr_followers_57, t37.score AS score_58, t37.number_chats_non_lu AS number_chats_non_lu_59, t37.number_participation AS number_participation_60, t37.id AS id_61, t37.created_at AS created_at_62, t37.updated_at AS updated_at_63, t37.is_deleted AS is_deleted_64, t37.media_id AS media_id_65, t37.social_media_id AS social_media_id_66, t37.created_by_id AS created_by_id_67 FROM social_media t0 LEFT JOIN media t7 ON t7.social_media_id = t0.id LEFT JOIN program t37 ON t37.social_media_id = t0.id WHERE t0.id = ?
Parameters:
[
  71
]
0.64 ms
(14.57%)
1
SELECT count(p0_.id) AS sclr_0 FROM post p0_ WHERE p0_.media_id = ? AND p0_.is_deleted = 0
Parameters:
[
  26
]
0.64 ms
(14.40%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.is_deleted AS is_deleted_4, t0.user_id AS user_id_5, t0.media_id AS media_id_6 FROM media_followers t0 WHERE t0.user_id = ? AND t0.media_id = ? LIMIT 1
Parameters:
[
  29
  26
]

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\BaseEntity No errors.
App\Entity\User
  • The mappings App\Entity\User#crews and App\Entity\Program\ProgramCrewMember#user are inconsistent with each other.
App\Entity\Adhesion No errors.
App\Entity\SuperAdmin No errors.
App\Entity\User\Wallet No errors.
App\Entity\Program\ProgramCrewMember
  • The association App\Entity\Program\ProgramCrewMember#user refers to the inverse side field App\Entity\User#crew which does not exist.
App\Entity\Media\MediaTeam No errors.
App\Entity\Media\Media No errors.
App\Entity\Shortcut No errors.
App\Entity\Media\MediaBlockedByUser No errors.
App\Entity\Program\ProgramBlockedByUser No errors.
App\Entity\Post\PostHiddenByUser No errors.
App\Entity\UserBlockedByUser No errors.
App\Entity\SocialAdhesion No errors.
App\Entity\SocialMedia No errors.
App\Entity\Program\Program No errors.
App\Entity\Post\Post No errors.
App\Entity\Chats
  • The mappings App\Entity\Chats#contents and App\Entity\ChatsContent#chat are inconsistent with each other.
App\Entity\Finance\MediaEarning No errors.
App\Entity\Media\MediaFollowers No errors.