| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| 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` >= '2026-04-22') OR (`end_date` IS NULL)) # cible : "http://refonte.wiztracker.net/en/twitch/dashboard/301900" | 0 | 0 | 1 | maybe slow |
| SELECT `Channel`.`best_engagement`, `Channel`.`country`, `Channel`.`type_country`, `Channel`.`display_name`, `Channel`.`handle`, `Channel`.`id`, `Channel`.`language`, `Channel`.`logo`, `Channel`.`most_loved`, `Channel`.`name`, `Channel`.`score`, `Channel`.`subscribers`, `Channel`.`subscribers_1m`, `Channel`.`summary`, `Channel`.`auto_summary_fr`, `Channel`.`auto_summary_en`, `Channel`.`auto_themes_fr`, `Channel`.`auto_themes_en`, `Channel`.`source`, `Channel`.`tracking_level`, `Channel`.`comments_tracking_level`, `Channel`.`videos`, `Channel`.`videos_1m`, `Channel`.`videos_uploaded`, `Channel`.`videos_uploaded_1w`, `Channel`.`videos_uploaded_1m`, `Channel`.`videos_uploaded_3m`, `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`.`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_channel_id`, `Channel`.`twitch_followers`, `Channel`.`tiktok_username`, `Channel`.`tiktok_followers`, `Channel`.`id_instagram`, `Channel`.`followers_instagram`, `Channel`.`id_twitter`, `Channel`.`followers_twitter`, `Channel`.`id_facebook`, `Channel`.`followers_facebook`, `Channel`.`30d_median_views`, `Channel`.`twitch_username`, `Channel`.`twitch_avg_viewers`, `Channel`.`twitch_language`, `ContentOwner`.`id`, `ContentOwner`.`display_name`, `ContentOwner`.`type`, `YtmpContentOwner`.`id`, `YtmpContentOwner`.`display_name`, `TwitchChannel`.*, `TwitchChannel`.`id` 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`.`twitch_channels` AS `TwitchChannel` ON (`Channel`.`twitch_channel_id` = `TwitchChannel`.`id` AND `TwitchChannel`.`tracking_level` < 300) WHERE `Channel`.`id` = 301900 AND `Channel`.`tracking_level` < 300 LIMIT 1 # cible : "http://refonte.wiztracker.net/en/twitch/dashboard/301900" | 1 | 1 | 2 | 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` = (301900) # cible : "http://refonte.wiztracker.net/en/twitch/dashboard/301900" | 2 | 2 | 2 | |
| SELECT `Token`.`id`, `Token`.`user_id`, `Token`.`type`, `Token`.`cms_partner`, `Token`.`token`, `Token`.`google_id`, `Token`.`google_name`, `Token`.`valid_token`, `Token`.`created`, `Token`.`modified`, (SELECT COUNT(*) FROM share_rights WHERE target_type = "token" AND target_id = `Token`.`id`) AS `Token__shares_count` FROM `wiztracker`.`tokens` AS `Token` WHERE `Token`.`id` = 1798 # cible : "http://refonte.wiztracker.net/en/twitch/dashboard/301900" | 1 | 1 | 6 | maybe slow |
| SELECT `Token`.`id`, `Token`.`user_id`, `Token`.`type`, `Token`.`cms_partner`, `Token`.`token`, `Token`.`google_id`, `Token`.`google_name`, `Token`.`valid_token`, `Token`.`created`, `Token`.`modified`, (SELECT COUNT(*) FROM share_rights WHERE target_type = "token" AND target_id = `Token`.`id`) AS `Token__shares_count` FROM `wiztracker`.`tokens` AS `Token` WHERE `Token`.`id` = 2977 # cible : "http://refonte.wiztracker.net/en/twitch/dashboard/301900" | 1 | 1 | 2 | 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` = 301900 AND `CategoriesChannel`.`category_id` = `Category`.`id`) # cible : "http://refonte.wiztracker.net/en/twitch/dashboard/301900" | 1 | 1 | 2 | maybe slow |
| 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` = 301900 AND `ChannelsContactEmail`.`contact_email_id` = `ContactEmail`.`id`) # cible : "http://refonte.wiztracker.net/en/twitch/dashboard/301900" | 2 | 2 | 2 | |
| 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://refonte.wiztracker.net/en/twitch/dashboard/301900" | 1 | 1 | 1 | |
| 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` = 301900 AND `ManagedChannel`.`user_id` IS NULL AND `Token`.`valid_token` = '1' LIMIT 1 # cible : "http://refonte.wiztracker.net/en/twitch/dashboard/301900" | 0 | 0 | 1 | maybe slow |
| SELECT `TwitchChannelsGame`.`id`, `TwitchChannelsGame`.`twitch_channel_id`, `TwitchChannelsGame`.`twitch_game_id`, `TwitchChannelsGame`.`sessions`, `TwitchChannelsGame`.`percentage`, `TwitchChannelsGame`.`performance_score` FROM `wiztracker`.`twitch_channels_games` AS `TwitchChannelsGame` WHERE `twitch_channel_id` = 70298660 ORDER BY `percentage` desc # cible : "http://refonte.wiztracker.net/en/twitch/dashboard/301900" | 15 | 15 | 3 | maybe slow |
| SELECT `TwitchChannelsCrosscheck`.`similarity`, (IF ( `TwitchChannel1`.`id`=70298660, `TwitchChannel2`.`id`, `TwitchChannel1`.`id`)) AS `TwitchChannelsCrosscheck__twitch_channel_id` FROM `wiztracker`.`twitch_channels_crosschecks` AS `TwitchChannelsCrosscheck` LEFT JOIN `wiztracker`.`twitch_channels` AS `TwitchChannel1` ON (`TwitchChannelsCrosscheck`.`twitch_channel_id1` = `TwitchChannel1`.`id`) LEFT JOIN `wiztracker`.`twitch_channels` AS `TwitchChannel2` ON (`TwitchChannelsCrosscheck`.`twitch_channel_id2` = `TwitchChannel2`.`id`) WHERE ((`TwitchChannelsCrosscheck`.`twitch_channel_id1` = 70298660) OR (`TwitchChannelsCrosscheck`.`twitch_channel_id2` = 70298660)) AND `TwitchChannel1`.`tracking_level` <= 200 AND `TwitchChannel2`.`tracking_level` <= 200 ORDER BY `similarity` desc # cible : "http://refonte.wiztracker.net/en/twitch/dashboard/301900" | 169 | 169 | 58 | maybe slow |
| SELECT `TwitchChannel`.`id`, `TwitchChannel`.`login`, `TwitchChannel`.`display_name`, `TwitchChannel`.`logo` FROM `wiztracker`.`twitch_channels` AS `TwitchChannel` WHERE `id` IN (75985070, 211024421, 124147323, 120602319, 118652300, 139887547, 576114251, 81410999, 483639572, 137472142, 234456766, 412354630, 270997352, 50782699, 105868452, 60408047, 505902512, 61971624, 86696866, 443878817, 58828681, 53882121, 110902144, 64556262, 20491166, 183215477, 99884802, 466698718, 83666978, 158787806, 499665727, 66245159, 107220879, 276821855, 62658190, 29315858, 522680774, 29146922, 44578782, 89195977, 137204382, 83292411, 211232176, 169787686, 91068970, 44599860, 65936047, 50645402, 121867470, 30136543, 105649767, 120284135, 617654611, 687934827, 86427693, 151767660, 197886470, 655088971, 132501030, 180608309, 497641799, 432135894, 101270580, 498861294, 239757490, 228829539, 222511852, 85268580, 96195366, 82233972, 118817200, 190145142, 427035204, 109166621, 132462693, 648874833, 62792142, 637113880, 96022899, 265693374, 403220177, 415027220, 187939516, 457124238, 98023559, 99192755, 177515814, 257674016, 488678599, 95799279, 49639932, 150044844, 457299159, 469348555, 699067201, 64086944, 749344479, 20850617, 86996416, 39392997, 193651450, 417227381, 166873069, 419144828, 525703416, 44498588, 138732730, 527115020, 35733969, 36453924, 112697245, 138669488, 147448075, 169256877, 27920057, 464167771, 479251203, 106729463, 450171112, 599549933, 135200947, 408067169, 647373648, 129049172, 151920918, 106428205, 108523725, 108955847, 659951901, 78825795, 63180918, 166443568, 466603236, 94124693, 41727944, 118385536, 127826699, 141163557, 492044551, 156308991, 433872792, 714058308, 117401940, 646892065, 95283023, 26465197, 119879176, 136588633, 502105403, 101248865, 115203601, 145254305, 160824044, 60043099, 197074157, 477387693, 8219915, 36029255, 110612975, 124498916, 476358301, 544502795, 652385142, 85559397, 29166361, 456790583, 595999910, 659442470, 79880511) # cible : "http://refonte.wiztracker.net/en/twitch/dashboard/301900" | 169 | 169 | 3 | |
| SELECT `Channel`.`id`, `Channel`.`twitch_channel_id`, `Channel`.`yt_user_id` FROM `wiztracker`.`channels` AS `Channel` WHERE `twitch_channel_id` IN (8219915, 20491166, 20850617, 26465197, 27920057, 29146922, 29166361, 29315858, 30136543, 35733969, 36029255, 36453924, 39392997, 41727944, 44498588, 44578782, 44599860, 49639932, 50645402, 50782699, 53882121, 58828681, 60043099, 60408047, 61971624, 62658190, 62792142, 63180918, 64086944, 64556262, 65936047, 66245159, 75985070, 78825795, 79880511, 81410999, 82233972, 83292411, 83666978, 85268580, 85559397, 86427693, 86696866, 86996416, 89195977, 91068970, 94124693, 95283023, 95799279, 96022899, 96195366, 98023559, 99192755, 99884802, 101248865, 101270580, 105649767, 105868452, 106428205, 106729463, 107220879, 108523725, 108955847, 109166621, 110612975, 110902144, 112697245, 115203601, 117401940, 118385536, 118652300, 118817200, 119879176, 120284135, 120602319, 121867470, 124147323, 124498916, 127826699, 129049172, 132462693, 132501030, 135200947, 136588633, 137204382, 137472142, 138669488, 138732730, 139887547, 141163557, 145254305, 147448075, 150044844, 151767660, 151920918, 156308991, 158787806, 160824044, 166443568, 166873069, 169256877, 169787686, 177515814, 180608309, 183215477, 187939516, 190145142, 193651450, 197074157, 197886470, 211024421, 211232176, 222511852, 228829539, 234456766, 239757490, 257674016, 265693374, 270997352, 276821855, 403220177, 408067169, 412354630, 415027220, 417227381, 419144828, 427035204, 432135894, 433872792, 443878817, 450171112, 456790583, 457124238, 457299159, 464167771, 466603236, 466698718, 469348555, 476358301, 477387693, 479251203, 483639572, 488678599, 492044551, 497641799, 498861294, 499665727, 502105403, 505902512, 522680774, 525703416, 527115020, 544502795, 576114251, 595999910, 599549933, 617654611, 637113880, 646892065, 647373648, 648874833, 652385142, 655088971, 659442470, 659951901, 687934827, 699067201, 714058308, 749344479) AND `tracking_level` < 300 # cible : "http://refonte.wiztracker.net/en/twitch/dashboard/301900" | 1 | 1 | 4 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `wiztracker`.`company_strikes` AS `CompanyStrike` WHERE `company_id` IS NULL AND `channel_id` = 301900 # cible : "http://refonte.wiztracker.net/en/twitch/dashboard/301900" | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `wiztracker`.`company_claims` AS `CompanyClaim` WHERE `company_id` IS NULL AND `channel_id` = 301900 # cible : "http://refonte.wiztracker.net/en/twitch/dashboard/301900" | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `wiztracker`.`channel_monthly_earnings` AS `ChannelMonthlyEarning` WHERE `channel_id` = 301900 # cible : "http://refonte.wiztracker.net/en/twitch/dashboard/301900" | 1 | 1 | 1 | |
| SELECT `ChannelZohoAccount`.`id`, `ChannelZohoAccount`.`zoho_id` FROM `wiztracker`.`channel_zoho_accounts` AS `ChannelZohoAccount` WHERE `channel_id` = 301900 # cible : "http://refonte.wiztracker.net/en/twitch/dashboard/301900" | 3 | 3 | 2 | maybe slow |