Skip to content

Instantly share code, notes, and snippets.

@Findus23
Created April 6, 2018 13:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Findus23/0913c69f10c4ff5ce2a0b53e8c98ef3e to your computer and use it in GitHub Desktop.
Save Findus23/0913c69f10c4ff5ce2a0b53e8c98ef3e to your computer and use it in GitHub Desktop.
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Debug enabled - Input parameters:
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] array (
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'hsr_vid' => '5zNQAm',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'hsr_ev' =>
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] array (
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 0 =>
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] array (
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'ty' => '5',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'ti' => '0',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'te' => '{REMOVED}',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] ),
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] ),
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'hsr_ids' =>
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] array (
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 0 => '6',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] ),
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'hsr_vw' => '360',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'hsr_vh' => '560',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'hsr_ti' => '198',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'hsr_smp' => '90',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'hsr_fyp' => '90',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'idsite' => '14',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'rec' => '1',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'r' => '883313',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'h' => '15',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'm' => '40',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 's' => '45',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'url' => 'https://lw1.at/de',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] '_id' => 'ed821ec297ee3e72',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] '_idts' => '1523021782',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] '_idvc' => '1',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] '_idn' => '0',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] '_refts' => '0',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] '_viewts' => '1523021782',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'send_image' => '0',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'cookie' => '1',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'res' => '360x640',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'gt_ms' => '48',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] 'pv_id' => 'UmbT47',
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] )
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Current datetime: 2018-04-06 13:40:43
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\AbTesting\Tracker\RequestProcessor::manipulateRequest()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\AbTesting\Tracker\RequestProcessor\Utils::manipulateRequest()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\FormAnalytics\Tracker\RequestProcessor::manipulateRequest()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\HeatmapSessionRecording\Tracker\RequestProcessor::manipulateRequest()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()...
DEBUG PrivacyManager[2018-04-06 13:40:43 UTC] [92aa0] DoNotTrack header not found
DEBUG CoreHome[2018-04-06 13:40:43 UTC] [92aa0] Matching visitors with: visitorId=ed821ec297ee3e72 OR configId=8187a751d3d92d05
DEBUG CoreHome[2018-04-06 13:40:43 UTC] [92aa0] The visitor is known (idvisitor = ed821ec297ee3e72,
DEBUG CoreHome[2018-04-06 13:40:43 UTC] [92aa0] config_id = 8187a751d3d92d05,
DEBUG CoreHome[2018-04-06 13:40:43 UTC] [92aa0] idvisit = 16305,
DEBUG CoreHome[2018-04-06 13:40:43 UTC] [92aa0] last action = Fri, 06 Apr 2018 13:40:42 +0000,
DEBUG CoreHome[2018-04-06 13:40:43 UTC] [92aa0] first action = Fri, 06 Apr 2018 13:39:29 +0000,
DEBUG CoreHome[2018-04-06 13:40:43 UTC] [92aa0] visit_goal_buyer' = 0)
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()...
DEBUG Actions[2018-04-06 13:40:43 UTC] [92aa0] (this is not a Site Search request)
DEBUG HeatmapSessionRecording[2018-04-06 13:40:43 UTC] [92aa0] Excluding parameters "gclid,fb_xd_fragment,fb_comment_id,phpsessid,jsessionid,sessionid,aspsessionid,doing_wp_cron,sid,pk_vid,pk_cpn,pk_campaign,piwik_campaign,utm_campaign,utm_source,utm_medium,pk_kwd,pk_keyword,piwik_kwd,utm_term,pk_hsr_capturescreen,pk_hsr_forcesample" from URL
DEBUG Actions[2018-04-06 13:40:43 UTC] [92aa0] Action is a 96,
DEBUG Actions[2018-04-06 13:40:43 UTC] [92aa0] Action name = ,
DEBUG Actions[2018-04-06 13:40:43 UTC] [92aa0] Action URL = https://lw1.at/de
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\AbTesting\Tracker\RequestProcessor::processRequestParams()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\AbTesting\Tracker\RequestProcessor\Utils::processRequestParams()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\FormAnalytics\Tracker\RequestProcessor::processRequestParams()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\HeatmapSessionRecording\Tracker\RequestProcessor::processRequestParams()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Following dimensions have been collected from plugins: idsite, user_id, visit_first_action_time, visit_first_action_time, visit_goal_buyer, visit_goal_converted, idvisit, location_ip, visit_last_action_time, visit_last_action_time, visit_last_action_time, visit_last_action_time, visit_last_action_time, visit_last_action_time, visit_last_action_time, visit_last_action_time, visit_last_action_time, visit_last_action_time, visit_last_action_time, visitor_days_since_first, visitor_days_since_order, idvisitor, visitor_returning, visitor_count_visits, visit_entry_idaction_name, visit_entry_idaction_url, visit_exit_idaction_name, visit_exit_idaction_url, visit_total_actions, visit_total_interactions, visit_total_searches, , referer_keyword, referer_name, referer_type, referer_url, , location_browser_lang, config_browser_engine, config_browser_name, config_browser_version, config_device_brand, config_device_model, config_device_type, config_os, config_os_version, visit_total_events, visitor_localtime, visitor_localtime, visitor_days_since_last, config_resolution, config_cookie, config_director, config_flash, config_gears, config_java, config_pdf, config_quicktime, config_realplayer, config_silverlight, config_windowsmedia, , visit_total_time, location_city, location_country, location_latitude, location_longitude, location_provider, location_region, location_provider
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()...
DEBUG PrivacyManager[2018-04-06 13:40:43 UTC] [92aa0] Visitor IP (was: 213.162.0.0) has been anonymized: 213.162.0.0
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\AbTesting\Tracker\RequestProcessor::afterRequestProcessed()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\AbTesting\Tracker\RequestProcessor\Utils::afterRequestProcessed()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\FormAnalytics\Tracker\RequestProcessor::afterRequestProcessed()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Executing Piwik\Plugins\HeatmapSessionRecording\Tracker\RequestProcessor::afterRequestProcessed()...
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] -> aborting due to afterRequestProcessed method
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] -> Scheduled tasks not triggered.
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Next run will be from: 2018-04-06 14:33:07 UTC
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Nothing to notice => default behaviour
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] End of the page.
DEBUG Piwik\Profiler[2018-04-06 13:40:43 UTC] [92aa0] <hr /><strong>Breakdown by query</strong><br/>Executed <b>8</b> times in <b>12.1ms</b> (average = <b>1.5ms</b>) <pre> INSERT INTO log_hsr_event (`idloghsr`,`time_since_load`,`event_type`,`idselector`,`x`,`y`,`idhsrblob`) VALUES(?,?,?,?,?,?,?) </pre>Executed <b>8</b> times in <b>9.8ms</b> (average = <b>1.2ms</b>) <pre> SELECT visit_last_action_time, visit_first_action_time, idvisitor, idvisit, user_id, visit_exit_idaction_url, visit_exit_idaction_name, visitor_returning, visitor_days_since_first, visitor_days_since_order, visitor_count_visits, visit_goal_buyer, location_country, location_region, location_city, location_latitude, location_longitude, referer_name, referer_keyword, referer_type, idsite, visit_entry_idaction_url, visit_total_actions, visit_total_interactions, visit_total_searches, config_device_brand, config_device_model, config_device_type, visit_total_events, visit_total_time, location_ip, location_browser_lang, custom_var_k1, custom_var_v1, custom_var_k2, custom_var_v2, custom_var_k3, custom_var_v3, custom_var_k4, custom_var_v4, custom_var_k5, custom_var_v5 FROM log_visit WHERE visit_last_action_time >= ? AND visit_last_action_time <= ? AND idsite = ? AND idvisitor = ? ORDER BY visit_last_action_time DESC LIMIT 1</pre>Executed <b>12</b> times in <b>9.6ms</b> (average = <b>0.8ms</b>) <pre> connect</pre>Executed <b>3</b> times in <b>6.5ms</b> (average = <b>2.2ms</b>) <pre> UPDATE log_hsr set idaction_url = ?, device_type = ? where idloghsr = ?</pre>Executed <b>3</b> times in <b>5.9ms</b> (average = <b>2ms</b>) <pre> INSERT INTO log_hsr (`idvisit`,`idsite`,`idhsrview`,`idpageview`,`server_time`,`time_on_page`,`viewport_w_px`,`viewport_h_px`,`scroll_y_max_relative`,`fold_y_relative`) VALUES(?,?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE time_on_page = if(? > time_on_page, ?, time_on_page), scroll_y_max_relative = if(? > scroll_y_max_relative, ?, scroll_y_max_relative), idloghsr = LAST_INSERT_ID(idloghsr)</pre>Executed <b>2</b> times in <b>5.7ms</b> (average = <b>2.9ms</b>) <pre> SELECT idhsrblob FROM log_hsr_blob WHERE `hash` = ? and (`value` = ? or `value` = ?) LIMIT 1</pre>Executed <b>3</b> times in <b>5.6ms</b> (average = <b>1.9ms</b>) <pre> INSERT INTO log_hsr_site (`idloghsr`, `idsitehsr`) VALUES(?,?) ON DUPLICATE KEY UPDATE idloghsr = idloghsr</pre>Executed <b>2</b> times in <b>5.5ms</b> (average = <b>2.8ms</b>) <pre> UPDATE log_hsr SET time_on_page = if(? > time_on_page, ?, time_on_page), scroll_y_max_relative = if(? > scroll_y_max_relative, ?, scroll_y_max_relative) WHERE idvisit = ? and idhsrview = ?</pre>Executed <b>5</b> times in <b>5.4ms</b> (average = <b>1.1ms</b>) <pre> SELECT MIN(idaction) as idaction, type, name FROM log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) GROUP BY type, hash, name</pre>Executed <b>1</b> time in <b>3.8ms</b> <pre> INSERT INTO log_visit (idvisitor, config_id, location_ip, idsite, visit_first_action_time, visit_goal_buyer, visit_goal_converted, visit_last_action_time, visitor_days_since_first, visitor_days_since_order, visitor_returning, visitor_count_visits, visit_entry_idaction_name, visit_exit_idaction_name, visit_exit_idaction_url, visit_total_actions, visit_total_interactions, visit_total_searches, referer_keyword, referer_name, referer_type, referer_url, location_browser_lang, config_browser_engine, config_browser_name, config_browser_version, config_device_brand, config_device_model, config_device_type, config_os, config_os_version, visit_total_events, visitor_localtime, visitor_days_since_last, config_resolution, config_cookie, config_director, config_flash, config_gears, config_java, config_pdf, config_quicktime, config_realplayer, config_silverlight, config_windowsmedia, visit_total_time, location_city, location_country, location_latitude, location_longitude, location_region, location_provider) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>2</b> times in <b>3.4ms</b> (average = <b>1.7ms</b>) <pre> INSERT INTO log_link_visit_action (idvisit, idsite, idvisitor, idaction_url, idaction_url_ref, idaction_name_ref, server_time, idpageview, interaction_position, time_spent_ref_action, idaction_name, custom_float) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>1</b> time in <b>2.6ms</b> <pre> UPDATE log_visit SET idvisitor = ?, visit_last_action_time = ?, visit_exit_idaction_name = ?, visit_exit_idaction_url = ?, visit_total_actions = visit_total_actions + 1 , visit_total_interactions = visit_total_interactions + 1 , visit_total_time = ? WHERE idsite = ? AND idvisit = ?</pre>Executed <b>1</b> time in <b>2.5ms</b> <pre> SHOW COLUMNS FROM `log_link_visit_action`</pre>Executed <b>1</b> time in <b>2.3ms</b> <pre> UPDATE log_visit SET idvisitor = ?, visit_last_action_time = ?, visit_entry_idaction_url = ?, visit_exit_idaction_name = ?, visit_exit_idaction_url = ?, visit_total_actions = visit_total_actions + 1 , visit_total_interactions = visit_total_interactions + 1 , visit_total_time = ? WHERE idsite = ? AND idvisit = ?</pre>Executed <b>5</b> times in <b>2.1ms</b> (average = <b>0.4ms</b>) <pre> SELECT idloghsr FROM log_hsr WHERE idvisit = ? and idhsrview = ? LIMIT 1</pre>Executed <b>1</b> time in <b>1.4ms</b> <pre> SHOW COLUMNS FROM `log_visit`</pre>Executed <b>1</b> time in <b>0.8ms</b> <pre> SHOW COLUMNS FROM `log_conversion`</pre>
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] array (
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] )
DEBUG Piwik\Common[2018-04-06 13:40:43 UTC] [92aa0] Time elapsed: 0.039s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment