English
Tableau de bord créateur
7.6M
abonnés
621
vidéos
3.13B
vues
Score
854
No post data.
No querystring data.
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `wiztracker`.`wizdeo_sessions` AS `Session` WHERE `Session`.`id` = 'b0d0v8eokutgpue8ie68ouptp2' LIMIT 1 # cible : "http://analytics.wizdeo.com/fr/channels/generic_rankings/2261135" | 0 | 0 | 2 | 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/fr/channels/generic_rankings/2261135" | 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` = 2261135 AND `Channel`.`tracking_level` < 300 LIMIT 1 # cible : "http://analytics.wizdeo.com/fr/channels/generic_rankings/2261135" | 1 | 1 | 10 | 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` = (2261135) # cible : "http://analytics.wizdeo.com/fr/channels/generic_rankings/2261135" | 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` = 2261135 AND `ChannelsTopicchannel`.`topicchannel_id` = `Topicchannel`.`id`) WHERE twitch_id is not null ORDER BY `percentage` desc # cible : "http://analytics.wizdeo.com/fr/channels/generic_rankings/2261135" | 0 | 0 | 1 | maybe slow |
| SELECT `Category`.`id`, `Category`.`name`, `CategoriesChannel`.`id`, `CategoriesChannel`.`category_id`, `CategoriesChannel`.`channel_id` FROM `wiztracker`.`categories` AS `Category` JOIN `wiztracker`.`categories_channels` AS `CategoriesChannel` ON (`CategoriesChannel`.`channel_id` = 2261135 AND `CategoriesChannel`.`category_id` = `Category`.`id`) # cible : "http://analytics.wizdeo.com/fr/channels/generic_rankings/2261135" | 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` = 2261135 AND `ChannelsContactEmail`.`contact_email_id` = `ContactEmail`.`id`) # cible : "http://analytics.wizdeo.com/fr/channels/generic_rankings/2261135" | 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/fr/channels/generic_rankings/2261135" | 1 | 1 | 1 | |
| SELECT `ChannelsGroup`.`group_id` FROM `wiztracker`.`channels_groups` AS `ChannelsGroup` WHERE `channel_id` = 2261135 # cible : "http://analytics.wizdeo.com/fr/channels/generic_rankings/2261135" | 2 | 2 | 3 | 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, 3427) # cible : "http://analytics.wizdeo.com/fr/channels/generic_rankings/2261135" | 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` = 2261135 AND `ManagedChannel`.`user_id` IS NULL AND `Token`.`valid_token` = '1' LIMIT 1 # cible : "http://analytics.wizdeo.com/fr/channels/generic_rankings/2261135" | 0 | 0 | 1 | maybe slow |
| 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/fr/channels/generic_rankings/2261135" | 14 | 14 | 1 | maybe slow |
| SELECT `CopyrightsMonetization`.`id`, `CopyrightsMonetization`.`user_id`, `CopyrightsMonetization`.`status` FROM `wiztracker`.`copyrights_monetizations` AS `CopyrightsMonetization` WHERE `channel_id` = 2261135 LIMIT 1 # cible : "http://analytics.wizdeo.com/fr/channels/generic_rankings/2261135" | 0 | 0 | 1 | maybe slow |
Utilisation de la Mémoire au niveau maximum 45.59 MB
| Message | Memory use |
|---|---|
| Component initialization | 7.89 MB |
| Controller action start | 37.92 MB |
| Controller render start | 39.29 MB |
| View render complete | 41.03 MB |
Total du Temps de Requête 219 (ms)
| Message | Temps en ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 17.88 | |
| Event: Controller.initialize | 96.95 | |
| Event: Controller.startup | 1.14 | |
| Controller action | 28.45 | |
| Event: Controller.beforeRender | 14.69 | |
| » Processing toolbar data | 6.11 | |
| Rendering View | 41.15 | |
| » Event: View.beforeRender | 0.05 | |
| » Rendering APP/View/Channels/generic_rankings.ctp | 2.60 | |
| » » Rendering APP/View/Elements/materialize/progress/circular.ctp | 0.08 | |
| » » Rendering APP/View/Elements/materialize/progress/circular.ctp #2 | 0.06 | |
| » » Rendering APP/View/Elements/materialize/progress/circular.ctp #3 | 0.06 | |
| » Rendering APP/View/Extends/channel_view.ctp | 7.57 | |
| » » Rendering APP/View/Elements/materialize/channel_header.ctp | 1.91 | |
| » » » Rendering APP/View/Elements/callToAction.ctp | 0.04 | |
| » » » Rendering APP/View/Elements/materialize/kpi/kpi.ctp | 0.22 | |
| » » » Rendering APP/View/Elements/materialize/kpi/kpi.ctp #2 | 0.13 | |
| » » » Rendering APP/View/Elements/materialize/kpi/kpi.ctp #3 | 0.09 | |
| » » » Rendering APP/View/Elements/materialize/kpi/kpi.ctp #4 | 0.09 | |
| » » » Rendering APP/View/Elements/socialCounter.ctp | 0.22 | |
| » » Rendering APP/View/Elements/materialize/menu.ctp | 0.08 | |
| » » Rendering APP/View/Elements/Channels/card_autotrack.ctp | 0.06 | |
| » Rendering APP/View/Extends/materialize.ctp | 0.64 | |
| » » Rendering APP/View/Elements/materialize/init.ctp | 0.50 | |
| » Event: View.afterRender | 0.03 | |
| » Event: View.beforeLayout | 0.03 | |
| » Rendering APP/View/Layouts/default.ctp | 27.80 | |
| » » Rendering APP/View/Elements/materialize/init.ctp #2 | 0.06 | |
| » » Rendering APP/View/Elements/header.ctp | 19.78 | |
| » » » Rendering APP/View/Elements/materialize/menu.ctp #2 | 0.06 | |
| » » » Rendering APP/View/Elements/materialize/menu.ctp #3 | 0.07 | |
| » » Rendering APP/View/Elements/Nav/nav.ctp | 5.25 | |
| » » Rendering APP/View/Elements/alert_token.ctp | 0.10 | |
| » » Rendering APP/View/Elements/footer.ctp | 0.97 | |
| » Rendering APP/View/Elements/HelpTopic/default.ctp #2 | 1.62 | |
| » » Rendering APP/View/Elements/GAAccept.ctp | 0.51 | |
| » » Rendering APP/View/Elements/javascript_translate.ctp | 0.66 | |
| Event: View.afterLayout | 0.00 |
| Constant | Value |
|---|---|
| CONFIG | '/home/wiztracker/app/Config/' |
| DATETIME | 'Y-m-d H:i:s' |
| FILTER_VALIDATE_BOOL | (int) 258 |
| HDOM_TYPE_ELEMENT | (int) 1 |
| HDOM_TYPE_COMMENT | (int) 2 |
| HDOM_TYPE_TEXT | (int) 3 |
| HDOM_TYPE_ENDTAG | (int) 4 |
| HDOM_TYPE_ROOT | (int) 5 |
| HDOM_TYPE_UNKNOWN | (int) 6 |
| HDOM_QUOTE_DOUBLE | (int) 0 |
| HDOM_QUOTE_SINGLE | (int) 1 |
| HDOM_QUOTE_NO | (int) 3 |
| HDOM_INFO_BEGIN | (int) 0 |
| HDOM_INFO_END | (int) 1 |
| HDOM_INFO_QUOTE | (int) 2 |
| HDOM_INFO_SPACE | (int) 3 |
| HDOM_INFO_TEXT | (int) 4 |
| HDOM_INFO_INNER | (int) 5 |
| HDOM_INFO_OUTER | (int) 6 |
| HDOM_INFO_ENDSPACE | (int) 7 |
| DEFAULT_TARGET_CHARSET | 'UTF-8' |
| DEFAULT_BR_TEXT | '' |
| DEFAULT_SPAN_TEXT | '' |
| MAX_FILE_SIZE | (int) 600000 |
| WEBBOT_NAME | 'Wizdeo Webbot' |
| CURL_TIMEOUT | (int) 25 |
| COOKIE_FILE | 'cookie.txt' |
| HEAD | 'HEAD' |
| GET | 'GET' |
| POST | 'POST' |
| EXCL_HEAD | false |
| INCL_HEAD | true |
| EXCL | true |
| INCL | false |
| BEFORE | true |
| AFTER | false |
| tFPDF_VERSION | '1.25' |
| IS_CLI | false |
| DEFAULT_LANGUAGE | 'eng' |
| DEFAULT_LANG | 'en' |
| Constant | Value |
|---|---|
| APP | '/home/wiztracker/app/' |
| APP_DIR | 'app' |
| APPLIBS | '/home/wiztracker/app/Lib/' |
| CACHE | '/home/wiztracker/app/tmp/cache/' |
| CAKE | '/home/wiztracker/app/Vendor/cakephp/cakephp/lib/Cake/' |
| CAKE_CORE_INCLUDE_PATH | '/home/wiztracker/app/Vendor/cakephp/cakephp/lib' |
| CORE_PATH | '/home/wiztracker/app/Vendor/cakephp/cakephp/lib/' |
| CAKE_VERSION | '2.10.24' |
| CSS | '/home/wiztracker/app/webroot/css/' |
| CSS_URL | 'css/' |
| DS | '/' |
| FULL_BASE_URL | 'https://analytics.wizdeo.com' |
| IMAGES | '/home/wiztracker/app/webroot/img/' |
| IMAGES_URL | 'img/' |
| JS | '/home/wiztracker/app/webroot/js/' |
| JS_URL | 'js/' |
| LOGS | '/home/wiztracker/app/tmp/logs/' |
| ROOT | '/home/wiztracker' |
| TESTS | '/home/wiztracker/app/Test/' |
| TMP | '/home/wiztracker/app/tmp/' |
| VENDORS | '/home/wiztracker/vendors/' |
| WEBROOT_DIR | 'webroot' |
| WWW_ROOT | '/home/wiztracker/app/webroot/' |
| Environment Variable | Value |
|---|---|
| Php Version | '7.2.32-1+0~20200710.46+debian10~1.gbp625eb5' |
| Lang | 'C.UTF-8' |
| Path | '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin' |
| Notify Socket | '/run/systemd/notify' |
| Invocation Id | '794d4b7df5ed4559849c9537e74009c0' |
| Journal Stream | '9:406018255' |
| Tracker Id | 'wa-frontend-01' |
| Cakephp Debug | '0' |
| Elasticsearch Host | 'haproxy' |
| Jenkins Hostname | 'kibana' |
| User | 'wiztracker' |
| Home | '/home/wiztracker' |
| Script Name | '/index.php' |
| Request Uri | '/fr/channels/generic_rankings/2261135' |
| Query String | '' |
| Request Method | 'GET' |
| Server Protocol | 'HTTP/1.1' |
| Gateway Interface | 'CGI/1.1' |
| Redirect Url | '/fr/channels/generic_rankings/2261135' |
| Remote Port | '45946' |
| Script Filename | '/home/wiztracker/app//index.php' |
| Server Admin | 'support.wiztracker@wizdeo.com' |
| Context Document Root | '/home/wiztracker/app/webroot' |
| Context Prefix | '' |
| Request Scheme | 'https' |
| Document Root | '/home/wiztracker/app/webroot' |
| Remote Addr | '3.233.242.204' |
| Server Port | '443' |
| Server Addr | '10.240.0.140' |
| Server Name | 'analytics.wizdeo.com' |
| Server Software | 'Apache' |
| Server Signature | '' |
| Http Connection | 'Keep-Alive' |
| Http Host | 'analytics.wizdeo.com' |
| Http Accept Encoding | 'br,gzip' |
| Http If Modified Since | 'Thu, 15 Apr 2021 16:56:02 GMT' |
| Http Accept Language | 'en-US,en;q=0.5' |
| Http Accept | 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' |
| Http User Agent | 'CCBot/2.0 (https://commoncrawl.org/faq/)' |
| Ssl Tls Sni | 'analytics.wizdeo.com' |
| Https | 'on' |
| Redirect Status | '200' |
| Redirect Ssl Tls Sni | 'analytics.wizdeo.com' |
| Redirect Https | 'on' |
| Fcgi Role | 'RESPONDER' |
| Php Self | '/index.php' |
| Request Time Float | (float) 1632264496.5424 |
| Request Time | (int) 1632264496 |
