DEBUG: Debug enabled - Input parameters: DEBUG: array ( DEBUG: 'idsite' => '4', DEBUG: ) DEBUG: Current datetime: 2025-07-14 21:20:59 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=b0bc865b3b0456cace4a7e565cfb8bb83fabe0b54e86b758f401fd527d819bd20080c85d087eec71655362ab707ed1bd49ac0' > /home/piwikalitics/public_html/tmp/climulti/b0bc865b3b0456cace4a7e565cfb8bb83fabe0b54e86b758f401fd527d819bd20080c85d087eec71655362ab707ed1bd49ac0.output 2>&1 & DEBUG: task,output DEBUG: Piwik\Plugins\ExamplePlugin\Tasks.myTask,Time elapsed: 0.000s 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: Finished Scheduled Tasks. DEBUG: Next run will be from: 2025-07-14 16:35:01 UTC DEBUG: Nothing to notice => default behaviour DEBUG: End of the page. DEBUG:
SELECT option_value FROM `piwik_option` WHERE option_name = ?Executed 5464 times in 6471.1ms (average = 1.2ms)
INSERT INTO `piwik_option` (option_name, option_value, autoload) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE option_value = ?Executed 4019 times in 3437.1ms (average = 0.9ms)
SELECT option_value, option_name FROM `piwik_option` WHERE autoload = 1Executed 1538 times in 3382.6ms (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 4728 times in 3349.6ms (average = 0.7ms)
connectExecuted 2917 times in 2505.9ms (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 3999 times in 2232.4ms (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 1Executed 1987 times in 1782.4ms (average = 0.9ms)
SHOW COLUMNS FROM `piwik_log_visit`Executed 1987 times in 1570ms (average = 0.8ms)
SHOW COLUMNS FROM `piwik_log_link_visit_action`Executed 1987 times in 1336.7ms (average = 0.7ms)
SHOW COLUMNS FROM `piwik_log_conversion`Executed 2916 times in 1032.1ms (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, nameExecuted 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 404 times in 739ms (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 1Executed 361 times in 491.6ms (average = 1.4ms)
SHOW COLUMNS FROM . piwik_log_visitExecuted 4198 times in 471.4ms (average = 0.1ms)
SELECT * FROM piwik_site WHERE idsite = ?Executed 231 times in 384.1ms (average = 1.7ms)
INSERT INTO piwik_log_action (name, hash, type, url_prefix) VALUES (?,CRC32(?),?,?)Executed 2383 times in 290.7ms (average = 0.1ms)
SELECT idsite, main_url as url FROM piwik_siteExecuted 361 times in 277.1ms (average = 0.8ms)
SHOW COLUMNS FROM . piwik_log_conversionExecuted 2521 times in 249.5ms (average = 0.1ms)
SELECT idsite FROM piwik_siteExecuted 2383 times in 249ms (average = 0.1ms)
SELECT idsite, url FROM piwik_site_urlExecuted 361 times in 233.5ms (average = 0.6ms)
SHOW COLUMNS FROM . piwik_log_link_visit_actionExecuted 2099 times in 227ms (average = 0.1ms)
SELECT login FROM piwik_access WHERE idsite = ? AND access = ?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 2099 times in 212.4ms (average = 0.1ms)
SELECT url FROM piwik_site_url WHERE idsite = ?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 ASCExecuted 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 892 times in 114.2ms (average = 0.1ms)
SELECT * FROM piwik_goal WHERE idsite IN (2) AND deleted = 0Executed 633 times in 99.1ms (average = 0.2ms)
SELECT * FROM piwik_goal WHERE idsite IN (4) AND deleted = 0Executed 231 times in 60.4ms (average = 0.3ms)
SELECT idaction, type, name FROM piwik_log_action WHERE ( hash = CRC32(?) AND name = ? AND type = ? ) ORDER BY idaction ASC LIMIT 1Executed 530 times in 59.4ms (average = 0.1ms)
SELECT * FROM piwik_goal WHERE idsite IN (3) AND deleted = 0Executed 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 = 0Executed 8 times in 0.8ms (average = 0.1ms)
SELECT * FROM piwik_goal WHERE idsite IN (5) AND deleted = 0DEBUG: array ( DEBUG: ) DEBUG: Time elapsed: 0.459s