Query Metrics
5
Database Queries
5
Different statements
4.41 ms
Query time
3
Invalid entities
Grouped Statements
| 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 |
|
| App\Entity\Adhesion | No errors. |
| App\Entity\SuperAdmin | No errors. |
| App\Entity\User\Wallet | No errors. |
| App\Entity\Program\ProgramCrewMember |
|
| 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 |
|
| App\Entity\Finance\MediaEarning | No errors. |
| App\Entity\Media\MediaFollowers | No errors. |