DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] Debug enabled - Input parameters:
DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] array (
DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] 'idsite' => '1',
DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] )
DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] Loading plugins: { CoreHome, Actions, Referrers, UserSettings, DevicesDetection, Goals, Events, UserCountry, VisitTime, VisitorInterest, Provider, Login, UsersManager, SitesManager, PrivacyManager, Contents }
DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] Current datetime: 2015-12-06 08:04:45
DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] GET parameter rec not found in URL, request excluded
DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] 'rec' parameter not found.
DEBUG PrivacyManager[2015-12-06 08:04:45] [38bb0] Visit is already excluded, no need to check DoNotTrack support.
DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] Visitor excluded.
DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] General tracker cache was re-created.
DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] -> Scheduled tasks not triggered.
DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] Next run will be from: 2015-12-06 08:43:26 UTC
DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] Nothing to notice => default behaviour
DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] End of the page.
DEBUG Piwik\Profiler[2015-12-06 08:04:45] [38bb0] <hr /><strong>Breakdown by query</strong><br/>Executed <b>73291</b> times in <b>1030770ms</b> (average = <b>14.1ms</b>) <pre> INSERT INTO piwik_log_visit (idvisitor, config_id, location_ip, config_browser_name, config_resolution, config_browser_version, config_device_brand, config_device_model, config_windowsmedia, config_silverlight, config_java, config_gears, config_pdf, config_quicktime, config_realplayer, config_device_type, config_os, visitor_localtime, visitor_days_since_last, visit_total_events, config_os_version, location_country, 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, user_id, 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>125716</b> times in <b>459617ms</b> (average = <b>3.7ms</b>) <pre> connect</pre>Executed <b>26530</b> times in <b>422578ms</b> (average = <b>15.9ms</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 WHERE idsite = ? AND idvisit = ?</pre>Executed <b>117156</b> times in <b>356609ms</b> (average = <b>3ms</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>78086</b> times in <b>355241ms</b> (average = <b>4.5ms</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, location_ip, location_browser_lang, visit_total_events, 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 , 0 as priority 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 ) 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, location_ip, location_browser_lang, visit_total_events, 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 , 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>39070</b> times in <b>229312ms</b> (average = <b>5.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, location_ip, location_browser_lang, visit_total_events, 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 , 0 as priority 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 ) 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, location_ip, location_browser_lang, visit_total_events, 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 , 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>24477</b> times in <b>202966ms</b> (average = <b>8.3ms</b>) <pre> SHOW COLUMNS FROM `piwik_log_visit`</pre>Executed <b>24477</b> times in <b>192034ms</b> (average = <b>7.8ms</b>) <pre> SHOW COLUMNS FROM `piwik_log_link_visit_action`</pre>Executed <b>24477</b> times in <b>177551ms</b> (average = <b>7.3ms</b>) <pre> SHOW COLUMNS FROM `piwik_log_conversion`</pre>Executed <b>17335</b> times in <b>153201ms</b> (average = <b>8.8ms</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 WHERE idsite = ? AND idvisit = ?</pre>Executed <b>357606</b> times in <b>136572ms</b> (average = <b>0.4ms</b>) <pre> SELECT option_value FROM `piwik_option` WHERE option_name = ?</pre>Executed <b>77982</b> times in <b>108634ms</b> (average = <b>1.4ms</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>39025</b> times in <b>76428.8ms</b> (average = <b>2ms</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>24415</b> times in <b>64837.3ms</b> (average = <b>2.7ms</b>) <pre> SELECT option_value, option_name FROM `piwik_option` WHERE autoload = 1</pre>Executed <b>6263</b> times in <b>57254.9ms</b> (average = <b>9.1ms</b>) <pre> INSERT INTO piwik_log_action( name, hash, type, url_prefix ) VALUES (?,CRC32(?),?,?)</pre>Executed <b>10175</b> times in <b>30928.4ms</b> (average = <b>3ms</b>) <pre> SELECT option_value, option_name FROM `piwik_option` WHERE autoload = 1</pre>Executed <b>28901</b> times in <b>19377.1ms</b> (average = <b>0.7ms</b>) <pre> SELECT idsite FROM piwik_site</pre>Executed <b>35250</b> times in <b>18942.4ms</b> (average = <b>0.5ms</b>) <pre> SELECT * FROM piwik_site WHERE idsite = ?</pre>Executed <b>4628</b> times in <b>16649.1ms</b> (average = <b>3.6ms</b>) <pre> INSERT INTO `piwik_option` (option_name, option_value, autoload) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE option_value = ?</pre>Executed <b>17625</b> times in <b>14208.5ms</b> (average = <b>0.8ms</b>) <pre> SELECT * FROM piwik_goal WHERE idsite IN (1) AND deleted = 0</pre>Executed <b>17625</b> times in <b>10639.6ms</b> (average = <b>0.6ms</b>) <pre> SELECT login FROM piwik_access WHERE idsite = ? AND access = ?</pre>Executed <b>17625</b> times in <b>8789.5ms</b> (average = <b>0.5ms</b>) <pre> SELECT url FROM piwik_site_url WHERE idsite = ?</pre>Executed <b>14954</b> times in <b>8618.6ms</b> (average = <b>0.6ms</b>) <pre> SELECT * FROM piwik_site WHERE idsite = ?</pre>Executed <b>7477</b> times in <b>8162.7ms</b> (average = <b>1.1ms</b>) <pre> SELECT * FROM piwik_goal WHERE idsite IN (1) AND deleted = 0</pre>Executed <b>578</b> times in <b>4963.2ms</b> (average = <b>8.6ms</b>) <pre> SHOW COLUMNS FROM . piwik_log_visit</pre>Executed <b>7477</b> times in <b>4886.5ms</b> (average = <b>0.7ms</b>) <pre> SELECT login FROM piwik_access WHERE idsite = ? AND access = ?</pre>Executed <b>7477</b> times in <b>4425.5ms</b> (average = <b>0.6ms</b>) <pre> SELECT url FROM piwik_site_url WHERE idsite = ?</pre>Executed <b>578</b> times in <b>4150.1ms</b> (average = <b>7.2ms</b>) <pre> SHOW COLUMNS FROM . piwik_log_conversion</pre>Executed <b>578</b> times in <b>4062ms</b> (average = <b>7ms</b>) <pre> SHOW COLUMNS FROM . piwik_log_link_visit_action</pre>Executed <b>2619</b> times in <b>3455.8ms</b> (average = <b>1.3ms</b>) <pre> SELECT * FROM piwik_user WHERE login = ?</pre>Executed <b>1134</b> times in <b>2090.8ms</b> (average = <b>1.8ms</b>) <pre> SELECT * FROM piwik_user WHERE login = ?</pre>Executed <b>2619</b> times in <b>1909.6ms</b> (average = <b>0.7ms</b>) <pre> SELECT login, token_auth FROM piwik_user WHERE superuser_access = 1 ORDER BY date_registered ASC</pre>Executed <b>2578</b> times in <b>1814.3ms</b> (average = <b>0.7ms</b>) <pre> SELECT access, t2.idsite FROM piwik_access as t1 JOIN piwik_site as t2 USING (idsite) WHERE login = ?</pre>Executed <b>3753</b> times in <b>1529.1ms</b> (average = <b>0.4ms</b>) <pre> SELECT DATABASE()</pre>Executed <b>1134</b> times in <b>875.2ms</b> (average = <b>0.8ms</b>) <pre> SELECT login, token_auth FROM piwik_user WHERE superuser_access = 1 ORDER BY date_registered ASC</pre>Executed <b>1129</b> times in <b>830.5ms</b> (average = <b>0.7ms</b>) <pre> SELECT access, t2.idsite FROM piwik_access as t1 JOIN piwik_site as t2 USING (idsite) WHERE login = ?</pre>Executed <b>46</b> times in <b>23.7ms</b> (average = <b>0.5ms</b>) <pre> SELECT language FROM piwik_user_language WHERE login = ? </pre>
DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] array (
DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] 'PHPSESSID' => 'jf26kerf5hhnj1chk98jfafef7',
DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] )
DEBUG Piwik\Common[2015-12-06 08:04:45] [38bb0] Time elapsed: 0.433s