| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `wiztracker`.`wizdeo_sessions` AS `Session` WHERE `Session`.`id` = 'ea51q4md1u4ioeu6cr5fvui09j' LIMIT 1 # cible : "http://analytics.wizdeo.com/en/influencers/twitter/2205984" | 0 | 0 | 1 | maybe slow |
| SELECT `NewsFeature`.`id`, `NewsFeature`.`univers`, `NewsFeature`.`level`, `NewsFeature`.`start_date`, `NewsFeature`.`end_date`, `NewsFeature`.`text_fr`, `NewsFeature`.`text_en`, `NewsFeature`.`test_mode`, `NewsFeature`.`created`, `NewsFeature`.`modified` FROM `wiztracker`.`news_features` AS `NewsFeature` WHERE ((`end_date` >= '2021-09-22') OR (`end_date` IS NULL)) # cible : "http://analytics.wizdeo.com/en/influencers/twitter/2205984" | 0 | 0 | 1 | maybe slow |
| SELECT `Channel`.`best_engagement`, `Channel`.`country`, `Channel`.`type_country`, `Channel`.`display_name`, `Channel`.`id`, `Channel`.`language`, `Channel`.`logo`, `Channel`.`most_loved`, `Channel`.`name`, `Channel`.`score`, `Channel`.`subscribers`, `Channel`.`subscribers_1m`, `Channel`.`summary`, `Channel`.`source`, `Channel`.`tracking_level`, `Channel`.`comments_tracking_level`, `Channel`.`videos`, `Channel`.`videos_1m`, `Channel`.`videos_uploaded_1m`, `Channel`.`videos_views`, `Channel`.`videos_views_1m`, `Channel`.`videos_views_1w`, `Channel`.`yt_user_id`, `Channel`.`30d_average_views`, `Channel`.`30d_stats_type`, `Channel`.`30d_best_engagement_rate`, `Channel`.`autotracking_status`, `Channel`.`autotracking_last`, `Channel`.`audit_content_owner_last`, `Channel`.`audit_content_owner_status`, `Channel`.`forecast_views`, `Channel`.`banner`, `Channel`.`likes`, `Channel`.`likes_1m`, `Channel`.`dislikes`, `Channel`.`dislikes_1m`, `Channel`.`comments`, `Channel`.`comments_1m`, `Channel`.`watchtime`, `Channel`.`is_hide_private_datas`, `Channel`.`avg_videos_watchtime`, `Channel`.`is_brand`, `Channel`.`is_media`, `Channel`.`is_creator`, `Channel`.`is_broadcaster`, `Channel`.`email`, `Channel`.`creator_email`, `Channel`.`overall_good_standing`, `Channel`.`community_guidelines_good_standing`, `Channel`.`copyright_strikes_good_standing`, `Channel`.`content_id_claims_good_standing`, `Channel`.`licensed_content`, `Channel`.`ad_reserved_percentage`, `Channel`.`made_for_kids`, `Channel`.`made_for_kids_ratio`, `Channel`.`twitch_followers`, `Channel`.`tiktok_followers`, `Channel`.`30d_median_views`, `ContentOwner`.`id`, `ContentOwner`.`display_name`, `ContentOwner`.`type`, `YtmpContentOwner`.`id`, `YtmpContentOwner`.`display_name`, `Creator`.`id`, `Creator`.`name`, `Creator`.`youtube_subscribers`, `Creator`.`youtube_main_id`, `Creator`.`facebook_main_id`, `Creator`.`facebook_fans`, `Creator`.`instagram_main_id`, `Creator`.`instagram_followers`, `Creator`.`twitter_main_id`, `Creator`.`twitter_followers` FROM `wiztracker`.`channels` AS `Channel` LEFT JOIN `wiztracker`.`content_owners` AS `ContentOwner` ON (`Channel`.`content_owner_id` = `ContentOwner`.`id`) LEFT JOIN `wiztracker`.`ytmp_content_owners` AS `YtmpContentOwner` ON (`Channel`.`ytmp_content_owner_id` = `YtmpContentOwner`.`id`) LEFT JOIN `wiztracker`.`creators` AS `Creator` ON (`Channel`.`creator_id` = `Creator`.`id`) WHERE `Channel`.`id` = 2205984 AND `Channel`.`tracking_level` < 300 LIMIT 1 # cible : "http://analytics.wizdeo.com/en/influencers/twitter/2205984" | 1 | 1 | 4 | maybe slow |
| SELECT `ManagedChannel`.`id`, `ManagedChannel`.`yt_id`, `ManagedChannel`.`channel_id`, `ManagedChannel`.`user_id`, `ManagedChannel`.`token_id`, `ManagedChannel`.`last_refresh_video`, `ManagedChannel`.`first_track_done`, `ManagedChannel`.`created`, `ManagedChannel`.`modified` FROM `wiztracker`.`managed_channels` AS `ManagedChannel` WHERE `ManagedChannel`.`channel_id` = (2205984) # cible : "http://analytics.wizdeo.com/en/influencers/twitter/2205984" | 0 | 0 | 1 | maybe slow |
| SELECT `Topicchannel`.`id`, `Topicchannel`.`yt_id`, `Topicchannel`.`type`, `Topicchannel`.`name`, `Topicchannel`.`logo`, `Topicchannel`.`twitch_id`, `Topicchannel`.`twitch_name`, `Topicchannel`.`twitch_logo`, `Topicchannel`.`created`, `Topicchannel`.`modified`, `ChannelsTopicchannel`.`id`, `ChannelsTopicchannel`.`channel_id`, `ChannelsTopicchannel`.`topicchannel_id`, `ChannelsTopicchannel`.`videos`, `ChannelsTopicchannel`.`percentage`, `ChannelsTopicchannel`.`performance_score` FROM `wiztracker`.`topicchannels` AS `Topicchannel` JOIN `wiztracker`.`channels_topicchannels` AS `ChannelsTopicchannel` ON (`ChannelsTopicchannel`.`channel_id` = 2205984 AND `ChannelsTopicchannel`.`topicchannel_id` = `Topicchannel`.`id`) WHERE twitch_id is not null ORDER BY `percentage` desc # cible : "http://analytics.wizdeo.com/en/influencers/twitter/2205984" | 0 | 0 | 1 | maybe slow |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`name_fra`, `Category`.`description`, `Category`.`fi_icon`, `Category`.`icon`, `Category`.`yt_category`, `CategoriesChannel`.`id`, `CategoriesChannel`.`category_id`, `CategoriesChannel`.`channel_id` FROM `wiztracker`.`categories` AS `Category` JOIN `wiztracker`.`categories_channels` AS `CategoriesChannel` ON (`CategoriesChannel`.`channel_id` = 2205984 AND `CategoriesChannel`.`category_id` = `Category`.`id`) # cible : "http://analytics.wizdeo.com/en/influencers/twitter/2205984" | 1 | 1 | 1 | |
| SELECT `ContactEmail`.`id`, `ContactEmail`.`email`, `ContactEmail`.`is_agent`, `ContactEmail`.`created`, `ContactEmail`.`modified`, `ChannelsContactEmail`.`id`, `ChannelsContactEmail`.`channel_id`, `ChannelsContactEmail`.`contact_email_id`, `ChannelsContactEmail`.`sources`, `ChannelsContactEmail`.`created`, `ChannelsContactEmail`.`modified` FROM `wiztracker`.`contact_emails` AS `ContactEmail` JOIN `wiztracker`.`channels_contact_emails` AS `ChannelsContactEmail` ON (`ChannelsContactEmail`.`channel_id` = 2205984 AND `ChannelsContactEmail`.`contact_email_id` = `ContactEmail`.`id`) # cible : "http://analytics.wizdeo.com/en/influencers/twitter/2205984" | 0 | 0 | 1 | maybe slow |
| SELECT `ContentOwner`.`id`, `ContentOwner`.`code`, `ContentOwner`.`name`, `ContentOwner`.`display_name`, `ContentOwner`.`partner_mail`, `ContentOwner`.`type`, `ContentOwner`.`created`, `ContentOwner`.`modified` FROM `wiztracker`.`content_owners` AS `ContentOwner` WHERE `code` = 'youtube_partner' LIMIT 1 # cible : "http://analytics.wizdeo.com/en/influencers/twitter/2205984" | 1 | 1 | 0 | |
| SELECT `ChannelsGroup`.`group_id` FROM `wiztracker`.`channels_groups` AS `ChannelsGroup` WHERE `channel_id` = 2205984 # cible : "http://analytics.wizdeo.com/en/influencers/twitter/2205984" | 3 | 3 | 1 | maybe slow |
| SELECT `Group`.`id`, `Group`.`group_type_id` FROM `wiztracker`.`groups` AS `Group` LEFT JOIN `wiztracker`.`group_types` AS `GroupType` ON (`Group`.`group_type_id` = `GroupType`.`id`) WHERE `Group`.`group_type_id` IN (8, 12) AND `Group`.`id` IN (898, 3802, 5442) # cible : "http://analytics.wizdeo.com/en/influencers/twitter/2205984" | 0 | 0 | 1 | maybe slow |
| SELECT `ManagedChannel`.`id`, `ManagedChannel`.`yt_id`, `ManagedChannel`.`channel_id`, `ManagedChannel`.`user_id`, `ManagedChannel`.`token_id`, `ManagedChannel`.`last_refresh_video`, `ManagedChannel`.`first_track_done`, `ManagedChannel`.`created`, `ManagedChannel`.`modified`, `Token`.`id`, `Token`.`user_id`, `Token`.`valid_token` FROM `wiztracker`.`managed_channels` AS `ManagedChannel` LEFT JOIN `wiztracker`.`tokens` AS `Token` ON (`ManagedChannel`.`token_id` = `Token`.`id`) WHERE `ManagedChannel`.`channel_id` = 2205984 AND `ManagedChannel`.`user_id` IS NULL AND `Token`.`valid_token` = '1' LIMIT 1 # cible : "http://analytics.wizdeo.com/en/influencers/twitter/2205984" | 0 | 0 | 1 | maybe slow |
| SELECT `TwitterInfluencer`.`id`, `TwitterInfluencer`.`extern_id`, `TwitterInfluencer`.`channel_id`, `TwitterInfluencer`.`follower_name`, `TwitterInfluencer`.`id_twitter`, `TwitterInfluencer`.`id_of_tweet`, `TwitterInfluencer`.`nb_follower`, `TwitterInfluencer`.`thumb`, `TwitterInfluencer`.`created`, `TwitterInfluencer`.`modified` FROM `wiztracker`.`twitter_influencers` AS `TwitterInfluencer` WHERE `TwitterInfluencer`.`extern_id` IN ('LQd4Aty3ieg', 'mcQj11l-aNo', 'fcau5JzeEmA', 'WjFrpz7ceNY', 'WGINaBiaTd8', 'Yh0rKAoKCic', '12Xacr6pVtE', 'dFtbwdTZhec', 'UBICz01PcNM', 'db-O_jEVEvU', 'n7_gT_hHdDQ', 'ayBCU1jC8Jc', 'ANKfcCQO_Jg', 'JS8SQBfZjrg', 'eu3ncE1TC9k', 'mXupb_purKY', 'Th_a2DJa6i4', 'akzmwZuWDOM', '-nGZhAgZFQU', 'ahurvTA1TkQ', '4D9BJvjdsOw', 'X6rbcU0TqUI', 'OQKcoVyRmgc', 'j2ycgTJCn68', 'eHb33AkEgdU') ORDER BY `TwitterInfluencer`.`nb_follower` desc # cible : "http://analytics.wizdeo.com/en/influencers/twitter/2205984" | 0 | 0 | 20 | maybe slow |
| SELECT `Channel`.`best_engagement`, `Channel`.`display_name`, `Channel`.`id`, `Channel`.`logo`, `Channel`.`most_loved`, `Channel`.`name`, `Channel`.`score`, `Channel`.`subscribers`, `Channel`.`subscribers_1d`, `Channel`.`subscribers_1m`, `Channel`.`subscribers_1w`, `Channel`.`videos`, `Channel`.`videos_views`, `Channel`.`videos_views_1d`, `Channel`.`videos_views_1m`, `Channel`.`videos_views_1w`, `Channel`.`yt_user_id` FROM `wiztracker`.`channels` AS `Channel` WHERE `Channel`.`id` = 2205984 LIMIT 1 # cible : "http://analytics.wizdeo.com/en/influencers/twitter/2205984" | 1 | 1 | 1 | |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`name_fra`, `Category`.`description`, `Category`.`fi_icon`, `Category`.`icon`, `Category`.`yt_category` FROM `wiztracker`.`categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`name` ASC # cible : "http://analytics.wizdeo.com/en/influencers/twitter/2205984" | 14 | 14 | 1 | maybe slow |
| SELECT `CopyrightsMonetization`.`id`, `CopyrightsMonetization`.`user_id`, `CopyrightsMonetization`.`status` FROM `wiztracker`.`copyrights_monetizations` AS `CopyrightsMonetization` WHERE `channel_id` = 2205984 LIMIT 1 # cible : "http://analytics.wizdeo.com/en/influencers/twitter/2205984" | 0 | 0 | 3 | maybe slow |
Français
Creator dashboard