Pastebin
API
tools
faq
paste
Login
Sign up
Please fix the following errors:
New Paste
Syntax Highlighting
2018-04-19 20:05:35.679485 {'_id': '0000000000030854', 'action_name': 'MP3 128k', 'cip': '178.193.1.1', 'idsite': 1, 'rec': 1, 'token_auth': '********************************', 'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; ' 'es_xl)', 'url': 'http://streaming.com/live-128k.mp3'} DEBUG: Debug enabled - Input parameters: DEBUG: array ( DEBUG: 'idsite' => '1', DEBUG: 'rec' => '1', DEBUG: 'action_name' => 'MP3 128k', DEBUG: '_id' => '0000000000030854', DEBUG: 'cip' => '178.193.1.1', DEBUG: 'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)', DEBUG: 'url' => 'http://streaming.com/live-128k.mp3', DEBUG: 'token_auth' => '********************************', DEBUG: ) DEBUG: Current datetime: 2018-04-19 18:05:35 DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()... DEBUG: token_auth is authenticated! DEBUG: DoNotTrack header not found DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07 DEBUG: The visitor was not matched with an existing visitor... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()... DEBUG: (this is not a Site Search request) DEBUG: 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" from URL DEBUG: Action is a PAGE_URL, DEBUG: Action name = MP3 128k, DEBUG: Action URL = http://streaming.com/live-128k.mp3 DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()... DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1 DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()... DEBUG: New Visit (IP = 178.193.1.1) DEBUG: 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 DEBUG: GEO: Found IP 178.193.1.1 location (provider 'geoip_pecl'): array ( DEBUG: 'country_code' => 'CH', DEBUG: 'region_code' => '', DEBUG: 'city_name' => '', DEBUG: 'area_code' => 0, DEBUG: 'lat' => 47.145, DEBUG: 'long' => 8.155, DEBUG: 'postal_code' => '', DEBUG: 'continent_code' => 'eur', DEBUG: 'continent_name' => 'Intl_Continent_eur', DEBUG: 'country_name' => 'Unknown', DEBUG: ) DEBUG: array ( DEBUG: 'idvisitor' => '0000000000030854', DEBUG: 'config_id' => '3626277eddd89b07', DEBUG: 'location_ip' => '178.193.1.1', DEBUG: 'idsite' => 1, DEBUG: 'visit_first_action_time' => '2018-04-19 18:05:35', DEBUG: 'visit_goal_buyer' => 0, DEBUG: 'visit_goal_converted' => 0, DEBUG: 'visit_last_action_time' => '2018-04-19 18:05:35', DEBUG: 'visitor_days_since_first' => '0', DEBUG: 'visitor_days_since_order' => 0, DEBUG: 'visitor_returning' => 0, DEBUG: 'visitor_count_visits' => 1, DEBUG: 'visit_entry_idaction_name' => 7, DEBUG: 'visit_entry_idaction_url' => 8, DEBUG: 'visit_exit_idaction_name' => 7, DEBUG: 'visit_exit_idaction_url' => 8, DEBUG: 'visit_total_actions' => 1, DEBUG: 'visit_total_interactions' => 1, DEBUG: 'visit_total_searches' => 0, DEBUG: 'referer_keyword' => NULL, DEBUG: 'referer_name' => NULL, DEBUG: 'referer_type' => 1, DEBUG: 'referer_url' => '', DEBUG: 'location_browser_lang' => '', DEBUG: 'config_browser_engine' => 'WebKit', DEBUG: 'config_browser_name' => 'MF', DEBUG: 'config_browser_version' => '', DEBUG: 'config_device_brand' => 'AP', DEBUG: 'config_device_model' => 'iPhone', DEBUG: 'config_device_type' => 1, DEBUG: 'config_os' => 'IOS', DEBUG: 'config_os_version' => '11.2', DEBUG: 'visit_total_events' => 0, DEBUG: 'visitor_localtime' => '18:05:35', DEBUG: 'visitor_days_since_last' => 0, DEBUG: 'config_resolution' => 'unknown', DEBUG: 'config_cookie' => 0, DEBUG: 'config_director' => 0, DEBUG: 'config_flash' => 0, DEBUG: 'config_gears' => 0, DEBUG: 'config_java' => 0, DEBUG: 'config_pdf' => 0, DEBUG: 'config_quicktime' => 0, DEBUG: 'config_realplayer' => 0, DEBUG: 'config_silverlight' => 0, DEBUG: 'config_windowsmedia' => 0, DEBUG: 'visit_total_time' => 0, DEBUG: 'location_city' => '', DEBUG: 'location_country' => 'ch', DEBUG: 'location_latitude' => '47.145', DEBUG: 'location_longitude' => '8.155', DEBUG: 'location_region' => '', DEBUG: ) DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::recordLogs()... DEBUG: Inserted new action: DEBUG: array ( DEBUG: 'idvisit' => '173', DEBUG: 'idsite' => 1, DEBUG: 'idvisitor' => '0000000000030854', DEBUG: 'idaction_url' => '8', DEBUG: 'idaction_url_ref' => 0, DEBUG: 'idaction_name_ref' => 0, DEBUG: 'server_time' => '2018-04-19 18:05:35', DEBUG: 'idpageview' => '', DEBUG: 'interaction_position' => 1, DEBUG: 'time_spent_ref_action' => 0, DEBUG: 'idaction_name' => '7', DEBUG: 'idlink_va' => '473', DEBUG: ) DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::recordLogs()... DEBUG: -> Scheduled tasks not triggered. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC DEBUG: Nothing to notice => default behaviour DEBUG: End of the page. DEBUG: <hr /><strong>Breakdown by query</strong><br/>Executed <b>786</b> times in <b>1188.2ms</b> (average = <b>1.5ms</b>) <pre> SELECT MIN(idaction) as idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) GROUP BY type, hash, name</pre>Executed <b>1420</b> times in <b>1126.5ms</b> (average = <b>0.8ms</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 matomo_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>800</b> times in <b>1035.2ms</b> (average = <b>1.3ms</b>) <pre> connect</pre>Executed <b>143</b> times in <b>459ms</b> (average = <b>3.2ms</b>) <pre> UPDATE matomo_log_visit SET idvisitor = ?, visit_total_time = ? WHERE idsite = ? AND idvisit = ?</pre>Executed <b>75</b> times in <b>317.9ms</b> (average = <b>4.2ms</b>) <pre> INSERT INTO matomo_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_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_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) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>631</b> times in <b>251.1ms</b> (average = <b>0.4ms</b>) <pre> SELECT * FROM matomo_user WHERE token_auth = ?</pre>Executed <b>75</b> times in <b>195.8ms</b> (average = <b>2.6ms</b>) <pre> INSERT INTO matomo_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) VALUES (?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>63</b> times in <b>13ms</b> (average = <b>0.2ms</b>) <pre> SELECT option_value FROM `matomo_option` WHERE option_name = ?</pre>Executed <b>4</b> times in <b>12.5ms</b> (average = <b>3.1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_link_visit_action`</pre>Executed <b>5</b> times in <b>6.2ms</b> (average = <b>1.2ms</b>) <pre> SELECT option_value, option_name FROM `matomo_option` WHERE autoload = 1</pre>Executed <b>1</b> time in <b>5.4ms</b> <pre> INSERT INTO `matomo_option` (option_name, option_value, autoload) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE option_value = ?</pre>Executed <b>4</b> times in <b>5.2ms</b> (average = <b>1.3ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_visit`</pre>Executed <b>4</b> times in <b>4ms</b> (average = <b>1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_conversion`</pre>Executed <b>1</b> time in <b>3.9ms</b> <pre> INSERT INTO matomo_log_action (name, hash, type, url_prefix) VALUES (?,CRC32(?),?,?)</pre>Executed <b>5</b> times in <b>3.8ms</b> (average = <b>0.8ms</b>) <pre> SELECT * FROM matomo_goal WHERE idsite IN (1) AND deleted = 0</pre>Executed <b>10</b> times in <b>2.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT * FROM matomo_site WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT url FROM matomo_site_url WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.3ms</b> (average = <b>0.3ms</b>) <pre> SELECT login FROM matomo_access WHERE idsite = ? AND access = ?</pre>Executed <b>1</b> time in <b>0.3ms</b> <pre> SELECT idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) ORDER BY idaction ASC LIMIT 1</pre> DEBUG: array ( DEBUG: ) DEBUG: Time elapsed: 0.083s 2018-04-19 20:05:45.783178 {'_id': '0000000000030854', 'action_name': 'MP3 128k', 'cip': '178.193.1.1', 'idsite': 1, 'ping': 1, 'rec': 1, 'token_auth': '********************************', 'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; ' 'es_xl)', 'url': 'http://streaming.com/live-128k.mp3'} DEBUG: Debug enabled - Input parameters: DEBUG: array ( DEBUG: 'idsite' => '1', DEBUG: 'rec' => '1', DEBUG: 'action_name' => 'MP3 128k', DEBUG: '_id' => '0000000000030854', DEBUG: 'cip' => '178.193.1.1', DEBUG: 'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)', DEBUG: 'url' => 'http://streaming.com/live-128k.mp3', DEBUG: 'token_auth' => '********************************', DEBUG: 'ping' => '1', DEBUG: ) DEBUG: Current datetime: 2018-04-19 18:05:45 DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()... DEBUG: token_auth is authenticated! DEBUG: DoNotTrack header not found DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07 DEBUG: The visitor is known (idvisitor = 0000000000030854, DEBUG: config_id = 3626277eddd89b07, DEBUG: idvisit = 173, DEBUG: last action = Thu, 19 Apr 2018 18:05:35 +0000, DEBUG: first action = Thu, 19 Apr 2018 18:05:35 +0000, DEBUG: visit_goal_buyer' = 0) DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()... DEBUG: (this is not a Site Search request) DEBUG: 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" from URL DEBUG: Action is a PAGE_URL, DEBUG: Action name = MP3 128k, DEBUG: Action URL = http://streaming.com/live-128k.mp3 DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()... DEBUG: 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 DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()... DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1 DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()... DEBUG: -> ping=1 request: we do not track a new action nor a new visit nor any goal. DEBUG: Visit is known (IP = 178.193.1.1) DEBUG: Updated existing visit: array ( DEBUG: 'idvisitor' => '0000000000030854', DEBUG: 'visit_total_time' => 11, DEBUG: ) DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::recordLogs()... DEBUG: -> Scheduled tasks not triggered. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC DEBUG: Nothing to notice => default behaviour DEBUG: End of the page. DEBUG: <hr /><strong>Breakdown by query</strong><br/>Executed <b>787</b> times in <b>1191.4ms</b> (average = <b>1.5ms</b>) <pre> SELECT MIN(idaction) as idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) GROUP BY type, hash, name</pre>Executed <b>1421</b> times in <b>1127.2ms</b> (average = <b>0.8ms</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 matomo_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>801</b> times in <b>1035.9ms</b> (average = <b>1.3ms</b>) <pre> connect</pre>Executed <b>144</b> times in <b>461.1ms</b> (average = <b>3.2ms</b>) <pre> UPDATE matomo_log_visit SET idvisitor = ?, visit_total_time = ? WHERE idsite = ? AND idvisit = ?</pre>Executed <b>75</b> times in <b>317.9ms</b> (average = <b>4.2ms</b>) <pre> INSERT INTO matomo_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_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_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) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>632</b> times in <b>251.3ms</b> (average = <b>0.4ms</b>) <pre> SELECT * FROM matomo_user WHERE token_auth = ?</pre>Executed <b>75</b> times in <b>195.8ms</b> (average = <b>2.6ms</b>) <pre> INSERT INTO matomo_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) VALUES (?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>63</b> times in <b>13ms</b> (average = <b>0.2ms</b>) <pre> SELECT option_value FROM `matomo_option` WHERE option_name = ?</pre>Executed <b>4</b> times in <b>12.5ms</b> (average = <b>3.1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_link_visit_action`</pre>Executed <b>5</b> times in <b>6.2ms</b> (average = <b>1.2ms</b>) <pre> SELECT option_value, option_name FROM `matomo_option` WHERE autoload = 1</pre>Executed <b>1</b> time in <b>5.4ms</b> <pre> INSERT INTO `matomo_option` (option_name, option_value, autoload) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE option_value = ?</pre>Executed <b>4</b> times in <b>5.2ms</b> (average = <b>1.3ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_visit`</pre>Executed <b>4</b> times in <b>4ms</b> (average = <b>1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_conversion`</pre>Executed <b>1</b> time in <b>3.9ms</b> <pre> INSERT INTO matomo_log_action (name, hash, type, url_prefix) VALUES (?,CRC32(?),?,?)</pre>Executed <b>5</b> times in <b>3.8ms</b> (average = <b>0.8ms</b>) <pre> SELECT * FROM matomo_goal WHERE idsite IN (1) AND deleted = 0</pre>Executed <b>10</b> times in <b>2.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT * FROM matomo_site WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT url FROM matomo_site_url WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.3ms</b> (average = <b>0.3ms</b>) <pre> SELECT login FROM matomo_access WHERE idsite = ? AND access = ?</pre>Executed <b>1</b> time in <b>0.3ms</b> <pre> SELECT idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) ORDER BY idaction ASC LIMIT 1</pre> DEBUG: array ( DEBUG: ) DEBUG: Time elapsed: 0.029s 2018-04-19 20:05:55.891038 {'_id': '0000000000030854', 'action_name': 'MP3 128k', 'cip': '178.193.1.1', 'idsite': 1, 'ping': 1, 'rec': 1, 'token_auth': '********************************', 'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; ' 'es_xl)', 'url': 'http://streaming.com/live-128k.mp3'} DEBUG: Debug enabled - Input parameters: DEBUG: array ( DEBUG: 'idsite' => '1', DEBUG: 'rec' => '1', DEBUG: 'action_name' => 'MP3 128k', DEBUG: '_id' => '0000000000030854', DEBUG: 'cip' => '178.193.1.1', DEBUG: 'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)', DEBUG: 'url' => 'http://streaming.com/live-128k.mp3', DEBUG: 'token_auth' => '********************************', DEBUG: 'ping' => '1', DEBUG: ) DEBUG: Current datetime: 2018-04-19 18:05:55 DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()... DEBUG: token_auth is authenticated! DEBUG: DoNotTrack header not found DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07 DEBUG: The visitor is known (idvisitor = 0000000000030854, DEBUG: config_id = 3626277eddd89b07, DEBUG: idvisit = 173, DEBUG: last action = Thu, 19 Apr 2018 18:05:35 +0000, DEBUG: first action = Thu, 19 Apr 2018 18:05:35 +0000, DEBUG: visit_goal_buyer' = 0) DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()... DEBUG: (this is not a Site Search request) DEBUG: 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" from URL DEBUG: Action is a PAGE_URL, DEBUG: Action name = MP3 128k, DEBUG: Action URL = http://streaming.com/live-128k.mp3 DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()... DEBUG: 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 DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()... DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1 DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()... DEBUG: -> ping=1 request: we do not track a new action nor a new visit nor any goal. DEBUG: Visit is known (IP = 178.193.1.1) DEBUG: Updated existing visit: array ( DEBUG: 'idvisitor' => '0000000000030854', DEBUG: 'visit_total_time' => 21, DEBUG: ) DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::recordLogs()... DEBUG: -> Scheduled tasks not triggered. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC DEBUG: Nothing to notice => default behaviour DEBUG: End of the page. DEBUG: <hr /><strong>Breakdown by query</strong><br/>Executed <b>788</b> times in <b>1192.3ms</b> (average = <b>1.5ms</b>) <pre> SELECT MIN(idaction) as idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) GROUP BY type, hash, name</pre>Executed <b>1422</b> times in <b>1127.8ms</b> (average = <b>0.8ms</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 matomo_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>802</b> times in <b>1036.8ms</b> (average = <b>1.3ms</b>) <pre> connect</pre>Executed <b>145</b> times in <b>467.7ms</b> (average = <b>3.2ms</b>) <pre> UPDATE matomo_log_visit SET idvisitor = ?, visit_total_time = ? WHERE idsite = ? AND idvisit = ?</pre>Executed <b>75</b> times in <b>317.9ms</b> (average = <b>4.2ms</b>) <pre> INSERT INTO matomo_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_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_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) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>633</b> times in <b>251.7ms</b> (average = <b>0.4ms</b>) <pre> SELECT * FROM matomo_user WHERE token_auth = ?</pre>Executed <b>75</b> times in <b>195.8ms</b> (average = <b>2.6ms</b>) <pre> INSERT INTO matomo_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) VALUES (?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>63</b> times in <b>13ms</b> (average = <b>0.2ms</b>) <pre> SELECT option_value FROM `matomo_option` WHERE option_name = ?</pre>Executed <b>4</b> times in <b>12.5ms</b> (average = <b>3.1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_link_visit_action`</pre>Executed <b>5</b> times in <b>6.2ms</b> (average = <b>1.2ms</b>) <pre> SELECT option_value, option_name FROM `matomo_option` WHERE autoload = 1</pre>Executed <b>1</b> time in <b>5.4ms</b> <pre> INSERT INTO `matomo_option` (option_name, option_value, autoload) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE option_value = ?</pre>Executed <b>4</b> times in <b>5.2ms</b> (average = <b>1.3ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_visit`</pre>Executed <b>4</b> times in <b>4ms</b> (average = <b>1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_conversion`</pre>Executed <b>1</b> time in <b>3.9ms</b> <pre> INSERT INTO matomo_log_action (name, hash, type, url_prefix) VALUES (?,CRC32(?),?,?)</pre>Executed <b>5</b> times in <b>3.8ms</b> (average = <b>0.8ms</b>) <pre> SELECT * FROM matomo_goal WHERE idsite IN (1) AND deleted = 0</pre>Executed <b>10</b> times in <b>2.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT * FROM matomo_site WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT url FROM matomo_site_url WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.3ms</b> (average = <b>0.3ms</b>) <pre> SELECT login FROM matomo_access WHERE idsite = ? AND access = ?</pre>Executed <b>1</b> time in <b>0.3ms</b> <pre> SELECT idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) ORDER BY idaction ASC LIMIT 1</pre> DEBUG: array ( DEBUG: ) DEBUG: Time elapsed: 0.036s 2018-04-19 20:06:05.997436 {'_id': '0000000000030854', 'action_name': 'MP3 128k', 'cip': '178.193.1.1', 'idsite': 1, 'ping': 1, 'rec': 1, 'token_auth': '********************************', 'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; ' 'es_xl)', 'url': 'http://streaming.com/live-128k.mp3'} DEBUG: Debug enabled - Input parameters: DEBUG: array ( DEBUG: 'idsite' => '1', DEBUG: 'rec' => '1', DEBUG: 'action_name' => 'MP3 128k', DEBUG: '_id' => '0000000000030854', DEBUG: 'cip' => '178.193.1.1', DEBUG: 'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)', DEBUG: 'url' => 'http://streaming.com/live-128k.mp3', DEBUG: 'token_auth' => '********************************', DEBUG: 'ping' => '1', DEBUG: ) DEBUG: Current datetime: 2018-04-19 18:06:05 DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()... DEBUG: token_auth is authenticated! DEBUG: DoNotTrack header not found DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07 DEBUG: The visitor is known (idvisitor = 0000000000030854, DEBUG: config_id = 3626277eddd89b07, DEBUG: idvisit = 173, DEBUG: last action = Thu, 19 Apr 2018 18:05:35 +0000, DEBUG: first action = Thu, 19 Apr 2018 18:05:35 +0000, DEBUG: visit_goal_buyer' = 0) DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()... DEBUG: (this is not a Site Search request) DEBUG: 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" from URL DEBUG: Action is a PAGE_URL, DEBUG: Action name = MP3 128k, DEBUG: Action URL = http://streaming.com/live-128k.mp3 DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()... DEBUG: 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 DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()... DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1 DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()... DEBUG: -> ping=1 request: we do not track a new action nor a new visit nor any goal. DEBUG: Visit is known (IP = 178.193.1.1) DEBUG: Updated existing visit: array ( DEBUG: 'idvisitor' => '0000000000030854', DEBUG: 'visit_total_time' => 31, DEBUG: ) DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::recordLogs()... DEBUG: -> Scheduled tasks not triggered. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC DEBUG: Nothing to notice => default behaviour DEBUG: End of the page. DEBUG: <hr /><strong>Breakdown by query</strong><br/>Executed <b>789</b> times in <b>1194ms</b> (average = <b>1.5ms</b>) <pre> SELECT MIN(idaction) as idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) GROUP BY type, hash, name</pre>Executed <b>1423</b> times in <b>1128.8ms</b> (average = <b>0.8ms</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 matomo_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>803</b> times in <b>1038.3ms</b> (average = <b>1.3ms</b>) <pre> connect</pre>Executed <b>146</b> times in <b>470.4ms</b> (average = <b>3.2ms</b>) <pre> UPDATE matomo_log_visit SET idvisitor = ?, visit_total_time = ? WHERE idsite = ? AND idvisit = ?</pre>Executed <b>75</b> times in <b>317.9ms</b> (average = <b>4.2ms</b>) <pre> INSERT INTO matomo_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_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_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) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>634</b> times in <b>252.6ms</b> (average = <b>0.4ms</b>) <pre> SELECT * FROM matomo_user WHERE token_auth = ?</pre>Executed <b>75</b> times in <b>195.8ms</b> (average = <b>2.6ms</b>) <pre> INSERT INTO matomo_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) VALUES (?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>63</b> times in <b>13ms</b> (average = <b>0.2ms</b>) <pre> SELECT option_value FROM `matomo_option` WHERE option_name = ?</pre>Executed <b>4</b> times in <b>12.5ms</b> (average = <b>3.1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_link_visit_action`</pre>Executed <b>5</b> times in <b>6.2ms</b> (average = <b>1.2ms</b>) <pre> SELECT option_value, option_name FROM `matomo_option` WHERE autoload = 1</pre>Executed <b>1</b> time in <b>5.4ms</b> <pre> INSERT INTO `matomo_option` (option_name, option_value, autoload) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE option_value = ?</pre>Executed <b>4</b> times in <b>5.2ms</b> (average = <b>1.3ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_visit`</pre>Executed <b>4</b> times in <b>4ms</b> (average = <b>1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_conversion`</pre>Executed <b>1</b> time in <b>3.9ms</b> <pre> INSERT INTO matomo_log_action (name, hash, type, url_prefix) VALUES (?,CRC32(?),?,?)</pre>Executed <b>5</b> times in <b>3.8ms</b> (average = <b>0.8ms</b>) <pre> SELECT * FROM matomo_goal WHERE idsite IN (1) AND deleted = 0</pre>Executed <b>10</b> times in <b>2.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT * FROM matomo_site WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT url FROM matomo_site_url WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.3ms</b> (average = <b>0.3ms</b>) <pre> SELECT login FROM matomo_access WHERE idsite = ? AND access = ?</pre>Executed <b>1</b> time in <b>0.3ms</b> <pre> SELECT idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) ORDER BY idaction ASC LIMIT 1</pre> DEBUG: array ( DEBUG: ) DEBUG: Time elapsed: 0.035s 2018-04-19 20:06:16.111824 {'_id': '0000000000030854', 'action_name': 'MP3 128k', 'cip': '178.193.1.1', 'idsite': 1, 'ping': 1, 'rec': 1, 'token_auth': '********************************', 'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; ' 'es_xl)', 'url': 'http://streaming.com/live-128k.mp3'} DEBUG: Debug enabled - Input parameters: DEBUG: array ( DEBUG: 'idsite' => '1', DEBUG: 'rec' => '1', DEBUG: 'action_name' => 'MP3 128k', DEBUG: '_id' => '0000000000030854', DEBUG: 'cip' => '178.193.1.1', DEBUG: 'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)', DEBUG: 'url' => 'http://streaming.com/live-128k.mp3', DEBUG: 'token_auth' => '********************************', DEBUG: 'ping' => '1', DEBUG: ) DEBUG: Current datetime: 2018-04-19 18:06:16 DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()... DEBUG: token_auth is authenticated! DEBUG: DoNotTrack header not found DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07 DEBUG: The visitor is known (idvisitor = 0000000000030854, DEBUG: config_id = 3626277eddd89b07, DEBUG: idvisit = 173, DEBUG: last action = Thu, 19 Apr 2018 18:05:35 +0000, DEBUG: first action = Thu, 19 Apr 2018 18:05:35 +0000, DEBUG: visit_goal_buyer' = 0) DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()... DEBUG: (this is not a Site Search request) DEBUG: 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" from URL DEBUG: Action is a PAGE_URL, DEBUG: Action name = MP3 128k, DEBUG: Action URL = http://streaming.com/live-128k.mp3 DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()... DEBUG: 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 DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()... DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1 DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()... DEBUG: -> ping=1 request: we do not track a new action nor a new visit nor any goal. DEBUG: Visit is known (IP = 178.193.1.1) DEBUG: Updated existing visit: array ( DEBUG: 'idvisitor' => '0000000000030854', DEBUG: 'visit_total_time' => 42, DEBUG: ) DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::recordLogs()... DEBUG: -> Scheduled tasks not triggered. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC DEBUG: Nothing to notice => default behaviour DEBUG: End of the page. DEBUG: <hr /><strong>Breakdown by query</strong><br/>Executed <b>790</b> times in <b>1195ms</b> (average = <b>1.5ms</b>) <pre> SELECT MIN(idaction) as idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) GROUP BY type, hash, name</pre>Executed <b>1424</b> times in <b>1129.5ms</b> (average = <b>0.8ms</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 matomo_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>804</b> times in <b>1039ms</b> (average = <b>1.3ms</b>) <pre> connect</pre>Executed <b>147</b> times in <b>475.9ms</b> (average = <b>3.2ms</b>) <pre> UPDATE matomo_log_visit SET idvisitor = ?, visit_total_time = ? WHERE idsite = ? AND idvisit = ?</pre>Executed <b>75</b> times in <b>317.9ms</b> (average = <b>4.2ms</b>) <pre> INSERT INTO matomo_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_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_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) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>635</b> times in <b>252.9ms</b> (average = <b>0.4ms</b>) <pre> SELECT * FROM matomo_user WHERE token_auth = ?</pre>Executed <b>75</b> times in <b>195.8ms</b> (average = <b>2.6ms</b>) <pre> INSERT INTO matomo_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) VALUES (?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>63</b> times in <b>13ms</b> (average = <b>0.2ms</b>) <pre> SELECT option_value FROM `matomo_option` WHERE option_name = ?</pre>Executed <b>4</b> times in <b>12.5ms</b> (average = <b>3.1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_link_visit_action`</pre>Executed <b>5</b> times in <b>6.2ms</b> (average = <b>1.2ms</b>) <pre> SELECT option_value, option_name FROM `matomo_option` WHERE autoload = 1</pre>Executed <b>1</b> time in <b>5.4ms</b> <pre> INSERT INTO `matomo_option` (option_name, option_value, autoload) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE option_value = ?</pre>Executed <b>4</b> times in <b>5.2ms</b> (average = <b>1.3ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_visit`</pre>Executed <b>4</b> times in <b>4ms</b> (average = <b>1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_conversion`</pre>Executed <b>1</b> time in <b>3.9ms</b> <pre> INSERT INTO matomo_log_action (name, hash, type, url_prefix) VALUES (?,CRC32(?),?,?)</pre>Executed <b>5</b> times in <b>3.8ms</b> (average = <b>0.8ms</b>) <pre> SELECT * FROM matomo_goal WHERE idsite IN (1) AND deleted = 0</pre>Executed <b>10</b> times in <b>2.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT * FROM matomo_site WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT url FROM matomo_site_url WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.3ms</b> (average = <b>0.3ms</b>) <pre> SELECT login FROM matomo_access WHERE idsite = ? AND access = ?</pre>Executed <b>1</b> time in <b>0.3ms</b> <pre> SELECT idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) ORDER BY idaction ASC LIMIT 1</pre> DEBUG: array ( DEBUG: ) DEBUG: Time elapsed: 0.042s 2018-04-19 20:06:26.224112 {'_id': '0000000000030854', 'action_name': 'MP3 128k', 'cip': '178.193.1.1', 'idsite': 1, 'ping': 1, 'rec': 1, 'token_auth': '********************************', 'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; ' 'es_xl)', 'url': 'http://streaming.com/live-128k.mp3'} DEBUG: Debug enabled - Input parameters: DEBUG: array ( DEBUG: 'idsite' => '1', DEBUG: 'rec' => '1', DEBUG: 'action_name' => 'MP3 128k', DEBUG: '_id' => '0000000000030854', DEBUG: 'cip' => '178.193.1.1', DEBUG: 'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)', DEBUG: 'url' => 'http://streaming.com/live-128k.mp3', DEBUG: 'token_auth' => '********************************', DEBUG: 'ping' => '1', DEBUG: ) DEBUG: Current datetime: 2018-04-19 18:06:26 DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()... DEBUG: token_auth is authenticated! DEBUG: DoNotTrack header not found DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07 DEBUG: The visitor is known (idvisitor = 0000000000030854, DEBUG: config_id = 3626277eddd89b07, DEBUG: idvisit = 173, DEBUG: last action = Thu, 19 Apr 2018 18:05:35 +0000, DEBUG: first action = Thu, 19 Apr 2018 18:05:35 +0000, DEBUG: visit_goal_buyer' = 0) DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()... DEBUG: (this is not a Site Search request) DEBUG: 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" from URL DEBUG: Action is a PAGE_URL, DEBUG: Action name = MP3 128k, DEBUG: Action URL = http://streaming.com/live-128k.mp3 DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()... DEBUG: 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 DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()... DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1 DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()... DEBUG: -> ping=1 request: we do not track a new action nor a new visit nor any goal. DEBUG: Visit is known (IP = 178.193.1.1) DEBUG: Updated existing visit: array ( DEBUG: 'idvisitor' => '0000000000030854', DEBUG: 'visit_total_time' => 52, DEBUG: ) DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::recordLogs()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::recordLogs()... DEBUG: -> Scheduled tasks not triggered. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC DEBUG: Nothing to notice => default behaviour DEBUG: End of the page. DEBUG: <hr /><strong>Breakdown by query</strong><br/>Executed <b>791</b> times in <b>1196.7ms</b> (average = <b>1.5ms</b>) <pre> SELECT MIN(idaction) as idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) GROUP BY type, hash, name</pre>Executed <b>1425</b> times in <b>1130.4ms</b> (average = <b>0.8ms</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 matomo_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>805</b> times in <b>1042ms</b> (average = <b>1.3ms</b>) <pre> connect</pre>Executed <b>148</b> times in <b>478.5ms</b> (average = <b>3.2ms</b>) <pre> UPDATE matomo_log_visit SET idvisitor = ?, visit_total_time = ? WHERE idsite = ? AND idvisit = ?</pre>Executed <b>75</b> times in <b>317.9ms</b> (average = <b>4.2ms</b>) <pre> INSERT INTO matomo_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_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_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) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>636</b> times in <b>253.7ms</b> (average = <b>0.4ms</b>) <pre> SELECT * FROM matomo_user WHERE token_auth = ?</pre>Executed <b>75</b> times in <b>195.8ms</b> (average = <b>2.6ms</b>) <pre> INSERT INTO matomo_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) VALUES (?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>63</b> times in <b>13ms</b> (average = <b>0.2ms</b>) <pre> SELECT option_value FROM `matomo_option` WHERE option_name = ?</pre>Executed <b>4</b> times in <b>12.5ms</b> (average = <b>3.1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_link_visit_action`</pre>Executed <b>5</b> times in <b>6.2ms</b> (average = <b>1.2ms</b>) <pre> SELECT option_value, option_name FROM `matomo_option` WHERE autoload = 1</pre>Executed <b>1</b> time in <b>5.4ms</b> <pre> INSERT INTO `matomo_option` (option_name, option_value, autoload) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE option_value = ?</pre>Executed <b>4</b> times in <b>5.2ms</b> (average = <b>1.3ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_visit`</pre>Executed <b>4</b> times in <b>4ms</b> (average = <b>1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_conversion`</pre>Executed <b>1</b> time in <b>3.9ms</b> <pre> INSERT INTO matomo_log_action (name, hash, type, url_prefix) VALUES (?,CRC32(?),?,?)</pre>Executed <b>5</b> times in <b>3.8ms</b> (average = <b>0.8ms</b>) <pre> SELECT * FROM matomo_goal WHERE idsite IN (1) AND deleted = 0</pre>Executed <b>10</b> times in <b>2.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT * FROM matomo_site WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT url FROM matomo_site_url WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.3ms</b> (average = <b>0.3ms</b>) <pre> SELECT login FROM matomo_access WHERE idsite = ? AND access = ?</pre>Executed <b>1</b> time in <b>0.3ms</b> <pre> SELECT idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) ORDER BY idaction ASC LIMIT 1</pre> DEBUG: array ( DEBUG: ) DEBUG: Time elapsed: 0.032s 2018-04-19 20:06:36.346488 {'_id': '0000000000030854', 'action_name': 'MP3 128k', 'cip': '178.193.1.1', 'idsite': 1, 'ping': 1, 'rec': 1, 'token_auth': '********************************', 'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; ' 'es_xl)', 'url': 'http://streaming.com/live-128k.mp3'} DEBUG: Debug enabled - Input parameters: DEBUG: array ( DEBUG: 'idsite' => '1', DEBUG: 'rec' => '1', DEBUG: 'action_name' => 'MP3 128k', DEBUG: '_id' => '0000000000030854', DEBUG: 'cip' => '178.193.1.1', DEBUG: 'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)', DEBUG: 'url' => 'http://streaming.com/live-128k.mp3', DEBUG: 'token_auth' => '********************************', DEBUG: 'ping' => '1', DEBUG: ) DEBUG: Current datetime: 2018-04-19 18:06:36 DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()... DEBUG: token_auth is authenticated! DEBUG: DoNotTrack header not found DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07 DEBUG: The visitor was not matched with an existing visitor... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()... DEBUG: (this is not a Site Search request) DEBUG: 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" from URL DEBUG: Action is a PAGE_URL, DEBUG: Action name = MP3 128k, DEBUG: Action URL = http://streaming.com/live-128k.mp3 DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()... DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1 DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()... DEBUG: -> ping=1 request: we do not track a new action nor a new visit nor any goal. DEBUG: -> ping=1 request: we do _not_ create a new visit. DEBUG: -> aborting due to afterRequestProcessed method DEBUG: -> Scheduled tasks not triggered. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC DEBUG: Nothing to notice => default behaviour DEBUG: End of the page. DEBUG: <hr /><strong>Breakdown by query</strong><br/>Executed <b>792</b> times in <b>1200.1ms</b> (average = <b>1.5ms</b>) <pre> SELECT MIN(idaction) as idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) GROUP BY type, hash, name</pre>Executed <b>1427</b> times in <b>1131.3ms</b> (average = <b>0.8ms</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 matomo_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>806</b> times in <b>1042.9ms</b> (average = <b>1.3ms</b>) <pre> connect</pre>Executed <b>148</b> times in <b>478.5ms</b> (average = <b>3.2ms</b>) <pre> UPDATE matomo_log_visit SET idvisitor = ?, visit_total_time = ? WHERE idsite = ? AND idvisit = ?</pre>Executed <b>75</b> times in <b>317.9ms</b> (average = <b>4.2ms</b>) <pre> INSERT INTO matomo_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_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_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) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>637</b> times in <b>254.1ms</b> (average = <b>0.4ms</b>) <pre> SELECT * FROM matomo_user WHERE token_auth = ?</pre>Executed <b>75</b> times in <b>195.8ms</b> (average = <b>2.6ms</b>) <pre> INSERT INTO matomo_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) VALUES (?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>63</b> times in <b>13ms</b> (average = <b>0.2ms</b>) <pre> SELECT option_value FROM `matomo_option` WHERE option_name = ?</pre>Executed <b>4</b> times in <b>12.5ms</b> (average = <b>3.1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_link_visit_action`</pre>Executed <b>5</b> times in <b>6.2ms</b> (average = <b>1.2ms</b>) <pre> SELECT option_value, option_name FROM `matomo_option` WHERE autoload = 1</pre>Executed <b>1</b> time in <b>5.4ms</b> <pre> INSERT INTO `matomo_option` (option_name, option_value, autoload) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE option_value = ?</pre>Executed <b>4</b> times in <b>5.2ms</b> (average = <b>1.3ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_visit`</pre>Executed <b>4</b> times in <b>4ms</b> (average = <b>1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_conversion`</pre>Executed <b>1</b> time in <b>3.9ms</b> <pre> INSERT INTO matomo_log_action (name, hash, type, url_prefix) VALUES (?,CRC32(?),?,?)</pre>Executed <b>5</b> times in <b>3.8ms</b> (average = <b>0.8ms</b>) <pre> SELECT * FROM matomo_goal WHERE idsite IN (1) AND deleted = 0</pre>Executed <b>10</b> times in <b>2.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT * FROM matomo_site WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT url FROM matomo_site_url WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.3ms</b> (average = <b>0.3ms</b>) <pre> SELECT login FROM matomo_access WHERE idsite = ? AND access = ?</pre>Executed <b>1</b> time in <b>0.3ms</b> <pre> SELECT idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) ORDER BY idaction ASC LIMIT 1</pre> DEBUG: array ( DEBUG: ) DEBUG: Time elapsed: 0.037s 2018-04-19 20:06:46.445839 {'_id': '0000000000030854', 'action_name': 'MP3 128k', 'cip': '178.193.1.1', 'idsite': 1, 'ping': 1, 'rec': 1, 'token_auth': '********************************', 'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; ' 'es_xl)', 'url': 'http://streaming.com/live-128k.mp3'} DEBUG: Debug enabled - Input parameters: DEBUG: array ( DEBUG: 'idsite' => '1', DEBUG: 'rec' => '1', DEBUG: 'action_name' => 'MP3 128k', DEBUG: '_id' => '0000000000030854', DEBUG: 'cip' => '178.193.1.1', DEBUG: 'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)', DEBUG: 'url' => 'http://streaming.com/live-128k.mp3', DEBUG: 'token_auth' => '********************************', DEBUG: 'ping' => '1', DEBUG: ) DEBUG: Current datetime: 2018-04-19 18:06:46 DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()... DEBUG: token_auth is authenticated! DEBUG: DoNotTrack header not found DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07 DEBUG: The visitor was not matched with an existing visitor... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()... DEBUG: (this is not a Site Search request) DEBUG: 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" from URL DEBUG: Action is a PAGE_URL, DEBUG: Action name = MP3 128k, DEBUG: Action URL = http://streaming.com/live-128k.mp3 DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()... DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1 DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()... DEBUG: -> ping=1 request: we do not track a new action nor a new visit nor any goal. DEBUG: -> ping=1 request: we do _not_ create a new visit. DEBUG: -> aborting due to afterRequestProcessed method DEBUG: -> Scheduled tasks not triggered. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC DEBUG: Nothing to notice => default behaviour DEBUG: End of the page. DEBUG: <hr /><strong>Breakdown by query</strong><br/>Executed <b>793</b> times in <b>1200.9ms</b> (average = <b>1.5ms</b>) <pre> SELECT MIN(idaction) as idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) GROUP BY type, hash, name</pre>Executed <b>1429</b> times in <b>1132.2ms</b> (average = <b>0.8ms</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 matomo_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>807</b> times in <b>1043.6ms</b> (average = <b>1.3ms</b>) <pre> connect</pre>Executed <b>148</b> times in <b>478.5ms</b> (average = <b>3.2ms</b>) <pre> UPDATE matomo_log_visit SET idvisitor = ?, visit_total_time = ? WHERE idsite = ? AND idvisit = ?</pre>Executed <b>75</b> times in <b>317.9ms</b> (average = <b>4.2ms</b>) <pre> INSERT INTO matomo_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_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_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) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>638</b> times in <b>254.4ms</b> (average = <b>0.4ms</b>) <pre> SELECT * FROM matomo_user WHERE token_auth = ?</pre>Executed <b>75</b> times in <b>195.8ms</b> (average = <b>2.6ms</b>) <pre> INSERT INTO matomo_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) VALUES (?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>63</b> times in <b>13ms</b> (average = <b>0.2ms</b>) <pre> SELECT option_value FROM `matomo_option` WHERE option_name = ?</pre>Executed <b>4</b> times in <b>12.5ms</b> (average = <b>3.1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_link_visit_action`</pre>Executed <b>5</b> times in <b>6.2ms</b> (average = <b>1.2ms</b>) <pre> SELECT option_value, option_name FROM `matomo_option` WHERE autoload = 1</pre>Executed <b>1</b> time in <b>5.4ms</b> <pre> INSERT INTO `matomo_option` (option_name, option_value, autoload) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE option_value = ?</pre>Executed <b>4</b> times in <b>5.2ms</b> (average = <b>1.3ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_visit`</pre>Executed <b>4</b> times in <b>4ms</b> (average = <b>1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_conversion`</pre>Executed <b>1</b> time in <b>3.9ms</b> <pre> INSERT INTO matomo_log_action (name, hash, type, url_prefix) VALUES (?,CRC32(?),?,?)</pre>Executed <b>5</b> times in <b>3.8ms</b> (average = <b>0.8ms</b>) <pre> SELECT * FROM matomo_goal WHERE idsite IN (1) AND deleted = 0</pre>Executed <b>10</b> times in <b>2.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT * FROM matomo_site WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT url FROM matomo_site_url WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.3ms</b> (average = <b>0.3ms</b>) <pre> SELECT login FROM matomo_access WHERE idsite = ? AND access = ?</pre>Executed <b>1</b> time in <b>0.3ms</b> <pre> SELECT idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) ORDER BY idaction ASC LIMIT 1</pre> DEBUG: array ( DEBUG: ) DEBUG: Time elapsed: 0.028s 2018-04-19 20:06:56.539340 {'_id': '0000000000030854', 'action_name': 'MP3 128k', 'cip': '178.193.1.1', 'idsite': 1, 'ping': 1, 'rec': 1, 'token_auth': '********************************', 'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; ' 'es_xl)', 'url': 'http://streaming.com/live-128k.mp3'} DEBUG: Debug enabled - Input parameters: DEBUG: array ( DEBUG: 'idsite' => '1', DEBUG: 'rec' => '1', DEBUG: 'action_name' => 'MP3 128k', DEBUG: '_id' => '0000000000030854', DEBUG: 'cip' => '178.193.1.1', DEBUG: 'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)', DEBUG: 'url' => 'http://streaming.com/live-128k.mp3', DEBUG: 'token_auth' => '********************************', DEBUG: 'ping' => '1', DEBUG: ) DEBUG: Current datetime: 2018-04-19 18:06:56 DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()... DEBUG: token_auth is authenticated! DEBUG: DoNotTrack header not found DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07 DEBUG: The visitor was not matched with an existing visitor... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()... DEBUG: (this is not a Site Search request) DEBUG: 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" from URL DEBUG: Action is a PAGE_URL, DEBUG: Action name = MP3 128k, DEBUG: Action URL = http://streaming.com/live-128k.mp3 DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()... DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()... DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1 DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()... DEBUG: -> ping=1 request: we do not track a new action nor a new visit nor any goal. DEBUG: -> ping=1 request: we do _not_ create a new visit. DEBUG: -> aborting due to afterRequestProcessed method DEBUG: -> Scheduled tasks not triggered. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC DEBUG: Nothing to notice => default behaviour DEBUG: End of the page. DEBUG: <hr /><strong>Breakdown by query</strong><br/>Executed <b>794</b> times in <b>1201.7ms</b> (average = <b>1.5ms</b>) <pre> SELECT MIN(idaction) as idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) GROUP BY type, hash, name</pre>Executed <b>1431</b> times in <b>1133.3ms</b> (average = <b>0.8ms</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 matomo_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>808</b> times in <b>1044.3ms</b> (average = <b>1.3ms</b>) <pre> connect</pre>Executed <b>148</b> times in <b>478.5ms</b> (average = <b>3.2ms</b>) <pre> UPDATE matomo_log_visit SET idvisitor = ?, visit_total_time = ? WHERE idsite = ? AND idvisit = ?</pre>Executed <b>75</b> times in <b>317.9ms</b> (average = <b>4.2ms</b>) <pre> INSERT INTO matomo_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_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_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) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>639</b> times in <b>254.7ms</b> (average = <b>0.4ms</b>) <pre> SELECT * FROM matomo_user WHERE token_auth = ?</pre>Executed <b>75</b> times in <b>195.8ms</b> (average = <b>2.6ms</b>) <pre> INSERT INTO matomo_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) VALUES (?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>63</b> times in <b>13ms</b> (average = <b>0.2ms</b>) <pre> SELECT option_value FROM `matomo_option` WHERE option_name = ?</pre>Executed <b>4</b> times in <b>12.5ms</b> (average = <b>3.1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_link_visit_action`</pre>Executed <b>5</b> times in <b>6.2ms</b> (average = <b>1.2ms</b>) <pre> SELECT option_value, option_name FROM `matomo_option` WHERE autoload = 1</pre>Executed <b>1</b> time in <b>5.4ms</b> <pre> INSERT INTO `matomo_option` (option_name, option_value, autoload) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE option_value = ?</pre>Executed <b>4</b> times in <b>5.2ms</b> (average = <b>1.3ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_visit`</pre>Executed <b>4</b> times in <b>4ms</b> (average = <b>1ms</b>) <pre> SHOW COLUMNS FROM `matomo_log_conversion`</pre>Executed <b>1</b> time in <b>3.9ms</b> <pre> INSERT INTO matomo_log_action (name, hash, type, url_prefix) VALUES (?,CRC32(?),?,?)</pre>Executed <b>5</b> times in <b>3.8ms</b> (average = <b>0.8ms</b>) <pre> SELECT * FROM matomo_goal WHERE idsite IN (1) AND deleted = 0</pre>Executed <b>10</b> times in <b>2.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT * FROM matomo_site WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.7ms</b> (average = <b>0.3ms</b>) <pre> SELECT url FROM matomo_site_url WHERE idsite = ?</pre>Executed <b>5</b> times in <b>1.3ms</b> (average = <b>0.3ms</b>) <pre> SELECT login FROM matomo_access WHERE idsite = ? AND access = ?</pre>Executed <b>1</b> time in <b>0.3ms</b> <pre> SELECT idaction, type, name FROM matomo_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) ORDER BY idaction ASC LIMIT 1</pre> DEBUG: array ( DEBUG: ) DEBUG: Time elapsed: 0.024s
Optional Paste Settings
Category:
None
Cryptocurrency
Cybersecurity
Fixit
Food
Gaming
Haiku
Help
History
Housing
Jokes
Legal
Money
Movies
Music
Pets
Photo
Science
Software
Source Code
Spirit
Sports
Travel
TV
Writing
Tags:
Syntax Highlighting:
None
Bash
C
C#
C++
CSS
HTML
JSON
Java
JavaScript
Lua
Markdown (PRO members only)
Objective C
PHP
Perl
Python
Ruby
Swift
4CS
6502 ACME Cross Assembler
6502 Kick Assembler
6502 TASM/64TASS
ABAP
AIMMS
ALGOL 68
APT Sources
ARM
ASM (NASM)
ASP
ActionScript
ActionScript 3
Ada
Apache Log
AppleScript
Arduino
Asymptote
AutoIt
Autohotkey
Avisynth
Awk
BASCOM AVR
BNF
BOO
Bash
Basic4GL
Batch
BibTeX
Blitz Basic
Blitz3D
BlitzMax
BrainFuck
C
C (WinAPI)
C Intermediate Language
C for Macs
C#
C++
C++ (WinAPI)
C++ (with Qt extensions)
C: Loadrunner
CAD DCL
CAD Lisp
CFDG
CMake
COBOL
CSS
Ceylon
ChaiScript
Chapel
Clojure
Clone C
Clone C++
CoffeeScript
ColdFusion
Cuesheet
D
DCL
DCPU-16
DCS
DIV
DOT
Dart
Delphi
Delphi Prism (Oxygene)
Diff
E
ECMAScript
EPC
Easytrieve
Eiffel
Email
Erlang
Euphoria
F#
FO Language
Falcon
Filemaker
Formula One
Fortran
FreeBasic
FreeSWITCH
GAMBAS
GDB
GDScript
Game Maker
Genero
Genie
GetText
Go
Godot GLSL
Groovy
GwBasic
HQ9 Plus
HTML
HTML 5
Haskell
Haxe
HicEst
IDL
INI file
INTERCAL
IO
ISPF Panel Definition
Icon
Inno Script
J
JCL
JSON
Java
Java 5
JavaScript
Julia
KSP (Kontakt Script)
KiXtart
Kotlin
LDIF
LLVM
LOL Code
LScript
Latex
Liberty BASIC
Linden Scripting
Lisp
Loco Basic
Logtalk
Lotus Formulas
Lotus Script
Lua
M68000 Assembler
MIX Assembler
MK-61/52
MPASM
MXML
MagikSF
Make
MapBasic
Markdown (PRO members only)
MatLab
Mercury
MetaPost
Modula 2
Modula 3
Motorola 68000 HiSoft Dev
MySQL
Nagios
NetRexx
Nginx
Nim
NullSoft Installer
OCaml
OCaml Brief
Oberon 2
Objeck Programming Langua
Objective C
Octave
Open Object Rexx
OpenBSD PACKET FILTER
OpenGL Shading
Openoffice BASIC
Oracle 11
Oracle 8
Oz
PARI/GP
PCRE
PHP
PHP Brief
PL/I
PL/SQL
POV-Ray
ParaSail
Pascal
Pawn
Per
Perl
Perl 6
Phix
Pic 16
Pike
Pixel Bender
PostScript
PostgreSQL
PowerBuilder
PowerShell
ProFTPd
Progress
Prolog
Properties
ProvideX
Puppet
PureBasic
PyCon
Python
Python for S60
QBasic
QML
R
RBScript
REBOL
REG
RPM Spec
Racket
Rails
Rexx
Robots
Roff Manpage
Ruby
Ruby Gnuplot
Rust
SAS
SCL
SPARK
SPARQL
SQF
SQL
SSH Config
Scala
Scheme
Scilab
SdlBasic
Smalltalk
Smarty
StandardML
StoneScript
SuperCollider
Swift
SystemVerilog
T-SQL
TCL
TeXgraph
Tera Term
TypeScript
TypoScript
UPC
Unicon
UnrealScript
Urbi
VB.NET
VBScript
VHDL
VIM
Vala
Vedit
VeriLog
Visual Pro Log
VisualBasic
VisualFoxPro
WHOIS
WhiteSpace
Winbatch
XBasic
XML
XPP
Xojo
Xorg Config
YAML
YARA
Z80 Assembler
ZXBasic
autoconf
jQuery
mIRC
newLISP
q/kdb+
thinBasic
Paste Expiration:
Never
Burn after read
10 Minutes
1 Hour
1 Day
1 Week
2 Weeks
1 Month
6 Months
1 Year
Paste Exposure:
Public
Unlisted
Private
Folder:
(members only)
Password
NEW
Enabled
Disabled
Burn after read
NEW
Paste Name / Title:
Create New Paste
Hello
Guest
Sign Up
or
Login
Sign in with Facebook
Sign in with Twitter
Sign in with Google
You are currently not logged in, this means you can not edit or delete anything you paste.
Sign Up
or
Login
Public Pastes
This month smells like money
CSS | 7 min ago | 1.05 KB
✅ API Flaw Money Method
CSS | 7 min ago | 1.05 KB
⭐ Exploit Documentation ⭐
CSS | 7 min ago | 1.05 KB
How to Automate PDF Processing in Python: A C...
Python | 1 day ago | 7.61 KB
HTML Simple Flexbox Layout
HTML 5 | 1 day ago | 2.13 KB
LLM-Generated Epub Reader In FreeBASIC (DOS/L...
FreeBasic | 2 days ago | 43.20 KB
webshell.php
PHP | 2 days ago | 1.27 KB
[TLF 18] - 322 / THE BLACKWIGHT
2 days ago | 3.33 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!
