DEBUG Piwik\Common[2018-11-18 02:08:32] [1968f] Debug enabled - Input parameters:
DEBUG Piwik\Common[2018-11-18 02:08:32] [1968f] array (
DEBUG Piwik\Common[2018-11-18 02:08:32] [1968f]   'idsite' => '5',
DEBUG Piwik\Common[2018-11-18 02:08:32] [1968f] )
DEBUG Piwik\Common[2018-11-18 02:08:32] [1968f] Loading plugins: { CoreHome, Actions, Referrers, UserSettings, Goals, Events, UserCountry, VisitTime, VisitorInterest, Provider, Login, UsersManager, SitesManager, PrivacyManager, DevicesDetection }
DEBUG Piwik\Common[2018-11-18 02:08:32] [1968f] Current datetime: 2018-11-18 02:08:32
DEBUG Piwik\Common[2018-11-18 02:08:32] [1968f] Search bot detected, visit excluded
DEBUG PrivacyManager[2018-11-18 02:08:32] [1968f] Visit is already excluded, no need to check DoNotTrack support.
DEBUG Piwik\Common[2018-11-18 02:08:32] [1968f] Visitor excluded.
DEBUG Piwik\Common[2018-11-18 02:08:33] [1968f] General tracker cache was re-created.
DEBUG Piwik\Common[2018-11-18 02:08:33] [1968f] -> Scheduled tasks not triggered.
DEBUG Piwik\Common[2018-11-18 02:08:33] [1968f] Next run will be from: 2018-11-18 02:48:23 UTC
DEBUG Piwik\Common[2018-11-18 02:08:33] [1968f] Nothing to notice => default behaviour
DEBUG Piwik\Common[2018-11-18 02:08:33] [1968f] End of the page.
DEBUG Piwik\Profiler[2018-11-18 02:08:33] [1968f] <hr /><strong>Breakdown by query</strong><br/>Executed <b>1986542</b> times in <b>77931500ms</b>  (average = <b>39.2ms</b>) <pre>	UPDATE piwik_log_visit SET idvisitor = ?, visit_total_time = ?, visit_last_action_time = ?, visit_exit_idaction_name = ?, visit_exit_idaction_url = ?, visit_total_actions = visit_total_actions + 1 , custom_var_k1 = ?, custom_var_v1 = ? WHERE idsite = ? AND idvisit = ?</pre>Executed <b>3050281</b> times in <b>62984200ms</b>  (average = <b>20.6ms</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, visit_total_events, location_ip, location_browser_lang, visit_total_time, visit_total_actions, visit_total_searches , 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, custom_var_k6, custom_var_v6, custom_var_k7, custom_var_v7, custom_var_k8, custom_var_v8, custom_var_k9, custom_var_v9, custom_var_k10, custom_var_v10 , 0 as priority FROM piwik_log_visit WHERE visit_last_action_time >= ? AND visit_last_action_time <= ? AND idsite = ? AND config_id = ? AND user_id IS NULL ORDER BY visit_last_action_time DESC LIMIT 1 ) UNION ( 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, visit_total_events, location_ip, location_browser_lang, visit_total_time, visit_total_actions, visit_total_searches , 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, custom_var_k6, custom_var_v6, custom_var_k7, custom_var_v7, custom_var_k8, custom_var_v8, custom_var_k9, custom_var_v9, custom_var_k10, custom_var_v10 , 1 as priority FROM piwik_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 ) ORDER BY priority DESC LIMIT 1</pre>Executed <b>3050298</b> times in <b>49257700ms</b>  (average = <b>16.1ms</b>) <pre>	INSERT INTO piwik_log_link_visit_action (idvisit, idsite, idvisitor, idaction_url, idaction_url_ref, idaction_name_ref, server_time, time_spent_ref_action, idaction_name, custom_float) VALUES (?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>1049467</b> times in <b>43757500ms</b>  (average = <b>41.7ms</b>) <pre>	INSERT INTO piwik_log_visit (idvisitor, config_id, location_ip, visit_total_events, config_resolution, location_country, location_latitude, config_windowsmedia, config_silverlight, config_java, config_gears, config_pdf, config_quicktime, config_realplayer, location_longitude, config_device_model, config_device_brand, config_device_type, config_os, config_os_version, config_browser_version, config_browser_name, visitor_localtime, visitor_days_since_last, location_provider, config_flash, config_director, visitor_returning, visitor_days_since_order, visitor_count_visits, visit_entry_idaction_name, visit_entry_idaction_url, visit_first_action_time, visitor_days_since_first, visit_total_time, visit_goal_buyer, visit_goal_converted, visit_last_action_time, visit_exit_idaction_name, visit_exit_idaction_url, location_browser_lang, config_cookie, referer_url, referer_type, visit_total_actions, visit_total_searches, referer_keyword, referer_name, idsite) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>3044700</b> times in <b>8342300ms</b>  (average = <b>2.7ms</b>) <pre>	SELECT idaction, type, name FROM piwik_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) OR ( hash = CRC32(?) AND name = ? AND type = ? ) </pre>Executed <b>3073041</b> times in <b>2109650ms</b>  (average = <b>0.7ms</b>) <pre>	connect</pre>Executed <b>32859</b> times in <b>1399950ms</b>  (average = <b>42.6ms</b>) <pre>	INSERT INTO piwik_log_action (name, hash, type, url_prefix) VALUES (?,CRC32(?),?,?)</pre>Executed <b>5232496</b> times in <b>978600ms</b>  (average = <b>0.2ms</b>) <pre>	SELECT option_value FROM `piwik_option` WHERE option_name = ?</pre>Executed <b>13109</b> times in <b>581540ms</b>  (average = <b>44.4ms</b>) <pre>	UPDATE piwik_log_visit SET idvisitor = ?, visit_total_events = visit_total_events + 1 , visit_total_time = ?, visit_last_action_time = ?, visit_total_actions = visit_total_actions + 1 WHERE idsite = ? AND idvisit = ?</pre>Executed <b>704238</b> times in <b>344564ms</b>  (average = <b>0.5ms</b>) <pre>	SELECT option_value, option_name FROM `piwik_option` WHERE autoload = 1</pre>Executed <b>604512</b> times in <b>334731ms</b>  (average = <b>0.6ms</b>) <pre>	SELECT idsite FROM piwik_site</pre>Executed <b>217456</b> times in <b>332526ms</b>  (average = <b>1.5ms</b>) <pre>	SHOW COLUMNS FROM `piwik_log_link_visit_action`</pre>Executed <b>14664</b> times in <b>323586ms</b>  (average = <b>22.1ms</b>) <pre>	INSERT INTO `piwik_option` (option_name, option_value, autoload) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE option_value = ?</pre>Executed <b>217456</b> times in <b>281840ms</b>  (average = <b>1.3ms</b>) <pre>	SHOW COLUMNS FROM `piwik_log_visit`</pre>Executed <b>591001</b> times in <b>264799ms</b>  (average = <b>0.4ms</b>) <pre>	SELECT login FROM piwik_access WHERE idsite = ? AND access = ?</pre>Executed <b>1181994</b> times in <b>216286ms</b>  (average = <b>0.2ms</b>) <pre>	SELECT * FROM piwik_site WHERE idsite = ?</pre>Executed <b>590998</b> times in <b>203604ms</b>  (average = <b>0.3ms</b>) <pre>	SELECT url FROM piwik_site_url WHERE idsite = ?</pre>Executed <b>217455</b> times in <b>203199ms</b>  (average = <b>0.9ms</b>) <pre>	SHOW COLUMNS FROM `piwik_log_conversion`</pre>Executed <b>37577</b> times in <b>106901ms</b>  (average = <b>2.8ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (9) AND deleted = 0</pre>Executed <b>1184</b> times in <b>69712ms</b>  (average = <b>58.9ms</b>) <pre>	INSERT INTO piwik_log_visit (idvisitor, config_id, location_ip, custom_var_k1, custom_var_v1, visit_total_events, config_resolution, location_country, location_latitude, config_windowsmedia, config_silverlight, config_java, config_gears, config_pdf, config_quicktime, config_realplayer, location_longitude, config_device_model, config_device_brand, config_device_type, config_os, config_os_version, config_browser_version, config_browser_name, visitor_localtime, visitor_days_since_last, location_provider, config_flash, config_director, visitor_returning, visitor_days_since_order, visitor_count_visits, visit_entry_idaction_name, visit_entry_idaction_url, visit_first_action_time, visitor_days_since_first, visit_total_time, visit_goal_buyer, visit_goal_converted, visit_last_action_time, visit_exit_idaction_name, visit_exit_idaction_url, location_browser_lang, config_cookie, referer_url, referer_type, visit_total_actions, visit_total_searches, referer_keyword, referer_name, idsite) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)</pre>Executed <b>34785</b> times in <b>65655.5ms</b>  (average = <b>1.9ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (6) AND deleted = 0</pre>Executed <b>101386</b> times in <b>59006.6ms</b>  (average = <b>0.6ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (2) AND deleted = 0</pre>Executed <b>105794</b> times in <b>50982.4ms</b>  (average = <b>0.5ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (14) AND deleted = 0</pre>Executed <b>78443</b> times in <b>50462.8ms</b>  (average = <b>0.6ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (7) AND deleted = 0</pre>Executed <b>125410</b> times in <b>25290.6ms</b>  (average = <b>0.2ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (4) AND deleted = 0</pre>Executed <b>25662</b> times in <b>21497.3ms</b>  (average = <b>0.8ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (8) AND deleted = 0</pre>Executed <b>41441</b> times in <b>19620.4ms</b>  (average = <b>0.5ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (5) AND deleted = 0</pre>Executed <b>11780</b> times in <b>18887.4ms</b>  (average = <b>1.6ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (1) AND deleted = 0</pre>Executed <b>23440</b> times in <b>11797.6ms</b>  (average = <b>0.5ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (3) AND deleted = 0</pre>Executed <b>6753</b> times in <b>7302.2ms</b>  (average = <b>1.1ms</b>) <pre>	SELECT language FROM piwik_user_language WHERE login = ? </pre>Executed <b>13506</b> times in <b>7161.5ms</b>  (average = <b>0.5ms</b>) <pre>	SELECT login, email, token_auth FROM piwik_user WHERE superuser_access = 1 ORDER BY date_registered ASC</pre>Executed <b>2048</b> times in <b>2230.8ms</b>  (average = <b>1.1ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (15) AND deleted = 0</pre>Executed <b>769</b> times in <b>2087.6ms</b>  (average = <b>2.7ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (11) AND deleted = 0</pre>Executed <b>2119</b> times in <b>1974.3ms</b>  (average = <b>0.9ms</b>) <pre>	SELECT * FROM piwik_user WHERE login IN (?) ORDER BY login ASC</pre>Executed <b>6753</b> times in <b>1327.3ms</b>  (average = <b>0.2ms</b>) <pre>	SELECT DATABASE()</pre>Executed <b>2207</b> times in <b>1149.9ms</b>  (average = <b>0.5ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (16) AND deleted = 0</pre>Executed <b>586</b> times in <b>754.8ms</b>  (average = <b>1.3ms</b>) <pre>	SHOW COLUMNS FROM . piwik_log_visit</pre>Executed <b>26</b> times in <b>672.7ms</b>  (average = <b>25.9ms</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, visit_total_events, location_ip, location_browser_lang, visit_total_time, visit_total_actions, visit_total_searches , 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, custom_var_k6, custom_var_v6, custom_var_k7, custom_var_v7, custom_var_k8, custom_var_v8, custom_var_k9, custom_var_v9, custom_var_k10, custom_var_v10 FROM piwik_log_visit WHERE visit_last_action_time >= ? AND visit_last_action_time <= ? AND idsite = ? AND config_id = ? ORDER BY visit_last_action_time DESC LIMIT 1</pre>Executed <b>586</b> times in <b>557.7ms</b>  (average = <b>1ms</b>) <pre>	SHOW COLUMNS FROM . piwik_log_conversion</pre>Executed <b>586</b> times in <b>526.9ms</b>  (average = <b>0.9ms</b>) <pre>	SHOW COLUMNS FROM . piwik_log_link_visit_action</pre>Executed <b>261</b> times in <b>104.2ms</b>  (average = <b>0.4ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (17) AND deleted = 0</pre>
DEBUG Piwik\Common[2018-11-18 02:08:33] [1968f] array (
DEBUG Piwik\Common[2018-11-18 02:08:33] [1968f] )
DEBUG Piwik\Common[2018-11-18 02:08:33] [1968f] Time elapsed: 1.626s