DEBUG: Debug enabled - Input parameters: DEBUG: array ( DEBUG: 'idsite' => '4', DEBUG: ) DEBUG: Current datetime: 2024-04-30 06:57:39 DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Goals\Tracker\GoalsRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Ecommerce\Tracker\EcommerceRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\SitesManager\Tracker\SitesManagerRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CustomVariables\Tracker\CustomVariablesRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\Heartbeat\Tracker\PingRequestProcessor::manipulateRequest()... DEBUG: Executing Piwik\Plugins\CoreHome\Tracker\VisitRequestProcessor::processRequestParams()... DEBUG: Search bot detected, visit excluded DEBUG: Visit is already excluded, no need to check DoNotTrack support. DEBUG: Visitor excluded. DEBUG: -> aborting due to processRequestParams method DEBUG: General tracker cache was re-created. DEBUG: -> Scheduled Tasks: Starting... DEBUG: /usr/bin/php -q /home/piwikalitics/public_html/console climulti:request -q --piwik-domain='analytics.shaid.net' --superuser 'module=API&format=csv&convertToUnicode=0&method=CoreAdminHome.runScheduledTasks&trigger=archivephp&pid=1f3470106a5419db82ac80de9202857fa58e06052d316bf0a795e2ab18d1b4ece97b519fb0451b14833e61e59cdc77bde5890' > /home/piwikalitics/public_html/tmp/climulti/1f3470106a5419db82ac80de9202857fa58e06052d316bf0a795e2ab18d1b4ece97b519fb0451b14833e61e59cdc77bde5890.output 2>&1 & DEBUG: task,output DEBUG: Piwik\Plugins\CoreAdminHome\Tasks.purgeOutdatedArchives,Time elapsed: 0.069s DEBUG: Piwik\Plugins\CoreAdminHome\Tasks.updateSpammerBlacklist,Time elapsed: 0.249s DEBUG: Piwik\Plugins\ExamplePlugin\Tasks.myTask,Time elapsed: 0.000s DEBUG: Piwik\Plugins\Referrers\Tasks.updateSearchEngines,Time elapsed: 0.396s DEBUG: Piwik\Plugins\Referrers\Tasks.updateSocials,Time elapsed: 0.262s DEBUG: Piwik\Plugins\UsersManager\Tasks.setUserDefaultReportPreference,Time elapsed: 0.003s DEBUG: Piwik\Plugins\CoreAdminHome\Tasks.purgeInvalidatedArchives,Time elapsed: 0.001s DEBUG: Piwik\Plugins\PrivacyManager\Tasks.deleteReportData,Time elapsed: 0.006s DEBUG: Piwik\Plugins\PrivacyManager\Tasks.deleteLogData,Time elapsed: 0.004s DEBUG: Piwik\Plugins\CorePluginsAdmin\Tasks.clearAllCacheEntries,Time elapsed: 0.002s DEBUG: Piwik\Plugins\CorePluginsAdmin\Tasks.sendNotificationIfUpdatesAvailable,Time elapsed: 0.001s DEBUG: Piwik\Plugins\CoreAdminHome\Tasks.optimizeArchiveTable,Time elapsed: 0.029s DEBUG: Piwik\Plugins\UserCountry\GeoIPAutoUpdater.update,ERROR: GeoIPAutoUpdater: failed to download 'http://geolite.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz' to '/home/piwikalitics/public_html/misc/GeoIPCity.dat.dat.gz': curl_exec: Could not resolve host: geolite.maxmind.com. Hostname requested was: geolite.maxmind.com DEBUG: Piwik\Plugins\CoreUpdater\Tasks.sendNotificationIfUpdateAvailable,Time elapsed: 0.001s DEBUG: Piwik\Plugins\DBStats\Tasks.cacheDataByArchiveNameReports,Time elapsed: 0.194s DEBUG: Finished Scheduled Tasks. DEBUG: Next run will be from: 2024-04-28 09:19:00 UTC DEBUG: Nothing to notice => default behaviour DEBUG: End of the page. DEBUG:

Breakdown by query
Executed 39741 times in 7237.2ms (average = 0.2ms)

	SELECT option_value FROM `piwik_option` WHERE option_name = ?

Executed 5031 times in 5946.1ms (average = 1.2ms)

	INSERT INTO `piwik_option` (option_name, option_value, autoload) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE option_value = ?

Executed 4332 times in 2996.4ms (average = 0.7ms)

	connect

Executed 3635 times in 2954.9ms (average = 0.8ms)

	SELECT option_value, option_name FROM `piwik_option` WHERE autoload = 1

Executed 1264 times in 2817.4ms (average = 2.2ms)

	INSERT INTO piwik_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_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, location_provider) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

Executed 2627 times in 2252.1ms (average = 0.9ms)

	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) VALUES (?,?,?,?,?,?,?,?,?)

Executed 3434 times in 1895.1ms (average = 0.6ms)

	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 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

Executed 1718 times in 1542.8ms (average = 0.9ms)

	SHOW COLUMNS FROM `piwik_log_visit`

Executed 1718 times in 1351.6ms (average = 0.8ms)

	SHOW COLUMNS FROM `piwik_log_link_visit_action`

Executed 1718 times in 1145.8ms (average = 0.7ms)

	SHOW COLUMNS FROM `piwik_log_conversion`

Executed 489 times in 1026.6ms (average = 2.1ms)

	INSERT INTO piwik_log_visit (idvisitor, config_id, location_ip, location_longitude, location_latitude, location_region, visitor_localtime, location_country, location_city, config_device_type, config_device_model, config_os, config_os_version, visit_total_events, visitor_days_since_last, config_quicktime, config_pdf, config_realplayer, config_silverlight, config_windowsmedia, config_java, config_gears, config_resolution, location_provider, config_cookie, config_director, config_flash, config_device_brand, config_browser_version, 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, referer_url, location_browser_lang, config_browser_engine, config_browser_name, referer_type, referer_name, visit_total_actions, visit_total_searches, referer_keyword, idsite) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

Executed 2626 times in 959.5ms (average = 0.4ms)

	SELECT MIN(idaction) as idaction, type, name FROM piwik_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) OR ( hash = CRC32(?) AND name = ? AND type = ? ) GROUP BY type, hash, name

Executed 388 times in 714.2ms (average = 1.8ms)

	UPDATE piwik_log_visit SET idvisitor = ?, visit_last_action_time = ?, visit_exit_idaction_name = ?, visit_exit_idaction_url = ?, visit_total_actions = visit_total_actions + 1 , visit_total_time = ? WHERE idsite = ? AND idvisit = ?

Executed 320 times in 526.4ms (average = 1.6ms)

	UPDATE piwik_log_visit SET idvisitor = ?, visit_last_action_time = ?, visit_exit_idaction_url = ?, visit_total_actions = visit_total_actions + 1 , visit_total_time = ? WHERE idsite = ? AND idvisit = ?

Executed 654 times in 521.2ms (average = 0.8ms)

	 ( 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 = ? 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, 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

Executed 361 times in 491.6ms (average = 1.4ms)

	SHOW COLUMNS FROM . piwik_log_visit

Executed 3660 times in 387.9ms (average = 0.1ms)

	SELECT * FROM piwik_site WHERE idsite = ?

Executed 230 times in 382.8ms (average = 1.7ms)

	INSERT INTO piwik_log_action (name, hash, type, url_prefix) VALUES (?,CRC32(?),?,?)

Executed 361 times in 277.1ms (average = 0.8ms)

	SHOW COLUMNS FROM . piwik_log_conversion

Executed 2521 times in 249.5ms (average = 0.1ms)

	SELECT idsite FROM piwik_site

Executed 2017 times in 239.9ms (average = 0.1ms)

	SELECT idsite, main_url as url FROM piwik_site

Executed 361 times in 233.5ms (average = 0.6ms)

	SHOW COLUMNS FROM . piwik_log_link_visit_action

Executed 161 times in 219.8ms (average = 1.4ms)

	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 = ?

Executed 2017 times in 205.1ms (average = 0.1ms)

	SELECT idsite, url FROM piwik_site_url

Executed 1830 times in 188.3ms (average = 0.1ms)

	SELECT login FROM piwik_access WHERE idsite = ? AND access = ?

Executed 1920 times in 181.4ms (average = 0.1ms)

	SELECT login, email, token_auth FROM piwik_user WHERE superuser_access = 1 ORDER BY date_registered ASC

Executed 1830 times in 176.9ms (average = 0.1ms)

	SELECT url FROM piwik_site_url WHERE idsite = ?

Executed 1920 times in 156.4ms (average = 0.1ms)

	SELECT language FROM piwik_user_language WHERE login = ?

Executed 960 times in 115.4ms (average = 0.1ms)

	SELECT DATABASE()

Executed 854 times in 108.6ms (average = 0.1ms)

	SELECT * FROM piwik_goal WHERE idsite IN (2) AND deleted = 0

Executed 230 times in 60ms (average = 0.3ms)

	SELECT idaction, type, name FROM piwik_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) ORDER BY idaction ASC LIMIT 1

Executed 530 times in 59.4ms (average = 0.1ms)

	SELECT * FROM piwik_goal WHERE idsite IN (3) AND deleted = 0

Executed 402 times in 54.9ms (average = 0.1ms)

	SELECT * FROM piwik_goal WHERE idsite IN (4) AND deleted = 0

Executed 5 times in 6.8ms (average = 1.4ms)

	INSERT INTO piwik_log_visit (idvisitor, config_id, location_ip, visitor_localtime, location_country, config_device_type, config_device_model, config_os, config_os_version, visit_total_events, visitor_days_since_last, config_quicktime, config_pdf, config_realplayer, config_silverlight, config_windowsmedia, config_java, config_gears, config_resolution, location_provider, config_cookie, config_director, config_flash, config_device_brand, config_browser_version, 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, referer_url, location_browser_lang, config_browser_engine, config_browser_name, referer_type, referer_name, visit_total_actions, visit_total_searches, referer_keyword, idsite) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

Executed 36 times in 3.2ms (average = 0.1ms)

	SELECT * FROM piwik_goal WHERE idsite IN (1) AND deleted = 0

Executed 8 times in 0.8ms (average = 0.1ms)

	SELECT * FROM piwik_goal WHERE idsite IN (5) AND deleted = 0

DEBUG: array ( DEBUG: ) DEBUG: Time elapsed: 3.086s