DEBUG Piwik\Common[2019-02-23 01:25:51] [be319] Debug enabled - Input parameters:
DEBUG Piwik\Common[2019-02-23 01:25:51] [be319] array (
DEBUG Piwik\Common[2019-02-23 01:25:51] [be319]   'idsite' => '5',
DEBUG Piwik\Common[2019-02-23 01:25:51] [be319] )
DEBUG Piwik\Common[2019-02-23 01:25:51] [be319] Loading plugins: { CoreHome, Actions, Referrers, UserSettings, Goals, Events, UserCountry, VisitTime, VisitorInterest, Provider, Login, UsersManager, SitesManager, PrivacyManager, DevicesDetection }
DEBUG Piwik\Common[2019-02-23 01:25:51] [be319] Current datetime: 2019-02-23 01:25:51
DEBUG Piwik\Common[2019-02-23 01:25:51] [be319] Search bot detected, visit excluded
DEBUG PrivacyManager[2019-02-23 01:25:51] [be319] Visit is already excluded, no need to check DoNotTrack support.
DEBUG Piwik\Common[2019-02-23 01:25:51] [be319] Visitor excluded.
DEBUG Piwik\Common[2019-02-23 01:25:51] [be319] General tracker cache was re-created.
DEBUG Piwik\Common[2019-02-23 01:25:51] [be319] -> Scheduled tasks not triggered.
DEBUG Piwik\Common[2019-02-23 01:25:51] [be319] Next run will be from: 2019-02-23 02:08:36 UTC
DEBUG Piwik\Common[2019-02-23 01:25:51] [be319] Nothing to notice => default behaviour
DEBUG Piwik\Common[2019-02-23 01:25:51] [be319] End of the page.
DEBUG Piwik\Profiler[2019-02-23 01:25:51] [be319] <hr /><strong>Breakdown by query</strong><br/>Executed <b>2029775</b> times in <b>82608700ms</b>  (average = <b>40.7ms</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>3113475</b> times in <b>65964700ms</b>  (average = <b>21.2ms</b>) <pre>	 ( SELECT visit_last_action_time, visit_first_action_time, idvisitor, idvisit, user_id, visit_exit_idaction_url, visit_exit_idaction_name, visitor_returning, visitor_days_since_first, visitor_days_since_order, visitor_count_visits, visit_goal_buyer, location_country, location_region, location_city, location_latitude, location_longitude, referer_name, referer_keyword, referer_type, 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>3113490</b> times in <b>50593500ms</b>  (average = <b>16.2ms</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>1069374</b> times in <b>45204600ms</b>  (average = <b>42.3ms</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>3107844</b> times in <b>9333610ms</b>  (average = <b>3ms</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>3138194</b> times in <b>2174760ms</b>  (average = <b>0.7ms</b>) <pre>	connect</pre>Executed <b>33605</b> times in <b>1479630ms</b>  (average = <b>44ms</b>) <pre>	INSERT INTO piwik_log_action (name, hash, type, url_prefix) VALUES (?,CRC32(?),?,?)</pre>Executed <b>5409498</b> times in <b>1012400ms</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>723780</b> times in <b>371205ms</b>  (average = <b>0.5ms</b>) <pre>	SELECT option_value, option_name FROM `piwik_option` WHERE autoload = 1</pre>Executed <b>15580</b> times in <b>356380ms</b>  (average = <b>22.9ms</b>) <pre>	INSERT INTO `piwik_option` (option_name, option_value, autoload) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE option_value = ?</pre>Executed <b>228248</b> times in <b>353182ms</b>  (average = <b>1.5ms</b>) <pre>	SHOW COLUMNS FROM `piwik_log_link_visit_action`</pre>Executed <b>621126</b> times in <b>345805ms</b>  (average = <b>0.6ms</b>) <pre>	SELECT idsite FROM piwik_site</pre>Executed <b>228248</b> times in <b>306801ms</b>  (average = <b>1.3ms</b>) <pre>	SHOW COLUMNS FROM `piwik_log_visit`</pre>Executed <b>606799</b> times in <b>285949ms</b>  (average = <b>0.5ms</b>) <pre>	SELECT login FROM piwik_access WHERE idsite = ? AND access = ?</pre>Executed <b>1213590</b> times in <b>227078ms</b>  (average = <b>0.2ms</b>) <pre>	SELECT * FROM piwik_site WHERE idsite = ?</pre>Executed <b>228247</b> times in <b>214961ms</b>  (average = <b>0.9ms</b>) <pre>	SHOW COLUMNS FROM `piwik_log_conversion`</pre>Executed <b>606796</b> times in <b>214188ms</b>  (average = <b>0.4ms</b>) <pre>	SELECT url FROM piwik_site_url WHERE idsite = ?</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>1236</b> times in <b>76048.1ms</b>  (average = <b>61.5ms</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>38114</b> times in <b>72416.3ms</b>  (average = <b>1.9ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (6) AND deleted = 0</pre>Executed <b>101580</b> times in <b>59385.6ms</b>  (average = <b>0.6ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (2) AND deleted = 0</pre>Executed <b>105911</b> times in <b>52323.2ms</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>133976</b> times in <b>33413.3ms</b>  (average = <b>0.2ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (4) AND deleted = 0</pre>Executed <b>43971</b> times in <b>26873.5ms</b>  (average = <b>0.6ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (5) AND deleted = 0</pre>Executed <b>25865</b> times in <b>22212.7ms</b>  (average = <b>0.9ms</b>) <pre>	SELECT * FROM piwik_goal WHERE idsite IN (8) AND deleted = 0</pre>Executed <b>12635</b> times in <b>21311.3ms</b>  (average = <b>1.7ms</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>7161</b> times in <b>11079ms</b>  (average = <b>1.5ms</b>) <pre>	SELECT language FROM piwik_user_language WHERE login = ? </pre>Executed <b>14322</b> times in <b>9656ms</b>  (average = <b>0.7ms</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>773</b> times in <b>2089.4ms</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>7161</b> times in <b>1430ms</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>647</b> times in <b>887.8ms</b>  (average = <b>1.4ms</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>647</b> times in <b>664ms</b>  (average = <b>1ms</b>) <pre>	SHOW COLUMNS FROM . piwik_log_conversion</pre>Executed <b>647</b> times in <b>615ms</b>  (average = <b>1ms</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[2019-02-23 01:25:51] [be319] array (
DEBUG Piwik\Common[2019-02-23 01:25:51] [be319] )
DEBUG Piwik\Common[2019-02-23 01:25:51] [be319] Time elapsed: 0.520s