| 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-11-02') OR (`end_date` IS NULL)) # cible : "http://refonte.wiztracker.net/fr/channels/detail/2477187/PresentHunt" | 0 | 0 | 1 | maybe slow |
| SELECT `ManagedChannel`.`channel_id`, `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` = 2477187 AND `ManagedChannel`.`user_id` IS NULL AND `Token`.`valid_token` = '1' LIMIT 1 # cible : "http://refonte.wiztracker.net/fr/channels/detail/2477187/PresentHunt" | 0 | 0 | 1 | maybe slow |
| SELECT `Channel`.`banner`, `Channel`.`country`, `Channel`.`display_name`, `Channel`.`followers_facebook`, `Channel`.`followers_instagram`, `Channel`.`followers_twitter`, `Channel`.`handle`, `Channel`.`id`, `Channel`.`id_facebook`, `Channel`.`id_instagram`, `Channel`.`id_twitter`, `Channel`.`is_brand`, `Channel`.`is_media`, `Channel`.`language`, `Channel`.`logo`, `Channel`.`made_for_kids`, `Channel`.`made_for_kids_ratio`, `Channel`.`score`, `Channel`.`subscribers`, `Channel`.`summary`, `Channel`.`tracking_level`, `Channel`.`tiktok_followers`, `Channel`.`tiktok_username`, `Channel`.`twitch_channel_id`, `Channel`.`videos`, `Channel`.`videos_views`, `Channel`.`yt_user_id`, `Channel`.`auto_summary_fr`, `Channel`.`auto_themes_fr`, `Channel`.`auto_summary_en`, `Channel`.`auto_themes_en`, `Channel`.`autotracking_last`, `Channel`.`autotracking_status`, `Channel`.`dedicated_video_yt_id`, `Channel`.`email`, `Channel`.`creator_email`, `Channel`.`commercial_description`, `Channel`.`community_guidelines_good_standing`, `Channel`.`copyright_strikes_good_standing`, `Channel`.`instagram_post_id`, `Channel`.`instagram_post_pricing`, `Channel`.`instagram_post_pricing_date`, `Channel`.`instagram_story_pricing`, `Channel`.`instagram_story_pricing_date`, `Channel`.`max_price_instagram_post`, `Channel`.`max_price_instagram_story`, `Channel`.`max_price_twitter_post`, `Channel`.`max_price_youtube_video`, `Channel`.`max_price_youtube_mention`, `Channel`.`mention_video_yt_id`, `Channel`.`min_price_instagram_post`, `Channel`.`min_price_instagram_story`, `Channel`.`min_price_twitter_post`, `Channel`.`min_price_youtube_video`, `Channel`.`min_price_youtube_mention`, `Channel`.`overall_good_standing`, `Channel`.`pricing_comment`, `Channel`.`source`, `Channel`.`tiktok_likes`, `Channel`.`tiktok_pricing`, `Channel`.`tiktok_pricing_date`, `Channel`.`twitch_live_pricing`, `Channel`.`twitch_live_pricing_date`, `Channel`.`twitter_post_pricing`, `Channel`.`twitter_post_pricing_date`, `Channel`.`type_language`, `Channel`.`type_country`, `Channel`.`youtube_mention_pricing_date`, `Channel`.`youtube_video_pricing`, `Channel`.`youtube_video_pricing_date`, `ContentOwner`.`id`, `ContentOwner`.`display_name`, `ContentOwner`.`type`, `YtmpContentOwner`.`id`, `YtmpContentOwner`.`display_name`, `TwitchChannel`.`id`, `TwitchChannel`.`login`, `TwitchChannel`.`tracking_level`, `TwitchChannel`.`followers`, `TwitchChannel`.`views`, (IF(ISNULL(`Channel`.`mention_video_yt_id`) AND ISNULL(`Channel`.`dedicated_video_yt_id`) AND ISNULL(`Channel`.`instagram_post_id`), 0, 1)) AS `Channel__has_realizations`, (IF(ISNULL(`Channel`.`portfolio_youtube_mention_pricing`),
IF(ISNULL(`Channel`.`youtube_mention_pricing`),
IF(ISNULL(`Channel`.`max_price_youtube_mention`),
NULL,
ROUND(`Channel`.`max_price_youtube_mention` / (1.6 * 100)) * 100
),
`Channel`.`youtube_mention_pricing`
),
`Channel`.`portfolio_youtube_mention_pricing`
)) AS `Channel__default_youtube_mention_pricing`, (IF(ISNULL(`Channel`.`portfolio_youtube_mention_pricing`),
IF(ISNULL(`Channel`.`youtube_mention_pricing`),
IF(ISNULL(`Channel`.`max_price_youtube_mention`),
NULL,
'computed'
),
'manual'
),
'portfolio'
)) AS `Channel__default_youtube_mention_pricing_type` 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`) WHERE `Channel`.`id` = 2477187 AND `Channel`.`tracking_level` < 300 # cible : "http://refonte.wiztracker.net/fr/channels/detail/2477187/PresentHunt" | 1 | 1 | 3 | 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` = (2477187) # cible : "http://refonte.wiztracker.net/fr/channels/detail/2477187/PresentHunt" | 0 | 0 | 1 | maybe slow |
| SELECT `ChannelTopic`.`id`, `ChannelTopic`.`channel_id`, `ChannelTopic`.`topic_id` FROM `wiztracker`.`channel_topics` AS `ChannelTopic` WHERE `ChannelTopic`.`channel_id` = (2477187) # cible : "http://refonte.wiztracker.net/fr/channels/detail/2477187/PresentHunt" | 2 | 2 | 1 | maybe slow |
| SELECT `ChannelZohoAccount`.`id`, `ChannelZohoAccount`.`zoho_id`, `ChannelZohoAccount`.`name`, `ChannelZohoAccount`.`owner`, `ChannelZohoAccount`.`industry`, `ChannelZohoAccount`.`associated_accounts_names`, `ChannelZohoAccount`.`preferred_contact_methods`, `ChannelsZohoAccount`.`id`, `ChannelsZohoAccount`.`channel_id`, `ChannelsZohoAccount`.`zoho_account_id` FROM `wiztracker`.`channel_zoho_accounts` AS `ChannelZohoAccount` JOIN `wiztracker`.`channels_zoho_accounts` AS `ChannelsZohoAccount` ON (`ChannelsZohoAccount`.`channel_id` = 2477187 AND `ChannelsZohoAccount`.`zoho_account_id` = `ChannelZohoAccount`.`id`) # cible : "http://refonte.wiztracker.net/fr/channels/detail/2477187/PresentHunt" | 0 | 0 | 1 | maybe slow |
| SELECT PortfolioList.id, PortfolioList.name, PortfolioChannel.id, PortfolioChannel.channel_id, PortfolioChannel.name
FROM portfolios AS PortfolioList
LEFT JOIN portfolio_channels AS PortfolioChannel ON PortfolioChannel.portfolio_id = PortfolioList.id
WHERE PortfolioChannel.channel_id = 2477187 # cible : "http://refonte.wiztracker.net/fr/channels/detail/2477187/PresentHunt" | 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` = 2477187 AND `CategoriesChannel`.`category_id` = `Category`.`id`) # cible : "http://refonte.wiztracker.net/fr/channels/detail/2477187/PresentHunt" | 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` = 2477187 AND `ChannelsContactEmail`.`contact_email_id` = `ContactEmail`.`id`) # cible : "http://refonte.wiztracker.net/fr/channels/detail/2477187/PresentHunt" | 1 | 1 | 2 | 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/channels/detail/2477187/PresentHunt" | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `wiztracker`.`company_strikes` AS `CompanyStrike` WHERE `company_id` IS NULL AND `channel_id` = 2477187 # cible : "http://refonte.wiztracker.net/fr/channels/detail/2477187/PresentHunt" | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `wiztracker`.`company_claims` AS `CompanyClaim` WHERE `company_id` IS NULL AND `channel_id` = 2477187 # cible : "http://refonte.wiztracker.net/fr/channels/detail/2477187/PresentHunt" | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `wiztracker`.`channel_monthly_earnings` AS `ChannelMonthlyEarning` WHERE `channel_id` = 2477187 # cible : "http://refonte.wiztracker.net/fr/channels/detail/2477187/PresentHunt" | 1 | 1 | 0 | |
| SELECT `ChannelZohoAccount`.`id`, `ChannelZohoAccount`.`zoho_id` FROM `wiztracker`.`channel_zoho_accounts` AS `ChannelZohoAccount` WHERE `channel_id` = 2477187 # cible : "http://refonte.wiztracker.net/fr/channels/detail/2477187/PresentHunt" | 0 | 0 | 0 | |
English
