DEBUG: Debug enabled - Input parameters: DEBUG: array ( DEBUG: 'idsite' => '2', DEBUG: ) DEBUG: Current datetime: 2024-04-27 08:53:34 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=dd957299d216b0b66a050a6560a315d6c6019b8dc03551244db09740e0d2cb95a107024cc1bd9708cc684b114b06507977ab0' > /home/piwikalitics/public_html/tmp/climulti/dd957299d216b0b66a050a6560a315d6c6019b8dc03551244db09740e0d2cb95a107024cc1bd9708cc684b114b06507977ab0.output 2>&1 & DEBUG: task,output DEBUG: Piwik\Plugins\CoreAdminHome\Tasks.purgeOutdatedArchives,Time elapsed: 0.068s DEBUG: Piwik\Plugins\ExamplePlugin\Tasks.myTask,Time elapsed: 0.000s DEBUG: Piwik\Plugins\UsersManager\Tasks.setUserDefaultReportPreference,Time elapsed: 0.003s DEBUG: Piwik\Plugins\CoreAdminHome\Tasks.purgeInvalidatedArchives,Time elapsed: 0.002s DEBUG: Piwik\Plugins\PrivacyManager\Tasks.deleteReportData,Time elapsed: 0.004s DEBUG: Piwik\Plugins\PrivacyManager\Tasks.deleteLogData,Time elapsed: 0.003s 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.028s 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: Finished Scheduled Tasks. DEBUG: Next run will be from: 2024-04-26 09:24:49 UTC DEBUG: Nothing to notice => default behaviour DEBUG: End of the page. DEBUG:

Breakdown by query
Executed 39705 times in 7230.1ms (average = 0.2ms)

	SELECT option_value FROM `piwik_option` WHERE option_name = ?

Executed 5029 times in 5943.6ms (average = 1.2ms)

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

Executed 4329 times in 2994ms (average = 0.7ms)

	connect

Executed 3632 times in 2952.4ms (average = 0.8ms)

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

Executed 1262 times in 2813.9ms (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 2625 times in 2250.5ms (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 3430 times in 1893.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 1716 times in 1541ms (average = 0.9ms)

	SHOW COLUMNS FROM `piwik_log_visit`

Executed 1716 times in 1350.2ms (average = 0.8ms)

	SHOW COLUMNS FROM `piwik_log_link_visit_action`

Executed 1716 times in 1144.4ms (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 2624 times in 959.2ms (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 3656 times in 387.4ms (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 2014 times in 239.5ms (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 2014 times in 204.8ms (average = 0.1ms)

	SELECT idsite, url FROM piwik_site_url

Executed 1828 times in 188ms (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 1828 times in 176.6ms (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 853 times in 108.4ms (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 401 times in 54.7ms (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: 1.874s