| 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/fr/twitch/dashboard/2415332" | 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` = 2415332 AND `Channel`.`tracking_level` < 300 LIMIT 1 # cible : "http://refonte.wiztracker.net/fr/twitch/dashboard/2415332" | 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` = (2415332) # cible : "http://refonte.wiztracker.net/fr/twitch/dashboard/2415332" | 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` = 2415332 AND `CategoriesChannel`.`category_id` = `Category`.`id`) # cible : "http://refonte.wiztracker.net/fr/twitch/dashboard/2415332" | 1 | 1 | 3 | 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` = 2415332 AND `ChannelsContactEmail`.`contact_email_id` = `ContactEmail`.`id`) # cible : "http://refonte.wiztracker.net/fr/twitch/dashboard/2415332" | 2 | 2 | 5 | 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://refonte.wiztracker.net/fr/twitch/dashboard/2415332" | 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`, `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` = 2415332 AND `ManagedChannel`.`user_id` IS NULL AND `Token`.`valid_token` = '1' LIMIT 1 # cible : "http://refonte.wiztracker.net/fr/twitch/dashboard/2415332" | 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` = 222511852 ORDER BY `percentage` desc # cible : "http://refonte.wiztracker.net/fr/twitch/dashboard/2415332" | 12 | 12 | 7 | maybe slow |
| SELECT `TwitchChannelsCrosscheck`.`similarity`, (IF ( `TwitchChannel1`.`id`=222511852, `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` = 222511852) OR (`TwitchChannelsCrosscheck`.`twitch_channel_id2` = 222511852)) AND `TwitchChannel1`.`tracking_level` <= 200 AND `TwitchChannel2`.`tracking_level` <= 200 ORDER BY `similarity` desc # cible : "http://refonte.wiztracker.net/fr/twitch/dashboard/2415332" | 341 | 341 | 353 | maybe slow |
| SELECT `TwitchChannel`.`id`, `TwitchChannel`.`login`, `TwitchChannel`.`display_name`, `TwitchChannel`.`logo` FROM `wiztracker`.`twitch_channels` AS `TwitchChannel` WHERE `id` IN (427828010, 498861294, 58074830, 74397555, 187939516, 60413469, 523692922, 151219596, 244366849, 407837457, 101248865, 129163519, 177671609, 92113668, 101270580, 27115917, 60708716, 23668995, 133709954, 87184624, 135207782, 427035204, 123579297, 44578782, 72371587, 119657765, 749344479, 25454398, 85800130, 92537604, 173713008, 553783013, 235693408, 171364604, 211024421, 463650673, 90250629, 24147592, 465726306, 75985070, 42141251, 63936838, 196910625, 448841993, 128368067, 413054555, 31813025, 231634715, 598300995, 87399830, 161168700, 114497555, 63985840, 53882121, 52130765, 96562014, 110119637, 89471706, 169256877, 186259410, 643055332, 197074157, 98359082, 175560856, 211232176, 413138671, 105909590, 138347708, 483639572, 75701802, 58828681, 408067169, 198882188, 40063341, 60256640, 52803405, 137347549, 141490402, 131215608, 105868452, 27641920, 250181063, 63675549, 187531943, 544340296, 61971624, 117848541, 152954848, 84539108, 124147323, 155601320, 44960888, 118652300, 88301612, 29146922, 144395004, 26567552, 598462554, 170547313, 38973058, 608852885, 110902144, 113511896, 89872865, 36318615, 268053553, 39393054, 70298660, 412354630, 180608309, 29979365, 53641088, 270997352, 147337432, 183215477, 520035253, 93109827, 74429531, 511446519, 121445595, 193257984, 120602319, 23365180, 450171112, 38009333, 30709418, 139887547, 114119743, 81410999, 97372153, 107220879, 574802385, 72480716, 113342023, 103824525, 81079419, 77452537, 125323544, 121954515, 37547034, 118187067, 121767601, 275272993, 77456419, 446661471, 174955366, 53226469, 82144721, 90481777, 95799279, 138732730, 505902512, 26512861, 412066833, 64556262, 40740351, 152454625, 172531433, 37523739, 443878817, 625931244, 42541814, 27085209, 32183344, 56097532, 73486167, 81446331, 76948012, 137204382, 198506129, 241808969, 433872792, 27621732, 5856979, 87805484, 121867470, 169787686, 197811341, 105438356, 214575464, 440229923, 94299081, 85876549, 115695918, 129049172, 50597026, 69592711, 170078223, 52982018, 126695000, 169527258, 194431028, 486205216, 60567455, 78705692, 106669629, 130152638, 415027220, 39129104, 49128094, 105816275, 2921872, 184782022, 65936047, 66245159, 74391737, 84021070, 121192207, 140603156, 46273243, 432135894, 480851634, 84240904, 98764054, 89203053, 168114707, 121652526, 276821855, 117323707, 497307574, 52616898, 117011503, 210651138, 612648081, 622498423, 31952238, 37165813, 100744948, 119626447, 30023985, 262227458, 552015849, 28575692, 46516676, 89204267, 83036580, 89047775, 19104675, 29315858, 43976593, 65602375, 108955847, 116094440, 187998818, 200427848, 473183066, 24030910, 31124525, 43993381, 88524154, 101234264, 135468063, 24306397, 29753247, 63245740, 72915687, 127826699, 150315224, 434081240, 41719107, 52349411, 70915697, 97344093, 120284135, 152088629, 23370689, 36086436, 110926030, 126360993, 185261350, 441437466, 48350819, 50091633, 64965465, 617654611, 36453924, 38466285, 38975140, 65830750, 95424054, 124403155, 146949465, 147539451, 161006524, 253069402, 424397040, 522415398, 576114251, 68078157, 183819202, 44599860, 11249217, 151874024, 219812342, 229714332, 273839506, 674898598, 30136543, 91068970, 90911923, 78119719, 109306231, 112309669, 493980401, 663790329, 60408047, 69722805, 105368201, 125260461, 162957501, 279263663, 404878236, 445529741, 488327284, 495010090, 528060516, 29188740, 38350595, 49035758, 58737711, 62759094, 76846779, 95283023, 90097443, 133268904, 133993495, 145169731, 148318614, 152360150, 189560195, 203202724, 20850617, 264620638, 478715115, 499665727, 580994316, 29537514, 43102846, 50782699, 53571235, 62792142) # cible : "http://refonte.wiztracker.net/fr/twitch/dashboard/2415332" | 341 | 341 | 4 | |
| SELECT `Channel`.`id`, `Channel`.`twitch_channel_id`, `Channel`.`yt_user_id` FROM `wiztracker`.`channels` AS `Channel` WHERE `twitch_channel_id` IN (2921872, 5856979, 11249217, 19104675, 20850617, 23365180, 23370689, 23668995, 24030910, 24147592, 24306397, 25454398, 26512861, 26567552, 27085209, 27115917, 27621732, 27641920, 28575692, 29146922, 29188740, 29315858, 29537514, 29753247, 29979365, 30023985, 30136543, 30709418, 31124525, 31813025, 31952238, 32183344, 36086436, 36318615, 36453924, 37165813, 37523739, 37547034, 38009333, 38350595, 38466285, 38973058, 38975140, 39129104, 39393054, 40063341, 40740351, 41719107, 42141251, 42541814, 43102846, 43976593, 43993381, 44578782, 44599860, 44960888, 46273243, 46516676, 48350819, 49035758, 49128094, 50091633, 50597026, 50782699, 52130765, 52349411, 52616898, 52803405, 52982018, 53226469, 53571235, 53641088, 53882121, 56097532, 58074830, 58737711, 58828681, 60256640, 60408047, 60413469, 60567455, 60708716, 61971624, 62759094, 62792142, 63245740, 63675549, 63936838, 63985840, 64556262, 64965465, 65602375, 65830750, 65936047, 66245159, 68078157, 69592711, 69722805, 70298660, 70915697, 72371587, 72480716, 72915687, 73486167, 74391737, 74397555, 74429531, 75701802, 75985070, 76846779, 76948012, 77452537, 77456419, 78119719, 78705692, 81079419, 81410999, 81446331, 82144721, 83036580, 84021070, 84240904, 84539108, 85800130, 85876549, 87184624, 87399830, 87805484, 88301612, 88524154, 89047775, 89203053, 89204267, 89471706, 89872865, 90097443, 90250629, 90481777, 90911923, 91068970, 92113668, 92537604, 93109827, 94299081, 95283023, 95424054, 95799279, 96562014, 97344093, 97372153, 98359082, 98764054, 100744948, 101234264, 101248865, 101270580, 103824525, 105368201, 105438356, 105816275, 105868452, 105909590, 106669629, 107220879, 108955847, 109306231, 110119637, 110902144, 110926030, 112309669, 113342023, 113511896, 114119743, 114497555, 115695918, 116094440, 117011503, 117323707, 117848541, 118187067, 118652300, 119626447, 119657765, 120284135, 120602319, 121192207, 121445595, 121652526, 121767601, 121867470, 121954515, 123579297, 124147323, 124403155, 125260461, 125323544, 126360993, 126695000, 127826699, 128368067, 129049172, 129163519, 130152638, 131215608, 133268904, 133709954, 133993495, 135207782, 135468063, 137204382, 137347549, 138347708, 138732730, 139887547, 140603156, 141490402, 144395004, 145169731, 146949465, 147337432, 147539451, 148318614, 150315224, 151219596, 151874024, 152088629, 152360150, 152454625, 152954848, 155601320, 161006524, 161168700, 162957501, 168114707, 169256877, 169527258, 169787686, 170078223, 170547313, 171364604, 172531433, 173713008, 174955366, 175560856, 177671609, 180608309, 183215477, 183819202, 184782022, 185261350, 186259410, 187531943, 187939516, 187998818, 189560195, 193257984, 194431028, 196910625, 197074157, 197811341, 198506129, 198882188, 200427848, 203202724, 210651138, 211024421, 211232176, 214575464, 219812342, 229714332, 231634715, 235693408, 241808969, 244366849, 250181063, 253069402, 262227458, 264620638, 268053553, 270997352, 273839506, 275272993, 276821855, 279263663, 404878236, 407837457, 408067169, 412066833, 412354630, 413054555, 413138671, 415027220, 424397040, 427035204, 427828010, 432135894, 433872792, 434081240, 440229923, 441437466, 443878817, 445529741, 446661471, 448841993, 450171112, 463650673, 465726306, 473183066, 478715115, 480851634, 483639572, 486205216, 488327284, 493980401, 495010090, 497307574, 498861294, 499665727, 505902512, 511446519, 520035253, 522415398, 523692922, 528060516, 544340296, 552015849, 553783013, 574802385, 576114251, 580994316, 598300995, 598462554, 608852885, 612648081, 617654611, 622498423, 625931244, 643055332, 663790329, 674898598, 749344479) AND `tracking_level` < 300 # cible : "http://refonte.wiztracker.net/fr/twitch/dashboard/2415332" | 266 | 266 | 40 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `wiztracker`.`company_strikes` AS `CompanyStrike` WHERE `company_id` IS NULL AND `channel_id` = 2415332 # cible : "http://refonte.wiztracker.net/fr/twitch/dashboard/2415332" | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `wiztracker`.`company_claims` AS `CompanyClaim` WHERE `company_id` IS NULL AND `channel_id` = 2415332 # cible : "http://refonte.wiztracker.net/fr/twitch/dashboard/2415332" | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `wiztracker`.`channel_monthly_earnings` AS `ChannelMonthlyEarning` WHERE `channel_id` = 2415332 # cible : "http://refonte.wiztracker.net/fr/twitch/dashboard/2415332" | 1 | 1 | 1 | |
| SELECT `ChannelZohoAccount`.`id`, `ChannelZohoAccount`.`zoho_id` FROM `wiztracker`.`channel_zoho_accounts` AS `ChannelZohoAccount` WHERE `channel_id` = 2415332 # cible : "http://refonte.wiztracker.net/fr/twitch/dashboard/2415332" | 1 | 1 | 5 | maybe slow |