API tools faq
paste
Advertisement
xiphercdb

matomo_logs

xiphercdb
Apr 19th, 2018
55
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
JSON 95.88 KB | None | 0 0
raw download clone embed print report
  1. 2018-04-19 20:05:35.679485
  2. {'_id': '0000000000030854',
  3.  'action_name': 'MP3 128k',
  4.  'cip': '178.193.1.1',
  5.  'idsite': 1,
  6.  'rec': 1,
  7.  'token_auth': '********************************',
  8.  'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; '
  9.        'es_xl)',
  10.  'url': 'http://streaming.com/live-128k.mp3'}
  11. DEBUG: Debug enabled - Input parameters:
  12. DEBUG: array (
  13. DEBUG:   'idsite' => '1',
  14. DEBUG:   'rec' => '1',
  15. DEBUG:   'action_name' => 'MP3 128k',
  16. DEBUG:   '_id' => '0000000000030854',
  17. DEBUG:   'cip' => '178.193.1.1',
  18. DEBUG:   'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)',
  19. DEBUG:   'url' => 'http://streaming.com/live-128k.mp3',
  20. DEBUG:   'token_auth' => '********************************',
  21. DEBUG: )
  22. DEBUG: Current datetime: 2018-04-19 18:05:35
  23. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()...
  24. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()...
  25. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()...
  26. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()...
  27. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()...
  28. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()...
  29. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()...
  30. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()...
  31. DEBUG: token_auth is authenticated!
  32. DEBUG: DoNotTrack header not found
  33. DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07
  34. DEBUG: The visitor was not matched with an existing visitor...
  35. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()...
  36. DEBUG: (this is not a Site Search request)
  37. 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
  38. DEBUG: Action is a PAGE_URL,
  39. DEBUG:                 Action name =  MP3 128k,
  40. DEBUG:                 Action URL = http://streaming.com/live-128k.mp3
  41. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()...
  42. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()...
  43. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()...
  44. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()...
  45. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()...
  46. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()...
  47. DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1
  48. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()...
  49. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()...
  50. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()...
  51. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()...
  52. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()...
  53. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()...
  54. DEBUG: New Visit (IP = 178.193.1.1)
  55. 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
  56. DEBUG: GEO: Found IP 178.193.1.1 location (provider 'geoip_pecl'): array (
  57. DEBUG:   'country_code' => 'CH',
  58. DEBUG:   'region_code' => '',
  59. DEBUG:   'city_name' => '',
  60. DEBUG:   'area_code' => 0,
  61. DEBUG:   'lat' => 47.145,
  62. DEBUG:   'long' => 8.155,
  63. DEBUG:   'postal_code' => '',
  64. DEBUG:   'continent_code' => 'eur',
  65. DEBUG:   'continent_name' => 'Intl_Continent_eur',
  66. DEBUG:   'country_name' => 'Unknown',
  67. DEBUG: )
  68. DEBUG: array (
  69. DEBUG:   'idvisitor' => '0000000000030854',
  70. DEBUG:   'config_id' => '3626277eddd89b07',
  71. DEBUG:   'location_ip' => '178.193.1.1',
  72. DEBUG:   'idsite' => 1,
  73. DEBUG:   'visit_first_action_time' => '2018-04-19 18:05:35',
  74. DEBUG:   'visit_goal_buyer' => 0,
  75. DEBUG:   'visit_goal_converted' => 0,
  76. DEBUG:   'visit_last_action_time' => '2018-04-19 18:05:35',
  77. DEBUG:   'visitor_days_since_first' => '0',
  78. DEBUG:   'visitor_days_since_order' => 0,
  79. DEBUG:   'visitor_returning' => 0,
  80. DEBUG:   'visitor_count_visits' => 1,
  81. DEBUG:   'visit_entry_idaction_name' => 7,
  82. DEBUG:   'visit_entry_idaction_url' => 8,
  83. DEBUG:   'visit_exit_idaction_name' => 7,
  84. DEBUG:   'visit_exit_idaction_url' => 8,
  85. DEBUG:   'visit_total_actions' => 1,
  86. DEBUG:   'visit_total_interactions' => 1,
  87. DEBUG:   'visit_total_searches' => 0,
  88. DEBUG:   'referer_keyword' => NULL,
  89. DEBUG:   'referer_name' => NULL,
  90. DEBUG:   'referer_type' => 1,
  91. DEBUG:   'referer_url' => '',
  92. DEBUG:   'location_browser_lang' => '',
  93. DEBUG:   'config_browser_engine' => 'WebKit',
  94. DEBUG:   'config_browser_name' => 'MF',
  95. DEBUG:   'config_browser_version' => '',
  96. DEBUG:   'config_device_brand' => 'AP',
  97. DEBUG:   'config_device_model' => 'iPhone',
  98. DEBUG:   'config_device_type' => 1,
  99. DEBUG:   'config_os' => 'IOS',
  100. DEBUG:   'config_os_version' => '11.2',
  101. DEBUG:   'visit_total_events' => 0,
  102. DEBUG:   'visitor_localtime' => '18:05:35',
  103. DEBUG:   'visitor_days_since_last' => 0,
  104. DEBUG:   'config_resolution' => 'unknown',
  105. DEBUG:   'config_cookie' => 0,
  106. DEBUG:   'config_director' => 0,
  107. DEBUG:   'config_flash' => 0,
  108. DEBUG:   'config_gears' => 0,
  109. DEBUG:   'config_java' => 0,
  110. DEBUG:   'config_pdf' => 0,
  111. DEBUG:   'config_quicktime' => 0,
  112. DEBUG:   'config_realplayer' => 0,
  113. DEBUG:   'config_silverlight' => 0,
  114. DEBUG:   'config_windowsmedia' => 0,
  115. DEBUG:   'visit_total_time' => 0,
  116. DEBUG:   'location_city' => '',
  117. DEBUG:   'location_country' => 'ch',
  118. DEBUG:   'location_latitude' => '47.145',
  119. DEBUG:   'location_longitude' => '8.155',
  120. DEBUG:   'location_region' => '',
  121. DEBUG: )
  122. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::recordLogs()...
  123. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::recordLogs()...
  124. DEBUG: Inserted new action:
  125. DEBUG: array (
  126. DEBUG:   'idvisit' => '173',
  127. DEBUG:   'idsite' => 1,
  128. DEBUG:   'idvisitor' => '0000000000030854',
  129. DEBUG:   'idaction_url' => '8',
  130. DEBUG:   'idaction_url_ref' => 0,
  131. DEBUG:   'idaction_name_ref' => 0,
  132. DEBUG:   'server_time' => '2018-04-19 18:05:35',
  133. DEBUG:   'idpageview' => '',
  134. DEBUG:   'interaction_position' => 1,
  135. DEBUG:   'time_spent_ref_action' => 0,
  136. DEBUG:   'idaction_name' => '7',
  137. DEBUG:   'idlink_va' => '473',
  138. DEBUG: )
  139. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::recordLogs()...
  140. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::recordLogs()...
  141. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::recordLogs()...
  142. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::recordLogs()...
  143. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::recordLogs()...
  144. DEBUG: -> Scheduled tasks not triggered.
  145. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC
  146. DEBUG: Nothing to notice => default behaviour
  147. DEBUG: End of the page.
  148. 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>
  149. DEBUG: array (
  150. DEBUG: )
  151. DEBUG: Time elapsed: 0.083s
  152.  
  153.  
  154.  
  155.  
  156. 2018-04-19 20:05:45.783178
  157. {'_id': '0000000000030854',
  158.  'action_name': 'MP3 128k',
  159.  'cip': '178.193.1.1',
  160.  'idsite': 1,
  161.  'ping': 1,
  162.  'rec': 1,
  163.  'token_auth': '********************************',
  164.  'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; '
  165.        'es_xl)',
  166.  'url': 'http://streaming.com/live-128k.mp3'}
  167. DEBUG: Debug enabled - Input parameters:
  168. DEBUG: array (
  169. DEBUG:   'idsite' => '1',
  170. DEBUG:   'rec' => '1',
  171. DEBUG:   'action_name' => 'MP3 128k',
  172. DEBUG:   '_id' => '0000000000030854',
  173. DEBUG:   'cip' => '178.193.1.1',
  174. DEBUG:   'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)',
  175. DEBUG:   'url' => 'http://streaming.com/live-128k.mp3',
  176. DEBUG:   'token_auth' => '********************************',
  177. DEBUG:   'ping' => '1',
  178. DEBUG: )
  179. DEBUG: Current datetime: 2018-04-19 18:05:45
  180. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()...
  181. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()...
  182. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()...
  183. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()...
  184. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()...
  185. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()...
  186. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()...
  187. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()...
  188. DEBUG: token_auth is authenticated!
  189. DEBUG: DoNotTrack header not found
  190. DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07
  191. DEBUG: The visitor is known (idvisitor = 0000000000030854,
  192. DEBUG:                     config_id = 3626277eddd89b07,
  193. DEBUG:                     idvisit = 173,
  194. DEBUG:                     last action = Thu, 19 Apr 2018 18:05:35 +0000,
  195. DEBUG:                     first action = Thu, 19 Apr 2018 18:05:35 +0000,
  196. DEBUG:                     visit_goal_buyer' = 0)
  197. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()...
  198. DEBUG: (this is not a Site Search request)
  199. 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
  200. DEBUG: Action is a PAGE_URL,
  201. DEBUG:                 Action name =  MP3 128k,
  202. DEBUG:                 Action URL = http://streaming.com/live-128k.mp3
  203. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()...
  204. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()...
  205. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()...
  206. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()...
  207. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()...
  208. 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
  209. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()...
  210. DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1
  211. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()...
  212. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()...
  213. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()...
  214. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()...
  215. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()...
  216. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()...
  217. DEBUG: -> ping=1 request: we do not track a new action nor a new visit nor any goal.
  218. DEBUG: Visit is known (IP = 178.193.1.1)
  219. DEBUG: Updated existing visit: array (
  220. DEBUG:   'idvisitor' => '0000000000030854',
  221. DEBUG:   'visit_total_time' => 11,
  222. DEBUG: )
  223. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::recordLogs()...
  224. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::recordLogs()...
  225. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::recordLogs()...
  226. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::recordLogs()...
  227. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::recordLogs()...
  228. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::recordLogs()...
  229. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::recordLogs()...
  230. DEBUG: -> Scheduled tasks not triggered.
  231. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC
  232. DEBUG: Nothing to notice => default behaviour
  233. DEBUG: End of the page.
  234. 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>
  235. DEBUG: array (
  236. DEBUG: )
  237. DEBUG: Time elapsed: 0.029s
  238.  
  239.  
  240.  
  241.  
  242. 2018-04-19 20:05:55.891038
  243. {'_id': '0000000000030854',
  244. 'action_name': 'MP3 128k',
  245. 'cip': '178.193.1.1',
  246. 'idsite': 1,
  247. 'ping': 1,
  248. 'rec': 1,
  249. 'token_auth': '********************************',
  250. 'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; '
  251.       'es_xl)',
  252. 'url': 'http://streaming.com/live-128k.mp3'}
  253. DEBUG: Debug enabled - Input parameters:
  254. DEBUG: array (
  255. DEBUG:   'idsite' => '1',
  256. DEBUG:   'rec' => '1',
  257. DEBUG:   'action_name' => 'MP3 128k',
  258. DEBUG:   '_id' => '0000000000030854',
  259. DEBUG:   'cip' => '178.193.1.1',
  260. DEBUG:   'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)',
  261. DEBUG:   'url' => 'http://streaming.com/live-128k.mp3',
  262. DEBUG:   'token_auth' => '********************************',
  263. DEBUG:   'ping' => '1',
  264. DEBUG: )
  265. DEBUG: Current datetime: 2018-04-19 18:05:55
  266. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()...
  267. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()...
  268. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()...
  269. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()...
  270. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()...
  271. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()...
  272. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()...
  273. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()...
  274. DEBUG: token_auth is authenticated!
  275. DEBUG: DoNotTrack header not found
  276. DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07
  277. DEBUG: The visitor is known (idvisitor = 0000000000030854,
  278. DEBUG:                     config_id = 3626277eddd89b07,
  279. DEBUG:                     idvisit = 173,
  280. DEBUG:                     last action = Thu, 19 Apr 2018 18:05:35 +0000,
  281. DEBUG:                     first action = Thu, 19 Apr 2018 18:05:35 +0000,
  282. DEBUG:                     visit_goal_buyer' = 0)
  283. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()...
  284. DEBUG: (this is not a Site Search request)
  285. 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
  286. DEBUG: Action is a PAGE_URL,
  287. DEBUG:                 Action name =  MP3 128k,
  288. DEBUG:                 Action URL = http://streaming.com/live-128k.mp3
  289. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()...
  290. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()...
  291. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()...
  292. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()...
  293. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()...
  294. 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
  295. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()...
  296. DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1
  297. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()...
  298. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()...
  299. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()...
  300. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()...
  301. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()...
  302. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()...
  303. DEBUG: -> ping=1 request: we do not track a new action nor a new visit nor any goal.
  304. DEBUG: Visit is known (IP = 178.193.1.1)
  305. DEBUG: Updated existing visit: array (
  306. DEBUG:   'idvisitor' => '0000000000030854',
  307. DEBUG:   'visit_total_time' => 21,
  308. DEBUG: )
  309. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::recordLogs()...
  310. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::recordLogs()...
  311. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::recordLogs()...
  312. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::recordLogs()...
  313. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::recordLogs()...
  314. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::recordLogs()...
  315. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::recordLogs()...
  316. DEBUG: -> Scheduled tasks not triggered.
  317. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC
  318. DEBUG: Nothing to notice => default behaviour
  319. DEBUG: End of the page.
  320. 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>
  321. DEBUG: array (
  322. DEBUG: )
  323. DEBUG: Time elapsed: 0.036s
  324.  
  325.  
  326.  
  327.  
  328. 2018-04-19 20:06:05.997436
  329. {'_id': '0000000000030854',
  330. 'action_name': 'MP3 128k',
  331. 'cip': '178.193.1.1',
  332. 'idsite': 1,
  333. 'ping': 1,
  334. 'rec': 1,
  335. 'token_auth': '********************************',
  336. 'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; '
  337.       'es_xl)',
  338. 'url': 'http://streaming.com/live-128k.mp3'}
  339. DEBUG: Debug enabled - Input parameters:
  340. DEBUG: array (
  341. DEBUG:   'idsite' => '1',
  342. DEBUG:   'rec' => '1',
  343. DEBUG:   'action_name' => 'MP3 128k',
  344. DEBUG:   '_id' => '0000000000030854',
  345. DEBUG:   'cip' => '178.193.1.1',
  346. DEBUG:   'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)',
  347. DEBUG:   'url' => 'http://streaming.com/live-128k.mp3',
  348. DEBUG:   'token_auth' => '********************************',
  349. DEBUG:   'ping' => '1',
  350. DEBUG: )
  351. DEBUG: Current datetime: 2018-04-19 18:06:05
  352. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()...
  353. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()...
  354. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()...
  355. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()...
  356. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()...
  357. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()...
  358. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()...
  359. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()...
  360. DEBUG: token_auth is authenticated!
  361. DEBUG: DoNotTrack header not found
  362. DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07
  363. DEBUG: The visitor is known (idvisitor = 0000000000030854,
  364. DEBUG:                     config_id = 3626277eddd89b07,
  365. DEBUG:                     idvisit = 173,
  366. DEBUG:                     last action = Thu, 19 Apr 2018 18:05:35 +0000,
  367. DEBUG:                     first action = Thu, 19 Apr 2018 18:05:35 +0000,
  368. DEBUG:                     visit_goal_buyer' = 0)
  369. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()...
  370. DEBUG: (this is not a Site Search request)
  371. 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
  372. DEBUG: Action is a PAGE_URL,
  373. DEBUG:                 Action name =  MP3 128k,
  374. DEBUG:                 Action URL = http://streaming.com/live-128k.mp3
  375. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()...
  376. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()...
  377. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()...
  378. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()...
  379. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()...
  380. 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
  381. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()...
  382. DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1
  383. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()...
  384. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()...
  385. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()...
  386. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()...
  387. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()...
  388. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()...
  389. DEBUG: -> ping=1 request: we do not track a new action nor a new visit nor any goal.
  390. DEBUG: Visit is known (IP = 178.193.1.1)
  391. DEBUG: Updated existing visit: array (
  392. DEBUG:   'idvisitor' => '0000000000030854',
  393. DEBUG:   'visit_total_time' => 31,
  394. DEBUG: )
  395. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::recordLogs()...
  396. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::recordLogs()...
  397. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::recordLogs()...
  398. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::recordLogs()...
  399. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::recordLogs()...
  400. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::recordLogs()...
  401. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::recordLogs()...
  402. DEBUG: -> Scheduled tasks not triggered.
  403. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC
  404. DEBUG: Nothing to notice => default behaviour
  405. DEBUG: End of the page.
  406. 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>
  407. DEBUG: array (
  408. DEBUG: )
  409. DEBUG: Time elapsed: 0.035s
  410.  
  411.  
  412.  
  413.  
  414. 2018-04-19 20:06:16.111824
  415. {'_id': '0000000000030854',
  416. 'action_name': 'MP3 128k',
  417. 'cip': '178.193.1.1',
  418. 'idsite': 1,
  419. 'ping': 1,
  420. 'rec': 1,
  421. 'token_auth': '********************************',
  422. 'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; '
  423.       'es_xl)',
  424. 'url': 'http://streaming.com/live-128k.mp3'}
  425. DEBUG: Debug enabled - Input parameters:
  426. DEBUG: array (
  427. DEBUG:   'idsite' => '1',
  428. DEBUG:   'rec' => '1',
  429. DEBUG:   'action_name' => 'MP3 128k',
  430. DEBUG:   '_id' => '0000000000030854',
  431. DEBUG:   'cip' => '178.193.1.1',
  432. DEBUG:   'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)',
  433. DEBUG:   'url' => 'http://streaming.com/live-128k.mp3',
  434. DEBUG:   'token_auth' => '********************************',
  435. DEBUG:   'ping' => '1',
  436. DEBUG: )
  437. DEBUG: Current datetime: 2018-04-19 18:06:16
  438. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()...
  439. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()...
  440. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()...
  441. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()...
  442. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()...
  443. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()...
  444. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()...
  445. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()...
  446. DEBUG: token_auth is authenticated!
  447. DEBUG: DoNotTrack header not found
  448. DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07
  449. DEBUG: The visitor is known (idvisitor = 0000000000030854,
  450. DEBUG:                     config_id = 3626277eddd89b07,
  451. DEBUG:                     idvisit = 173,
  452. DEBUG:                     last action = Thu, 19 Apr 2018 18:05:35 +0000,
  453. DEBUG:                     first action = Thu, 19 Apr 2018 18:05:35 +0000,
  454. DEBUG:                     visit_goal_buyer' = 0)
  455. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()...
  456. DEBUG: (this is not a Site Search request)
  457. 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
  458. DEBUG: Action is a PAGE_URL,
  459. DEBUG:                 Action name =  MP3 128k,
  460. DEBUG:                 Action URL = http://streaming.com/live-128k.mp3
  461. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()...
  462. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()...
  463. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()...
  464. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()...
  465. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()...
  466. 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
  467. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()...
  468. DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1
  469. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()...
  470. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()...
  471. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()...
  472. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()...
  473. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()...
  474. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()...
  475. DEBUG: -> ping=1 request: we do not track a new action nor a new visit nor any goal.
  476. DEBUG: Visit is known (IP = 178.193.1.1)
  477. DEBUG: Updated existing visit: array (
  478. DEBUG:   'idvisitor' => '0000000000030854',
  479. DEBUG:   'visit_total_time' => 42,
  480. DEBUG: )
  481. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::recordLogs()...
  482. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::recordLogs()...
  483. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::recordLogs()...
  484. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::recordLogs()...
  485. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::recordLogs()...
  486. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::recordLogs()...
  487. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::recordLogs()...
  488. DEBUG: -> Scheduled tasks not triggered.
  489. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC
  490. DEBUG: Nothing to notice => default behaviour
  491. DEBUG: End of the page.
  492. 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>
  493. DEBUG: array (
  494. DEBUG: )
  495. DEBUG: Time elapsed: 0.042s
  496.  
  497.  
  498.  
  499.  
  500. 2018-04-19 20:06:26.224112
  501. {'_id': '0000000000030854',
  502. 'action_name': 'MP3 128k',
  503. 'cip': '178.193.1.1',
  504. 'idsite': 1,
  505. 'ping': 1,
  506. 'rec': 1,
  507. 'token_auth': '********************************',
  508. 'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; '
  509.       'es_xl)',
  510. 'url': 'http://streaming.com/live-128k.mp3'}
  511. DEBUG: Debug enabled - Input parameters:
  512. DEBUG: array (
  513. DEBUG:   'idsite' => '1',
  514. DEBUG:   'rec' => '1',
  515. DEBUG:   'action_name' => 'MP3 128k',
  516. DEBUG:   '_id' => '0000000000030854',
  517. DEBUG:   'cip' => '178.193.1.1',
  518. DEBUG:   'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)',
  519. DEBUG:   'url' => 'http://streaming.com/live-128k.mp3',
  520. DEBUG:   'token_auth' => '********************************',
  521. DEBUG:   'ping' => '1',
  522. DEBUG: )
  523. DEBUG: Current datetime: 2018-04-19 18:06:26
  524. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()...
  525. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()...
  526. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()...
  527. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()...
  528. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()...
  529. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()...
  530. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()...
  531. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()...
  532. DEBUG: token_auth is authenticated!
  533. DEBUG: DoNotTrack header not found
  534. DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07
  535. DEBUG: The visitor is known (idvisitor = 0000000000030854,
  536. DEBUG:                     config_id = 3626277eddd89b07,
  537. DEBUG:                     idvisit = 173,
  538. DEBUG:                     last action = Thu, 19 Apr 2018 18:05:35 +0000,
  539. DEBUG:                     first action = Thu, 19 Apr 2018 18:05:35 +0000,
  540. DEBUG:                     visit_goal_buyer' = 0)
  541. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()...
  542. DEBUG: (this is not a Site Search request)
  543. 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
  544. DEBUG: Action is a PAGE_URL,
  545. DEBUG:                 Action name =  MP3 128k,
  546. DEBUG:                 Action URL = http://streaming.com/live-128k.mp3
  547. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()...
  548. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()...
  549. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()...
  550. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()...
  551. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()...
  552. 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
  553. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()...
  554. DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1
  555. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()...
  556. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()...
  557. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()...
  558. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()...
  559. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()...
  560. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()...
  561. DEBUG: -> ping=1 request: we do not track a new action nor a new visit nor any goal.
  562. DEBUG: Visit is known (IP = 178.193.1.1)
  563. DEBUG: Updated existing visit: array (
  564. DEBUG:   'idvisitor' => '0000000000030854',
  565. DEBUG:   'visit_total_time' => 52,
  566. DEBUG: )
  567. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::recordLogs()...
  568. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::recordLogs()...
  569. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::recordLogs()...
  570. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::recordLogs()...
  571. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::recordLogs()...
  572. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::recordLogs()...
  573. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::recordLogs()...
  574. DEBUG: -> Scheduled tasks not triggered.
  575. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC
  576. DEBUG: Nothing to notice => default behaviour
  577. DEBUG: End of the page.
  578. 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>
  579. DEBUG: array (
  580. DEBUG: )
  581. DEBUG: Time elapsed: 0.032s
  582.  
  583.  
  584.  
  585.  
  586. 2018-04-19 20:06:36.346488
  587. {'_id': '0000000000030854',
  588. 'action_name': 'MP3 128k',
  589. 'cip': '178.193.1.1',
  590. 'idsite': 1,
  591. 'ping': 1,
  592. 'rec': 1,
  593. 'token_auth': '********************************',
  594. 'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; '
  595.       'es_xl)',
  596. 'url': 'http://streaming.com/live-128k.mp3'}
  597. DEBUG: Debug enabled - Input parameters:
  598. DEBUG: array (
  599. DEBUG:   'idsite' => '1',
  600. DEBUG:   'rec' => '1',
  601. DEBUG:   'action_name' => 'MP3 128k',
  602. DEBUG:   '_id' => '0000000000030854',
  603. DEBUG:   'cip' => '178.193.1.1',
  604. DEBUG:   'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)',
  605. DEBUG:   'url' => 'http://streaming.com/live-128k.mp3',
  606. DEBUG:   'token_auth' => '********************************',
  607. DEBUG:   'ping' => '1',
  608. DEBUG: )
  609. DEBUG: Current datetime: 2018-04-19 18:06:36
  610. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()...
  611. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()...
  612. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()...
  613. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()...
  614. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()...
  615. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()...
  616. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()...
  617. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()...
  618. DEBUG: token_auth is authenticated!
  619. DEBUG: DoNotTrack header not found
  620. DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07
  621. DEBUG: The visitor was not matched with an existing visitor...
  622. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()...
  623. DEBUG: (this is not a Site Search request)
  624. 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
  625. DEBUG: Action is a PAGE_URL,
  626. DEBUG:                 Action name =  MP3 128k,
  627. DEBUG:                 Action URL = http://streaming.com/live-128k.mp3
  628. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()...
  629. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()...
  630. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()...
  631. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()...
  632. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()...
  633. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()...
  634. DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1
  635. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()...
  636. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()...
  637. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()...
  638. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()...
  639. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()...
  640. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()...
  641. DEBUG: -> ping=1 request: we do not track a new action nor a new visit nor any goal.
  642. DEBUG: -> ping=1 request: we do _not_ create a new visit.
  643. DEBUG: -> aborting due to afterRequestProcessed method
  644. DEBUG: -> Scheduled tasks not triggered.
  645. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC
  646. DEBUG: Nothing to notice => default behaviour
  647. DEBUG: End of the page.
  648. 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>
  649. DEBUG: array (
  650. DEBUG: )
  651. DEBUG: Time elapsed: 0.037s
  652.  
  653.  
  654.  
  655.  
  656. 2018-04-19 20:06:46.445839
  657. {'_id': '0000000000030854',
  658.  'action_name': 'MP3 128k',
  659.  'cip': '178.193.1.1',
  660.  'idsite': 1,
  661.  'ping': 1,
  662.  'rec': 1,
  663.  'token_auth': '********************************',
  664.  'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; '
  665.        'es_xl)',
  666.  'url': 'http://streaming.com/live-128k.mp3'}
  667. DEBUG: Debug enabled - Input parameters:
  668. DEBUG: array (
  669. DEBUG:   'idsite' => '1',
  670. DEBUG:   'rec' => '1',
  671. DEBUG:   'action_name' => 'MP3 128k',
  672. DEBUG:   '_id' => '0000000000030854',
  673. DEBUG:   'cip' => '178.193.1.1',
  674. DEBUG:   'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)',
  675. DEBUG:   'url' => 'http://streaming.com/live-128k.mp3',
  676. DEBUG:   'token_auth' => '********************************',
  677. DEBUG:   'ping' => '1',
  678. DEBUG: )
  679. DEBUG: Current datetime: 2018-04-19 18:06:46
  680. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()...
  681. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()...
  682. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()...
  683. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()...
  684. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()...
  685. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()...
  686. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()...
  687. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()...
  688. DEBUG: token_auth is authenticated!
  689. DEBUG: DoNotTrack header not found
  690. DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07
  691. DEBUG: The visitor was not matched with an existing visitor...
  692. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()...
  693. DEBUG: (this is not a Site Search request)
  694. 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
  695. DEBUG: Action is a PAGE_URL,
  696. DEBUG:                 Action name =  MP3 128k,
  697. DEBUG:                 Action URL = http://streaming.com/live-128k.mp3
  698. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()...
  699. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()...
  700. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()...
  701. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()...
  702. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()...
  703. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()...
  704. DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1
  705. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()...
  706. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()...
  707. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()...
  708. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()...
  709. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()...
  710. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()...
  711. DEBUG: -> ping=1 request: we do not track a new action nor a new visit nor any goal.
  712. DEBUG: -> ping=1 request: we do _not_ create a new visit.
  713. DEBUG: -> aborting due to afterRequestProcessed method
  714. DEBUG: -> Scheduled tasks not triggered.
  715. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC
  716. DEBUG: Nothing to notice => default behaviour
  717. DEBUG: End of the page.
  718. 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>
  719. DEBUG: array (
  720. DEBUG: )
  721. DEBUG: Time elapsed: 0.028s
  722.  
  723.  
  724.  
  725.  
  726. 2018-04-19 20:06:56.539340
  727. {'_id': '0000000000030854',
  728.  'action_name': 'MP3 128k',
  729.  'cip': '178.193.1.1',
  730.  'idsite': 1,
  731.  'ping': 1,
  732.  'rec': 1,
  733.  'token_auth': '********************************',
  734.  'ua': 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; '
  735.        'es_xl)',
  736.  'url': 'http://streaming.com/live-128k.mp3'}
  737. DEBUG: Debug enabled - Input parameters:
  738. DEBUG: array (
  739. DEBUG:   'idsite' => '1',
  740. DEBUG:   'rec' => '1',
  741. DEBUG:   'action_name' => 'MP3 128k',
  742. DEBUG:   '_id' => '0000000000030854',
  743. DEBUG:   'cip' => '178.193.1.1',
  744. DEBUG:   'ua' => 'AppleCoreMedia/1.0.0.15D100 (iPhone; U; CPU OS 11_2_6 like Mac OS X; es_xl)',
  745. DEBUG:   'url' => 'http://streaming.com/live-128k.mp3',
  746. DEBUG:   'token_auth' => '********************************',
  747. DEBUG:   'ping' => '1',
  748. DEBUG: )
  749. DEBUG: Current datetime: 2018-04-19 18:06:56
  750. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()...
  751. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()...
  752. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()...
  753. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()...
  754. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()...
  755. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()...
  756. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()...
  757. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()...
  758. DEBUG: token_auth is authenticated!
  759. DEBUG: DoNotTrack header not found
  760. DEBUG: Matching visitors with: visitorId=0000000000030854 OR configId=3626277eddd89b07
  761. DEBUG: The visitor was not matched with an existing visitor...
  762. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::processRequestParams()...
  763. DEBUG: (this is not a Site Search request)
  764. 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
  765. DEBUG: Action is a PAGE_URL,
  766. DEBUG:                 Action name =  MP3 128k,
  767. DEBUG:                 Action URL = http://streaming.com/live-128k.mp3
  768. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::processRequestParams()...
  769. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::processRequestParams()...
  770. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::processRequestParams()...
  771. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::processRequestParams()...
  772. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::processRequestParams()...
  773. DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::afterRequestProcessed()...
  774. DEBUG: Visitor IP was _not_ anonymized: 178.193.1.1
  775. DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::afterRequestProcessed()...
  776. DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::afterRequestProcessed()...
  777. DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::afterRequestProcessed()...
  778. DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::afterRequestProcessed()...
  779. DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::afterRequestProcessed()...
  780. DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::afterRequestProcessed()...
  781. DEBUG: -> ping=1 request: we do not track a new action nor a new visit nor any goal.
  782. DEBUG: -> ping=1 request: we do _not_ create a new visit.
  783. DEBUG: -> aborting due to afterRequestProcessed method
  784. DEBUG: -> Scheduled tasks not triggered.
  785. DEBUG: Next run will be from: 2018-04-19 19:05:13 UTC
  786. DEBUG: Nothing to notice => default behaviour
  787. DEBUG: End of the page.
  788. 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>
  789. DEBUG: array (
  790. DEBUG: )
  791. DEBUG: Time elapsed: 0.024s
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!