piwik.log

DEBUG Piwik\Plugin\Manager[2018-07-18 16:39:47 UTC] [31775] Loaded plugins: CorePluginsAdmin, CoreAdminHome, CoreHome, WebsiteMeasurable, Diagnostics, CoreVisualizations, Proxy, API, Widgetize, Transitions, LanguagesManager, Actions, Dashboard, MultiSites, Referrers, UserLanguage, DevicesDetection, Goals, Ecommerce, SEO, Events, UserCountry, VisitsSummary, VisitFrequency, VisitTime, VisitorInterest, ExampleAPI, RssWidget, Feedback, Monolog, Login, UsersManager, SitesManager, Installation, CoreUpdater, CoreConsole, ScheduledReports, UserCountryMap, Live, CustomVariables, PrivacyManager, ImageGraph, Annotations, MobileMessaging, Overlay, SegmentEditor, Insights, Morpheus, Contents, BulkTracking, Resolution, DevicePlugins, Heartbeat, Intl, Marketplace, ProfessionalServices, UserId, CustomPiwikJs, DBStats, Provider
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] /* trigger = CronArchive */
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] 
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] SELECT
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] count(distinct log_visit.idvisitor) AS `1`,
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] count(*) AS `2`,
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] sum(log_visit.visit_total_actions) AS `3`,
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] max(log_visit.visit_total_actions) AS `4`,
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] sum(log_visit.visit_total_time) AS `5`,
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`,
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7`,
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] count(distinct log_visit.user_id) AS `39`
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] FROM
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] piwik_log_visit AS log_visit
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] WHERE
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] log_visit.visit_last_action_time >= ?
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] AND log_visit.visit_last_action_time <= ?
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] AND log_visit.idsite IN (?)
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] PluginsArchiver::callAggregateAllPlugins: Initializing archiving process for all plugins [visits = 5400, visits converted = 2590]
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'Actions'.
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] /* trigger = CronArchive */
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] 
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] SELECT
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_action.name,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_action.type,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_action.idaction,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_action.url_prefix, count(distinct log_link_visit_action.idvisit) as `2`, count(distinct log_link_visit_action.idvisitor) as `1`, count(*) as `12`, sum(
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] case when custom_float is null
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] then 0
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] else custom_float
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] end
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] ) / 1000 as `30`, sum(
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] case when custom_float is null
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] then 0
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] else 1
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] end
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] ) as `31`, min(custom_float) / 1000 as `32`, max(custom_float) / 1000 as `33`
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] FROM
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] piwik_log_link_visit_action AS log_link_visit_action LEFT JOIN piwik_log_action AS log_action ON log_link_visit_action.%s = log_action.idaction
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] WHERE
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_link_visit_action.server_time >= ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_link_visit_action.server_time <= ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_link_visit_action.idsite = ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_link_visit_action.%s IS NOT NULL AND log_link_visit_action.idaction_event_category IS NULL
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] GROUP BY
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_link_visit_action.%s
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] ORDER BY
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] `12` DESC, name ASC
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] /* trigger = CronArchive */
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] 
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] SELECT
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_action.name,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_action.type,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_action.idaction,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_action.url_prefix, count(distinct log_link_visit_action.idvisit) as `2`, count(distinct log_link_visit_action.idvisitor) as `1`, count(*) as `12`, sum(
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] case when custom_float is null
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] then 0
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] else custom_float
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] end
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] ) / 1000 as `30`, sum(
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] case when custom_float is null
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] then 0
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] else 1
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] end
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] ) as `31`, min(custom_float) / 1000 as `32`, max(custom_float) / 1000 as `33`
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] FROM
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] piwik_log_link_visit_action AS log_link_visit_action LEFT JOIN piwik_log_action AS log_action ON log_link_visit_action.%s = log_action.idaction
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] WHERE
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_link_visit_action.server_time >= ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_link_visit_action.server_time <= ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_link_visit_action.idsite = ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_link_visit_action.%s IS NOT NULL AND log_link_visit_action.idaction_event_category IS NULL
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] GROUP BY
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_link_visit_action.%s
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] ORDER BY
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] `12` DESC, name ASC
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] /* trigger = CronArchive */
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] 
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] SELECT
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_visit.visit_entry_idaction_url as idaction, log_action.type, log_action.name,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] count(distinct log_visit.idvisitor) as `17`,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] count(*) as `19`,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] sum(log_visit.visit_total_actions) as `20`,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] sum(log_visit.visit_total_time) as `21`,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) as `22`
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] FROM
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] piwik_log_visit AS log_visit LEFT JOIN piwik_log_action AS log_action ON log_visit.%s = log_action.idaction
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] WHERE
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_visit.visit_last_action_time >= ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_visit.visit_last_action_time <= ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_visit.idsite = ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_visit.%s > 0
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] GROUP BY
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_visit.%s
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] ORDER BY
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] `20` DESC, log_action.name ASC
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] /* trigger = CronArchive */
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] 
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] SELECT
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_visit.visit_entry_idaction_name as idaction, log_action.type, log_action.name,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] count(distinct log_visit.idvisitor) as `17`,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] count(*) as `19`,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] sum(log_visit.visit_total_actions) as `20`,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] sum(log_visit.visit_total_time) as `21`,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) as `22`
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] FROM
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] piwik_log_visit AS log_visit LEFT JOIN piwik_log_action AS log_action ON log_visit.%s = log_action.idaction
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] WHERE
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_visit.visit_last_action_time >= ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_visit.visit_last_action_time <= ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_visit.idsite = ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_visit.%s > 0
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] GROUP BY
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_visit.%s
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] ORDER BY
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] `20` DESC, log_action.name ASC
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] /* trigger = CronArchive */
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] 
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] SELECT
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_visit.visit_exit_idaction_url as idaction, log_action.type, log_action.name,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] count(distinct log_visit.idvisitor) as `14`,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] count(*) as `15`
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] FROM
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] piwik_log_visit AS log_visit LEFT JOIN piwik_log_action AS log_action ON log_visit.%s = log_action.idaction
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] WHERE
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_visit.visit_last_action_time >= ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_visit.visit_last_action_time <= ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_visit.idsite = ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_visit.%s > 0
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] GROUP BY
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_visit.%s
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] ORDER BY
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] `15` DESC, log_action.name ASC
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] /* trigger = CronArchive */
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] 
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] SELECT
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_visit.visit_exit_idaction_name as idaction, log_action.type, log_action.name,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] count(distinct log_visit.idvisitor) as `14`,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] count(*) as `15`
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] FROM
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] piwik_log_visit AS log_visit LEFT JOIN piwik_log_action AS log_action ON log_visit.%s = log_action.idaction
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] WHERE
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_visit.visit_last_action_time >= ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_visit.visit_last_action_time <= ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_visit.idsite = ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_visit.%s > 0
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] GROUP BY
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_visit.%s
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] ORDER BY
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] `15` DESC, log_action.name ASC
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] /* trigger = CronArchive */
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] 
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] SELECT
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_link_visit_action.idaction_url_ref as idaction, log_action.type, log_action.name, count(*) as `12`,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] sum(log_link_visit_action.time_spent_ref_action) as `13`
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] FROM
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] piwik_log_link_visit_action AS log_link_visit_action LEFT JOIN piwik_log_action AS log_action ON log_link_visit_action.%s = log_action.idaction
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] WHERE
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_link_visit_action.server_time >= ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_link_visit_action.server_time <= ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_link_visit_action.idsite = ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_link_visit_action.time_spent_ref_action > 0
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_link_visit_action.%s > 0 AND log_link_visit_action.idaction_event_category IS NULL
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] GROUP BY
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_link_visit_action.%s
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] ORDER BY
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] `12` DESC, log_action.name ASC
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] /* trigger = CronArchive */
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] 
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] SELECT
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_link_visit_action.idaction_name_ref as idaction, log_action.type, log_action.name, count(*) as `12`,
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] sum(log_link_visit_action.time_spent_ref_action) as `13`
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] FROM
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] piwik_log_link_visit_action AS log_link_visit_action LEFT JOIN piwik_log_action AS log_action ON log_link_visit_action.%s = log_action.idaction
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] WHERE
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_link_visit_action.server_time >= ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_link_visit_action.server_time <= ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_link_visit_action.idsite = ?
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_link_visit_action.time_spent_ref_action > 0
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] AND log_link_visit_action.%s > 0 AND log_link_visit_action.idaction_event_category IS NULL
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] GROUP BY
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] log_link_visit_action.%s
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] ORDER BY
DEBUG Actions[2018-07-18 16:39:47 UTC] [31775] `12` DESC, log_action.name ASC
INFO Actions[2018-07-18 16:39:47 UTC] [31775] LOAD DATA INFILE failed... Error was:
INFO Actions[2018-07-18 16:39:47 UTC] [31775] Try #1: LOAD DATA INFILE : SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --secure-file-priv option so it cannot execute this statement,
INFO Actions[2018-07-18 16:39:47 UTC] [31775] Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]
INFO Actions[2018-07-18 16:39:47 UTC] [31775] LOAD DATA INFILE failed... Error was:
INFO Actions[2018-07-18 16:39:47 UTC] [31775] Try #1: LOAD DATA INFILE : SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --secure-file-priv option so it cannot execute this statement,
INFO Actions[2018-07-18 16:39:47 UTC] [31775] Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]
INFO Actions[2018-07-18 16:39:47 UTC] [31775] LOAD DATA INFILE failed... Error was:
INFO Actions[2018-07-18 16:39:47 UTC] [31775] Try #1: LOAD DATA INFILE : SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --secure-file-priv option so it cannot execute this statement,
INFO Actions[2018-07-18 16:39:47 UTC] [31775] Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] PluginsArchiver::callAggregateAllPlugins: Memory delta: 1.3 M while archiving day reports for plugin 'Actions' (for segment = '').
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'Referrers'.
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] /* trigger = CronArchive */
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] 
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] SELECT
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] log_visit.referer_type AS `referer_type`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] log_visit.referer_name AS `referer_name`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] log_visit.referer_keyword AS `referer_keyword`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] log_visit.referer_url AS `referer_url`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] count(distinct log_visit.idvisitor) AS `1`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] count(*) AS `2`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] sum(log_visit.visit_total_actions) AS `3`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] max(log_visit.visit_total_actions) AS `4`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] sum(log_visit.visit_total_time) AS `5`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] count(distinct log_visit.user_id) AS `39`
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] FROM
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] piwik_log_visit AS log_visit
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] WHERE
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] log_visit.visit_last_action_time >= ?
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] AND log_visit.visit_last_action_time <= ?
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] AND log_visit.idsite IN (?)
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] GROUP BY
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] log_visit.referer_type, log_visit.referer_name, log_visit.referer_keyword, log_visit.referer_url
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] /* trigger = CronArchive */
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] 
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] SELECT
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] log_conversion.idgoal AS `idgoal`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] log_conversion.referer_type AS `referer_type`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] log_conversion.referer_name AS `referer_name`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] log_conversion.referer_keyword AS `referer_keyword`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] count(*) AS `1`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] count(distinct log_conversion.idvisit) AS `3`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] ROUND(SUM(log_conversion.revenue),2) AS `2`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] ROUND(SUM(log_conversion.revenue_subtotal),2) AS `4`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] ROUND(SUM(log_conversion.revenue_tax),2) AS `5`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] ROUND(SUM(log_conversion.revenue_shipping),2) AS `6`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] ROUND(SUM(log_conversion.revenue_discount),2) AS `7`,
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] SUM(log_conversion.items) AS `8`
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] FROM
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] piwik_log_conversion AS log_conversion
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] WHERE
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] log_conversion.server_time >= ?
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] AND log_conversion.server_time <= ?
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] AND log_conversion.idsite IN (?)
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] GROUP BY
DEBUG Referrers[2018-07-18 16:39:47 UTC] [31775] log_conversion.idgoal, log_conversion.referer_type, log_conversion.referer_name, log_conversion.referer_keyword
INFO Referrers[2018-07-18 16:39:47 UTC] [31775] LOAD DATA INFILE failed... Error was:
INFO Referrers[2018-07-18 16:39:47 UTC] [31775] Try #1: LOAD DATA INFILE : SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --secure-file-priv option so it cannot execute this statement,
INFO Referrers[2018-07-18 16:39:47 UTC] [31775] Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]
INFO Referrers[2018-07-18 16:39:47 UTC] [31775] LOAD DATA INFILE failed... Error was:
INFO Referrers[2018-07-18 16:39:47 UTC] [31775] Try #1: LOAD DATA INFILE : SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --secure-file-priv option so it cannot execute this statement,
INFO Referrers[2018-07-18 16:39:47 UTC] [31775] Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]
INFO Referrers[2018-07-18 16:39:47 UTC] [31775] LOAD DATA INFILE failed... Error was:
INFO Referrers[2018-07-18 16:39:47 UTC] [31775] Try #1: LOAD DATA INFILE : SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --secure-file-priv option so it cannot execute this statement,
INFO Referrers[2018-07-18 16:39:47 UTC] [31775] Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]
INFO Referrers[2018-07-18 16:39:47 UTC] [31775] LOAD DATA INFILE failed... Error was:
INFO Referrers[2018-07-18 16:39:47 UTC] [31775] Try #1: LOAD DATA INFILE : SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --secure-file-priv option so it cannot execute this statement,
INFO Referrers[2018-07-18 16:39:47 UTC] [31775] Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] PluginsArchiver::callAggregateAllPlugins: Memory delta: 2.5 M while archiving day reports for plugin 'Referrers' (for segment = '').
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'UserLanguage'.
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] /* trigger = CronArchive */
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] 
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] SELECT
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] log_visit.location_browser_lang AS `label`,
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] count(distinct log_visit.idvisitor) AS `1`,
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] count(*) AS `2`,
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] sum(log_visit.visit_total_actions) AS `3`,
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] max(log_visit.visit_total_actions) AS `4`,
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] sum(log_visit.visit_total_time) AS `5`,
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`,
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7`,
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] count(distinct log_visit.user_id) AS `39`
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] FROM
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] piwik_log_visit AS log_visit
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] WHERE
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] log_visit.visit_last_action_time >= ?
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] AND log_visit.visit_last_action_time <= ?
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] AND log_visit.idsite IN (?)
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] GROUP BY
DEBUG UserLanguage[2018-07-18 16:39:47 UTC] [31775] log_visit.location_browser_lang
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] PluginsArchiver::callAggregateAllPlugins: Memory delta: 341.7 K while archiving day reports for plugin 'UserLanguage' (for segment = '').
DEBUG VisitsSummary[2018-07-18 16:39:47 UTC] [31775] PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'DevicesDetection'.
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] /* trigger = CronArchive */
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] 
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] SELECT
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] log_visit.config_device_type AS `label`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] count(distinct log_visit.idvisitor) AS `1`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] count(*) AS `2`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] sum(log_visit.visit_total_actions) AS `3`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] max(log_visit.visit_total_actions) AS `4`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] sum(log_visit.visit_total_time) AS `5`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] count(distinct log_visit.user_id) AS `39`
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] FROM
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] piwik_log_visit AS log_visit
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] WHERE
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] log_visit.visit_last_action_time >= ?
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] AND log_visit.visit_last_action_time <= ?
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] AND log_visit.idsite IN (?)
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] GROUP BY
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] config_device_type
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] /* trigger = CronArchive */
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] 
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] SELECT
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] log_conversion.idgoal AS `idgoal`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] log_conversion.config_device_type AS `config_device_type`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] count(*) AS `1`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] count(distinct log_conversion.idvisit) AS `3`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] ROUND(SUM(log_conversion.revenue),2) AS `2`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] ROUND(SUM(log_conversion.revenue_subtotal),2) AS `4`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] ROUND(SUM(log_conversion.revenue_tax),2) AS `5`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] ROUND(SUM(log_conversion.revenue_shipping),2) AS `6`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] ROUND(SUM(log_conversion.revenue_discount),2) AS `7`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] SUM(log_conversion.items) AS `8`
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] FROM
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] piwik_log_conversion AS log_conversion
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] WHERE
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] log_conversion.server_time >= ?
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] AND log_conversion.server_time <= ?
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] AND log_conversion.idsite IN (?)
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] GROUP BY
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] log_conversion.idgoal, log_conversion.config_device_type
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] /* trigger = CronArchive */
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] 
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] SELECT
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] log_visit.config_device_brand AS `label`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] count(distinct log_visit.idvisitor) AS `1`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] count(*) AS `2`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] sum(log_visit.visit_total_actions) AS `3`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] max(log_visit.visit_total_actions) AS `4`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] sum(log_visit.visit_total_time) AS `5`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] count(distinct log_visit.user_id) AS `39`
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] FROM
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] piwik_log_visit AS log_visit
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] WHERE
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] log_visit.visit_last_action_time >= ?
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] AND log_visit.visit_last_action_time <= ?
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] AND log_visit.idsite IN (?)
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] GROUP BY
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] config_device_brand
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] /* trigger = CronArchive */
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] 
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] SELECT
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] log_conversion.idgoal AS `idgoal`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] log_conversion.config_device_brand AS `config_device_brand`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] count(*) AS `1`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] count(distinct log_conversion.idvisit) AS `3`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] ROUND(SUM(log_conversion.revenue),2) AS `2`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] ROUND(SUM(log_conversion.revenue_subtotal),2) AS `4`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] ROUND(SUM(log_conversion.revenue_tax),2) AS `5`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] ROUND(SUM(log_conversion.revenue_shipping),2) AS `6`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] ROUND(SUM(log_conversion.revenue_discount),2) AS `7`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] SUM(log_conversion.items) AS `8`
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] FROM
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] piwik_log_conversion AS log_conversion
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] WHERE
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] log_conversion.server_time >= ?
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] AND log_conversion.server_time <= ?
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] AND log_conversion.idsite IN (?)
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] GROUP BY
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] log_conversion.idgoal, log_conversion.config_device_brand
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] /* trigger = CronArchive */
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] 
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] SELECT
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] CONCAT(log_visit.config_device_brand, ';', log_visit.config_device_model) AS `label`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] count(distinct log_visit.idvisitor) AS `1`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] count(*) AS `2`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] sum(log_visit.visit_total_actions) AS `3`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] max(log_visit.visit_total_actions) AS `4`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] sum(log_visit.visit_total_time) AS `5`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7`,
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] count(distinct log_visit.user_id) AS `39`
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] FROM
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] piwik_log_visit AS log_visit
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] WHERE
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] log_visit.visit_last_action_time >= ?
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] AND log_visit.visit_last_action_time <= ?
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] AND log_visit.idsite IN (?)
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] GROUP BY
DEBUG DevicesDetection[2018-07-18 16:39:47 UTC] [31775] CONCAT(log_visit.config_device_brand, ';', log_visit.config_device_model)
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] /* trigger = CronArchive */
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] 
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] SELECT
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] log_conversion.idgoal AS `idgoal`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] CONCAT(log_conversion.config_device_brand, ';', log_conversion.config_device_model),
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] count(*) AS `1`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] count(distinct log_conversion.idvisit) AS `3`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] ROUND(SUM(log_conversion.revenue),2) AS `2`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] ROUND(SUM(log_conversion.revenue_subtotal),2) AS `4`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] ROUND(SUM(log_conversion.revenue_tax),2) AS `5`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] ROUND(SUM(log_conversion.revenue_shipping),2) AS `6`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] ROUND(SUM(log_conversion.revenue_discount),2) AS `7`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] SUM(log_conversion.items) AS `8`
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] FROM
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] piwik_log_conversion AS log_conversion
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] WHERE
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] log_conversion.server_time >= ?
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] AND log_conversion.server_time <= ?
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] AND log_conversion.idsite IN (?)
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] GROUP BY
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] log_conversion.idgoal, CONCAT(log_conversion.config_device_brand, ';', log_conversion.config_device_model)
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] /* trigger = CronArchive */
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] 
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] SELECT
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] log_visit.config_os AS `label`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] count(distinct log_visit.idvisitor) AS `1`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] count(*) AS `2`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(log_visit.visit_total_actions) AS `3`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] max(log_visit.visit_total_actions) AS `4`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(log_visit.visit_total_time) AS `5`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] count(distinct log_visit.user_id) AS `39`
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] FROM
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] piwik_log_visit AS log_visit
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] WHERE
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] log_visit.visit_last_action_time >= ?
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] AND log_visit.visit_last_action_time <= ?
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] AND log_visit.idsite IN (?)
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] GROUP BY
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] config_os
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] /* trigger = CronArchive */
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] 
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] SELECT
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] CONCAT(log_visit.config_os, ';', COALESCE(log_visit.config_os_version, '')) AS `label`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] count(distinct log_visit.idvisitor) AS `1`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] count(*) AS `2`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(log_visit.visit_total_actions) AS `3`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] max(log_visit.visit_total_actions) AS `4`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(log_visit.visit_total_time) AS `5`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] count(distinct log_visit.user_id) AS `39`
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] FROM
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] piwik_log_visit AS log_visit
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] WHERE
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] log_visit.visit_last_action_time >= ?
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] AND log_visit.visit_last_action_time <= ?
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] AND log_visit.idsite IN (?)
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] GROUP BY
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] CONCAT(log_visit.config_os, ';', COALESCE(log_visit.config_os_version, ''))
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] /* trigger = CronArchive */
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] 
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] SELECT
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] log_visit.config_browser_name AS `label`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] count(distinct log_visit.idvisitor) AS `1`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] count(*) AS `2`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(log_visit.visit_total_actions) AS `3`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] max(log_visit.visit_total_actions) AS `4`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(log_visit.visit_total_time) AS `5`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] count(distinct log_visit.user_id) AS `39`
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] FROM
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] piwik_log_visit AS log_visit
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] WHERE
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] log_visit.visit_last_action_time >= ?
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] AND log_visit.visit_last_action_time <= ?
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] AND log_visit.idsite IN (?)
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] GROUP BY
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] config_browser_name
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] /* trigger = CronArchive */
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] 
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] SELECT
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] log_visit.config_browser_engine AS `label`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] count(distinct log_visit.idvisitor) AS `1`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] count(*) AS `2`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(log_visit.visit_total_actions) AS `3`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] max(log_visit.visit_total_actions) AS `4`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(log_visit.visit_total_time) AS `5`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] count(distinct log_visit.user_id) AS `39`
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] FROM
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] piwik_log_visit AS log_visit
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] WHERE
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] log_visit.visit_last_action_time >= ?
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] AND log_visit.visit_last_action_time <= ?
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] AND log_visit.idsite IN (?)
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] GROUP BY
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] config_browser_engine
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] /* trigger = CronArchive */
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] 
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] SELECT
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] CONCAT(log_visit.config_browser_name, ';', log_visit.config_browser_version) AS `label`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] count(distinct log_visit.idvisitor) AS `1`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] count(*) AS `2`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(log_visit.visit_total_actions) AS `3`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] max(log_visit.visit_total_actions) AS `4`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(log_visit.visit_total_time) AS `5`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7`,
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] count(distinct log_visit.user_id) AS `39`
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] FROM
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] piwik_log_visit AS log_visit
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] WHERE
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] log_visit.visit_last_action_time >= ?
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] AND log_visit.visit_last_action_time <= ?
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] AND log_visit.idsite IN (?)
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] GROUP BY
DEBUG DevicesDetection[2018-07-18 16:39:48 UTC] [31775] CONCAT(log_visit.config_browser_name, ';', log_visit.config_browser_version)
DEBUG VisitsSummary[2018-07-18 16:39:48 UTC] [31775] PluginsArchiver::callAggregateAllPlugins: Memory delta: 95.5 K while archiving day reports for plugin 'DevicesDetection' (for segment = '').
DEBUG VisitsSummary[2018-07-18 16:39:48 UTC] [31775] PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'Goals'.
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] /* trigger = CronArchive */
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] 
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] SELECT
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] log_conversion.idgoal AS `idgoal`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] count(*) AS `1`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] count(distinct log_conversion.idvisit) AS `3`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] ROUND(SUM(log_conversion.revenue),2) AS `2`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] ROUND(SUM(log_conversion.revenue_subtotal),2) AS `4`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] ROUND(SUM(log_conversion.revenue_tax),2) AS `5`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] ROUND(SUM(log_conversion.revenue_shipping),2) AS `6`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] ROUND(SUM(log_conversion.revenue_discount),2) AS `7`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] SUM(log_conversion.items) AS `8`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_count_visits between 1 and 1  then 1 else 0 end) as `vcv1-1`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_count_visits between 2 and 2  then 1 else 0 end) as `vcv2-2`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_count_visits between 3 and 3  then 1 else 0 end) as `vcv3-3`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_count_visits between 4 and 4  then 1 else 0 end) as `vcv4-4`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_count_visits between 5 and 5  then 1 else 0 end) as `vcv5-5`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_count_visits between 6 and 6  then 1 else 0 end) as `vcv6-6`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_count_visits between 7 and 7  then 1 else 0 end) as `vcv7-7`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_count_visits between 8 and 8  then 1 else 0 end) as `vcv8-8`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_count_visits between 9 and 14  then 1 else 0 end) as `vcv9-14`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_count_visits between 15 and 25  then 1 else 0 end) as `vcv15-25`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_count_visits between 26 and 50  then 1 else 0 end) as `vcv26-50`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_count_visits between 51 and 100  then 1 else 0 end) as `vcv51-100`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_count_visits > 100  then 1 else 0 end) as `vcv101%2B`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_days_since_first between 0 and 0  then 1 else 0 end) as `vdsf0-0`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_days_since_first between 1 and 1  then 1 else 0 end) as `vdsf1-1`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_days_since_first between 2 and 2  then 1 else 0 end) as `vdsf2-2`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_days_since_first between 3 and 3  then 1 else 0 end) as `vdsf3-3`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_days_since_first between 4 and 4  then 1 else 0 end) as `vdsf4-4`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_days_since_first between 5 and 5  then 1 else 0 end) as `vdsf5-5`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_days_since_first between 6 and 6  then 1 else 0 end) as `vdsf6-6`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_days_since_first between 7 and 7  then 1 else 0 end) as `vdsf7-7`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_days_since_first between 8 and 14  then 1 else 0 end) as `vdsf8-14`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_days_since_first between 15 and 30  then 1 else 0 end) as `vdsf15-30`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_days_since_first between 31 and 60  then 1 else 0 end) as `vdsf31-60`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_days_since_first between 61 and 120  then 1 else 0 end) as `vdsf61-120`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_days_since_first between 121 and 364  then 1 else 0 end) as `vdsf121-364`,
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] sum(case when log_conversion.visitor_days_since_first > 364  then 1 else 0 end) as `vdsf365%2B`
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] FROM
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] piwik_log_conversion AS log_conversion
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] WHERE
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] log_conversion.server_time >= ?
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] AND log_conversion.server_time <= ?
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] AND log_conversion.idsite IN (?)
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] GROUP BY
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] log_conversion.idgoal
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] /* trigger = CronArchive */
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] 
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] SELECT
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] log_action.name AS label, log_conversion_item.idaction_sku AS labelIdAction, ROUND(SUM(log_conversion_item.quantity * log_conversion_item.price),2) AS `23`, ROUND(SUM(log_conversion_item.quantity),2) AS `24`, ROUND(SUM(log_conversion_item.price),2) AS `25`, COUNT(distinct log_conversion_item.idorder) AS `26`, COUNT(distinct log_conversion_item.idvisit) AS `2`, CASE log_conversion_item.idorder WHEN '0' THEN -1 ELSE 0 END AS ecommerceType
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] FROM
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] piwik_log_conversion_item AS log_conversion_item LEFT JOIN piwik_log_action AS log_action ON log_conversion_item.idaction_sku = log_action.idaction
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] WHERE
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] log_conversion_item.server_time >= ? AND log_conversion_item.server_time <= ? AND log_conversion_item.idsite IN (?) AND log_conversion_item.deleted = 0
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] GROUP BY
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] ecommerceType, log_conversion_item.idaction_sku
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] /* trigger = CronArchive */
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] 
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] SELECT
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] log_action.name AS label, log_conversion_item.idaction_name AS labelIdAction, ROUND(SUM(log_conversion_item.quantity * log_conversion_item.price),2) AS `23`, ROUND(SUM(log_conversion_item.quantity),2) AS `24`, ROUND(SUM(log_conversion_item.price),2) AS `25`, COUNT(distinct log_conversion_item.idorder) AS `26`, COUNT(distinct log_conversion_item.idvisit) AS `2`, CASE log_conversion_item.idorder WHEN '0' THEN -1 ELSE 0 END AS ecommerceType
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] FROM
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] piwik_log_conversion_item AS log_conversion_item LEFT JOIN piwik_log_action AS log_action ON log_conversion_item.idaction_name = log_action.idaction
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] WHERE
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] log_conversion_item.server_time >= ? AND log_conversion_item.server_time <= ? AND log_conversion_item.idsite IN (?) AND log_conversion_item.deleted = 0
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] GROUP BY
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] ecommerceType, log_conversion_item.idaction_name
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] /* trigger = CronArchive */
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] 
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] SELECT
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] log_action.name AS label, log_conversion_item.idaction_category AS labelIdAction, ROUND(SUM(log_conversion_item.quantity * log_conversion_item.price),2) AS `23`, ROUND(SUM(log_conversion_item.quantity),2) AS `24`, ROUND(SUM(log_conversion_item.price),2) AS `25`, COUNT(distinct log_conversion_item.idorder) AS `26`, COUNT(distinct log_conversion_item.idvisit) AS `2`, CASE log_conversion_item.idorder WHEN '0' THEN -1 ELSE 0 END AS ecommerceType
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] FROM
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] piwik_log_conversion_item AS log_conversion_item LEFT JOIN piwik_log_action AS log_action ON log_conversion_item.idaction_category = log_action.idaction
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] WHERE
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] log_conversion_item.server_time >= ? AND log_conversion_item.server_time <= ? AND log_conversion_item.idsite IN (?) AND log_conversion_item.deleted = 0
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] GROUP BY
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] ecommerceType, log_conversion_item.idaction_category
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] /* trigger = CronArchive */
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] 
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] SELECT
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] log_action.name AS label, log_conversion_item.idaction_category2 AS labelIdAction, ROUND(SUM(log_conversion_item.quantity * log_conversion_item.price),2) AS `23`, ROUND(SUM(log_conversion_item.quantity),2) AS `24`, ROUND(SUM(log_conversion_item.price),2) AS `25`, COUNT(distinct log_conversion_item.idorder) AS `26`, COUNT(distinct log_conversion_item.idvisit) AS `2`, CASE log_conversion_item.idorder WHEN '0' THEN -1 ELSE 0 END AS ecommerceType
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] FROM
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] piwik_log_conversion_item AS log_conversion_item LEFT JOIN piwik_log_action AS log_action ON log_conversion_item.idaction_category2 = log_action.idaction
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] WHERE
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] log_conversion_item.server_time >= ? AND log_conversion_item.server_time <= ? AND log_conversion_item.idsite IN (?) AND log_conversion_item.deleted = 0
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] GROUP BY
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] ecommerceType, log_conversion_item.idaction_category2
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] /* trigger = CronArchive */
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] 
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] SELECT
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] log_action.name AS label, log_conversion_item.idaction_category3 AS labelIdAction, ROUND(SUM(log_conversion_item.quantity * log_conversion_item.price),2) AS `23`, ROUND(SUM(log_conversion_item.quantity),2) AS `24`, ROUND(SUM(log_conversion_item.price),2) AS `25`, COUNT(distinct log_conversion_item.idorder) AS `26`, COUNT(distinct log_conversion_item.idvisit) AS `2`, CASE log_conversion_item.idorder WHEN '0' THEN -1 ELSE 0 END AS ecommerceType
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] FROM
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] piwik_log_conversion_item AS log_conversion_item LEFT JOIN piwik_log_action AS log_action ON log_conversion_item.idaction_category3 = log_action.idaction
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] WHERE
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] log_conversion_item.server_time >= ? AND log_conversion_item.server_time <= ? AND log_conversion_item.idsite IN (?) AND log_conversion_item.deleted = 0
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] GROUP BY
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] ecommerceType, log_conversion_item.idaction_category3
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] /* trigger = CronArchive */
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] 
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] SELECT
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] log_action.name AS label, log_conversion_item.idaction_category4 AS labelIdAction, ROUND(SUM(log_conversion_item.quantity * log_conversion_item.price),2) AS `23`, ROUND(SUM(log_conversion_item.quantity),2) AS `24`, ROUND(SUM(log_conversion_item.price),2) AS `25`, COUNT(distinct log_conversion_item.idorder) AS `26`, COUNT(distinct log_conversion_item.idvisit) AS `2`, CASE log_conversion_item.idorder WHEN '0' THEN -1 ELSE 0 END AS ecommerceType
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] FROM
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] piwik_log_conversion_item AS log_conversion_item LEFT JOIN piwik_log_action AS log_action ON log_conversion_item.idaction_category4 = log_action.idaction
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] WHERE
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] log_conversion_item.server_time >= ? AND log_conversion_item.server_time <= ? AND log_conversion_item.idsite IN (?) AND log_conversion_item.deleted = 0
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] GROUP BY
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] ecommerceType, log_conversion_item.idaction_category4
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] /* trigger = CronArchive */
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] 
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] SELECT
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] log_action.name AS label, log_conversion_item.idaction_category5 AS labelIdAction, ROUND(SUM(log_conversion_item.quantity * log_conversion_item.price),2) AS `23`, ROUND(SUM(log_conversion_item.quantity),2) AS `24`, ROUND(SUM(log_conversion_item.price),2) AS `25`, COUNT(distinct log_conversion_item.idorder) AS `26`, COUNT(distinct log_conversion_item.idvisit) AS `2`, CASE log_conversion_item.idorder WHEN '0' THEN -1 ELSE 0 END AS ecommerceType
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] FROM
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] piwik_log_conversion_item AS log_conversion_item LEFT JOIN piwik_log_action AS log_action ON log_conversion_item.idaction_category5 = log_action.idaction
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] WHERE
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] log_conversion_item.server_time >= ? AND log_conversion_item.server_time <= ? AND log_conversion_item.idsite IN (?) AND log_conversion_item.deleted = 0
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] GROUP BY
DEBUG Goals[2018-07-18 16:39:48 UTC] [31775] ecommerceType, log_conversion_item.idaction_category5
DEBUG VisitsSummary[2018-07-18 16:39:48 UTC] [31775] PluginsArchiver::callAggregateAllPlugins: Memory delta: 164.7 K while archiving day reports for plugin 'Goals' (for segment = '').
DEBUG VisitsSummary[2018-07-18 16:39:48 UTC] [31775] PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'Events'.
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] /* trigger = CronArchive */
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] 
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] SELECT
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] 
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] log_action_event_category.name as eventCategory,
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] log_action_event_action.name as eventAction,
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] log_action_event_name.name as eventName,
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] 
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] count(distinct log_link_visit_action.idvisit) as `2`,
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] count(distinct log_link_visit_action.idvisitor) as `1`,
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] count(*) as `34`,
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] 
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] sum(
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] case when custom_float is null
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] then 0
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] else custom_float
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] end
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] ) as `35`,
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] sum( case when custom_float is null then 0 else 1 end )
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] as `38`,
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] min(custom_float) as `36`,
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] max(custom_float) as `37`
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] 
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] FROM
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] piwik_log_link_visit_action AS log_link_visit_action LEFT JOIN piwik_log_action AS log_action_event_category ON log_link_visit_action.idaction_event_category = log_action_event_category.idaction LEFT JOIN piwik_log_action AS log_action_event_action ON log_link_visit_action.idaction_event_action = log_action_event_action.idaction LEFT JOIN piwik_log_action AS log_action_event_name ON log_link_visit_action.idaction_name = log_action_event_name.idaction
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] WHERE
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] log_link_visit_action.server_time >= ?
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] AND log_link_visit_action.server_time <= ?
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] AND log_link_visit_action.idsite = ?
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] AND log_link_visit_action.idaction_event_category IS NOT NULL
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] GROUP BY
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] log_link_visit_action.idaction_event_category,
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] log_link_visit_action.idaction_event_action,
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] log_link_visit_action.idaction_name
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] ORDER BY
DEBUG Events[2018-07-18 16:39:48 UTC] [31775] `2` DESC
DEBUG VisitsSummary[2018-07-18 16:39:48 UTC] [31775] PluginsArchiver::callAggregateAllPlugins: Memory delta: 15.1 K while archiving day reports for plugin 'Events' (for segment = '').
DEBUG VisitsSummary[2018-07-18 16:39:48 UTC] [31775] PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'UserCountry'.
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] /* trigger = CronArchive */
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] 
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] SELECT
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] log_visit.location_country AS `location_country`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] log_visit.location_region AS `location_region`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] log_visit.location_city AS `location_city`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] count(distinct log_visit.idvisitor) AS `1`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] count(*) AS `2`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] sum(log_visit.visit_total_actions) AS `3`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] max(log_visit.visit_total_actions) AS `4`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] sum(log_visit.visit_total_time) AS `5`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] count(distinct log_visit.user_id) AS `39`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] MAX(log_visit.location_latitude) as location_latitude,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] MAX(log_visit.location_longitude) as location_longitude
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] FROM
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] piwik_log_visit AS log_visit
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] WHERE
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] log_visit.visit_last_action_time >= ?
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] AND log_visit.visit_last_action_time <= ?
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] AND log_visit.idsite IN (?)
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] GROUP BY
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] log_visit.location_country, log_visit.location_region, log_visit.location_city
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] /* trigger = CronArchive */
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] 
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] SELECT
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] log_conversion.idgoal AS `idgoal`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] log_conversion.location_country AS `location_country`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] log_conversion.location_region AS `location_region`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] log_conversion.location_city AS `location_city`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] count(*) AS `1`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] count(distinct log_conversion.idvisit) AS `3`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] ROUND(SUM(log_conversion.revenue),2) AS `2`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] ROUND(SUM(log_conversion.revenue_subtotal),2) AS `4`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] ROUND(SUM(log_conversion.revenue_tax),2) AS `5`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] ROUND(SUM(log_conversion.revenue_shipping),2) AS `6`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] ROUND(SUM(log_conversion.revenue_discount),2) AS `7`,
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] SUM(log_conversion.items) AS `8`
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] FROM
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] piwik_log_conversion AS log_conversion
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] WHERE
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] log_conversion.server_time >= ?
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] AND log_conversion.server_time <= ?
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] AND log_conversion.idsite IN (?)
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] GROUP BY
DEBUG UserCountry[2018-07-18 16:39:48 UTC] [31775] log_conversion.idgoal, log_conversion.location_country, log_conversion.location_region, log_conversion.location_city
DEBUG Piwik\Plugin\Manager[2018-07-18 16:39:55 UTC] [07930] Loaded plugins: CorePluginsAdmin, CoreAdminHome, CoreHome, WebsiteMeasurable, Diagnostics, CoreVisualizations, Proxy, API, Widgetize, Transitions, LanguagesManager, Actions, Dashboard, MultiSites, Referrers, UserLanguage, DevicesDetection, Goals, Ecommerce, SEO, Events, UserCountry, VisitsSummary, VisitFrequency, VisitTime, VisitorInterest, ExampleAPI, RssWidget, Feedback, Monolog, Login, UsersManager, SitesManager, Installation, CoreUpdater, CoreConsole, ScheduledReports, UserCountryMap, Live, CustomVariables, PrivacyManager, ImageGraph, Annotations, MobileMessaging, Overlay, SegmentEditor, Insights, Morpheus, Contents, BulkTracking, Resolution, DevicePlugins, Heartbeat, Intl, Marketplace, ProfessionalServices, UserId, CustomPiwikJs, DBStats, Provider