-----<hr>
(mysqli): SELECT `value` FROM `systemVars` WHERE `var`='ServerLoadLimits_idle' 
   
-----<hr>
-----<hr>
(mysqli): UPDATE `cronJobs` SET `isQueued`=0, `lastUpdateTime`='2021-06-28 15:09:43', `idUpdateUser`=0, `updatesCount`=updatesCount+1 WHERE `id`='ReportsDataPopulate' 
   
-----<hr>
-----<hr>
(mysqli): SELECT * FROM `cronJobs` WHERE `id`='ReportsDataPopulate' 
   
-----<hr>
-----<hr>
(mysqli): UPDATE `cronJobs` SET `status`='a:7:{s:8:\"progress\";d:0;s:12:\"progressStep\";i:0;s:13:\"progressSteps\";i:1;s:11:\"currentStep\";s:0:\"\";s:3:\"pid\";i:1033130;s:10:\"instanceId\";s:29:\"0.325.398-ReportsDataPopulate\";s:9:\"startDate\";d:1624903783.325239;}', `lastUpdateTime`='2021-06-28 15:09:43', `idUpdateUser`=0, `updatesCount`=updatesCount+1 WHERE `id`='ReportsDataPopulate' 
   
-----<hr>

<div class='type-info' data-microtime='1624903783.3326' data-memory='14680064'><span class='time'>2021-06-28 15:09:43.332647</span><span class='memory'>14.0Mb</span><span class='type'>info</span><span class='msg'>Cronjob execution started. PID: 1033130</span></div>-----<hr>
(mysqli): SET SESSION wait_timeout=28800 
   
-----<hr>
-----<hr>
(mysqli): SELECT `value` FROM `rdParams` WHERE `var`='status' 
   
-----<hr>
-----<hr>
(mysqli): SELECT `value` FROM `rdParams` WHERE `var`='blockedUntil' 
   
-----<hr>
-----<hr>
(mysqli): SELECT `value` FROM `rdParams` WHERE `var`='status' 
   
-----<hr>
-----<hr>
(mysqli): SELECT `value` FROM `rdParams` WHERE `var`='blockedUntil' 
   
-----<hr>
-----<hr>
(mysqli): REPLACE `rdParams` SET `var`='status', `value`='running', `lastUpdate`='2021-06-28 15:09:43' 
   
-----<hr>
-----<hr>
(mysqli): START TRANSACTION 
   
-----<hr>
-----<hr>
(mysqli): SELECT entity, id FROM `rdQueueFast` FOR UPDATE 
   
-----<hr>
-----<hr>
(mysqli): INSERT IGNORE INTO `rdQueueMain` (`entity`, `id`, `addTime`) SELECT `entity`, `id`, `addTime` FROM `rdQueueFast` 
   
-----<hr>
-----<hr>
(mysqli): TRUNCATE TABLE `rdQueueFast` 
   
-----<hr>
-----<hr>
(mysqli): COMMIT 
   
-----<hr>
-----<hr>
(mysqli): SELECT COUNT(*) FROM `rdQueueMain` 
   
-----<hr>

<div class='type-info' data-microtime='1624903783.4131' data-memory='14680064'><span class='time'>2021-06-28 15:09:43.413058</span><span class='memory'>14.0Mb</span><span class='type'>info</span><span class='msg'>There are 1 records in the RD queue.</span></div>-----<hr>
(mysqli): SELECT `value` FROM `rdParams` WHERE `var`='status' 
   
-----<hr>
-----<hr>
(mysqli): UPDATE `cronJobs` SET `status`='a:9:{s:8:\"progress\";i:0;s:12:\"progressStep\";i:0;s:13:\"progressSteps\";i:1;s:11:\"currentStep\";s:0:\"\";s:3:\"pid\";i:1033130;s:10:\"instanceId\";s:29:\"0.325.398-ReportsDataPopulate\";s:9:\"startDate\";d:1624903783.325239;s:17:\"dbMemoryPeakUsage\";i:75501568;s:11:\"dbHeartbeat\";d:1624903783.413568;}', `lastUpdateTime`='2021-06-28 15:09:43', `idUpdateUser`=0, `updatesCount`=updatesCount+1 WHERE `id`='ReportsDataPopulate' 
   
-----<hr>
-----<hr>
(mysqli): SELECT `cronjobCommandQueue` FROM `cronJobs` WHERE `id`='ReportsDataPopulate' 
   
-----<hr>
-----<hr>
(mysqli): START TRANSACTION 
   
-----<hr>
-----<hr>
(mysqli): SELECT entity, id, addTime FROM `rdQueueMain` ORDER BY `addTime` ASC LIMIT 1 
   
-----<hr>
-----<hr>
(mysqli): SELECT `id` FROM `rd_corporates` WHERE `id` = '10485' 
   
-----<hr>
-----<hr>
(mysqli): SELECT * FROM `corporates` WHERE `id`='10485' 
   
-----<hr>
-----<hr>
(mysqli): SELECT `var`, `value` FROM `corporatesRemarks` WHERE `idCorporate`='10485' 
   
-----<hr>
-----<hr>
(mysqli): SELECT corp.id AS `id` FROM `corporates` AS `corp` WHERE (corp.deleted = '0') AND (idRealCorporate = '10485')    
   
-----<hr>
-----<hr>
(mysqli): UPDATE `rd_corporates` SET `deleted` = '0', `locked` = '0', `alias` = 'DAN_COMP', `companyPrefixStd` = 'SC', `companyNameStd` = 'DAN_COMP', `companySuffixStd` = 'SRL', `companyPrefixLoc` = '', `companyNameLoc` = '', `companySuffixLoc` = '', `idTrust` = '0', `status` = 'CLIENT', `statusComments` = '', `type` = 'CC', `idSegment` = '76', `idDomainCategory` = NULL, `idDomain` = NULL, `fiscalCode` = '12107063-2-41', `euVatNumber` = 'REGREGREG', `regNo` = '9025503993', `registryAddress` = 'comp reg address', `vatRegistered` = '1', `vatCertificateNumber` = 'VATVATVATVAT', `accountingNumber` = '', `incomeTaxPayer` = '0', `liablePerson` = '', `telephone` = '+40721000143', `fax` = 'fax123', `email` = 'dan.baluta@dcsplus.net', `website` = 'http://www.com', `comments` = 'commc', `remarks` = 'jhfgdjasgdakshd:79\r\nQuickBooksID:86\r\nOffline Travel Order Required:1\r\nEmail Authorization Required:1\r\nDOMESTIC_ISSUE_INVOICE_SERIES:489\r\nINTERNATIONAL_ISSUE_INVOICE_SERIES:489\r\nDOMESTIC_REFUND_INVOICE_SERIES:489\r\nINTERNATIONAL_REFUND_INVOICE_SERIES:489', `processedRemarks` = '{\"DOMESTIC_ISSUE_INVOICE_SERIES\":\"489\",\"DOMESTIC_REFUND_INVOICE_SERIES\":\"489\",\"EMAIL_AUTHORIZATION_REQUIRED\":\"1\",\"INTERNATIONAL_ISSUE_INVOICE_SERIES\":\"489\",\"INTERNATIONAL_REFUND_INVOICE_SERIES\":\"489\",\"OFFLINE_TRAVEL_ORDER_REQUIRED\":\"1\",\"QuickBooksID\":\"86\"}', `lockedComments` = '', `idAccountManager` = '276', `idCollectionResponsible` = '276', `idRealCorporate` = '0', `addTime` = '2014-07-04 07:42:43', `idAddUser` = '276', `lastUpdateTime` = '2021-06-28 15:08:36', `idUpdateUser` = '276', `updatesCount` = '102' WHERE `id` = '10485' 
   
-----<hr>
-----<hr>
(mysqli): SELECT `idGroup`, `idGroupElement` FROM `corporateGroups` WHERE idCorporate='10485' 
   
-----<hr>
-----<hr>
(mysqli): DELETE FROM `rd_corporateGroups` WHERE `idCorporate` = '10485' 
   
-----<hr>
-----<hr>
(mysqli): DELETE FROM `rdQueueMain` WHERE entity='Corporate' AND id='10485' 
   
-----<hr>
-----<hr>
(mysqli): SELECT `id` FROM `rd_corporates` WHERE `id` = '15357' 
   
-----<hr>
-----<hr>
(mysqli): SELECT * FROM `corporates` WHERE `id`='15357' 
   
-----<hr>
-----<hr>
(mysqli): SELECT `var`, `value` FROM `corporatesRemarks` WHERE `idCorporate`='15357' 
   
-----<hr>
-----<hr>
(mysqli): SELECT corp.id AS `id` FROM `corporates` AS `corp` WHERE (corp.deleted = '0') AND (idRealCorporate = '15357')    
   
-----<hr>
-----<hr>
(mysqli): UPDATE `rd_corporates` SET `deleted` = '0', `locked` = '0', `alias` = 'DAN_COMP_DUPLICAT', `companyPrefixStd` = '', `companyNameStd` = 'DAN_COMP DUPLICAT', `companySuffixStd` = '', `companyPrefixLoc` = '', `companyNameLoc` = '', `companySuffixLoc` = '', `idTrust` = '0', `status` = 'LOST', `statusComments` = '', `type` = 'CC', `idSegment` = '76', `idDomainCategory` = NULL, `idDomain` = NULL, `fiscalCode` = '', `euVatNumber` = '', `regNo` = '', `registryAddress` = '', `vatRegistered` = '0', `vatCertificateNumber` = '', `accountingNumber` = '', `incomeTaxPayer` = '0', `liablePerson` = '', `telephone` = '', `fax` = '', `email` = '', `website` = '', `comments` = '', `remarks` = 'NEMO_ID 1\r\nCLNB-2\r\nLCN-3', `processedRemarks` = '{\"GLOBAL_CUST_NO\":\"2\",\"LOCAL_CUST_NO\":\"3\",\"NEMO_ID\":\"1\"}', `lockedComments` = NULL, `idAccountManager` = '0', `idCollectionResponsible` = '0', `idRealCorporate` = '10485', `addTime` = '2019-09-24 10:21:11', `idAddUser` = '276', `lastUpdateTime` = '2019-11-07 13:20:59', `idUpdateUser` = '276', `updatesCount` = '4' WHERE `id` = '15357' 
   
-----<hr>
-----<hr>
(mysqli): SELECT `idGroup`, `idGroupElement` FROM `corporateGroups` WHERE idCorporate='15357' 
   
-----<hr>
-----<hr>
(mysqli): DELETE FROM `rd_corporateGroups` WHERE `idCorporate` = '15357' 
   
-----<hr>
-----<hr>
(mysqli): DELETE FROM `rdQueueMain` WHERE entity='Corporate' AND id='15357' 
   
-----<hr>
-----<hr>
(mysqli): COMMIT 
   
-----<hr>
-----<hr>
(mysqli): SELECT `value` FROM `rdParams` WHERE `var`='status' 
   
-----<hr>
-----<hr>
(mysqli): START TRANSACTION 
   
-----<hr>
-----<hr>
(mysqli): SELECT entity, id, addTime FROM `rdQueueMain` ORDER BY `addTime` ASC LIMIT 1 
   
-----<hr>

<div class='type-info' data-microtime='1624903783.4598' data-memory='16777216'><span class='time'>2021-06-28 15:09:43.459845</span><span class='memory'>16.0Mb</span><span class='type'>info</span><span class='msg'>The RD queue is now empty - the cron will stop.</span></div>-----<hr>
(mysqli): COMMIT 
   
-----<hr>

<div class='type-success' data-microtime='1624903783.4602' data-memory='16777216'><span class='time'>2021-06-28 15:09:43.460159</span><span class='memory'>16.0Mb</span><span class='type'>success</span><span class='msg'>Successfully processed 1 transactions.</span></div>-----<hr>
(mysqli): SELECT `value` FROM `rdParams` WHERE `var`='status' 
   
-----<hr>
-----<hr>
(mysqli): REPLACE `rdParams` SET `var`='status', `value`='pending', `lastUpdate`='2021-06-28 15:09:43' 
   
-----<hr>
-----<hr>
(mysqli): UPDATE `cronJobs` SET `settings`='a:1:{s:17:\"StopAndRestartJob\";a:1:{s:8:\"restarts\";a:0:{}}}', `lastUpdateTime`='2021-06-28 15:09:43', `idUpdateUser`=0, `updatesCount`=updatesCount+1 WHERE `id`='ReportsDataPopulate' 
   
-----<hr>
-----<hr>
(mysqli): UPDATE `cronJobs` SET `status`='a:11:{s:8:\"progress\";d:1;s:12:\"progressStep\";i:0;s:13:\"progressSteps\";i:1;s:11:\"currentStep\";s:4:\"done\";s:3:\"pid\";i:1033130;s:10:\"instanceId\";s:29:\"0.325.398-ReportsDataPopulate\";s:9:\"startDate\";d:1624903783.325239;s:17:\"dbMemoryPeakUsage\";i:75501568;s:11:\"dbHeartbeat\";d:1624903783.413568;s:27:\"dbCheckCommandQueueInterval\";d:1624903783.413568;s:7:\"endDate\";d:1624903783.468639;}', `lastUpdateTime`='2021-06-28 15:09:43', `idUpdateUser`=0, `updatesCount`=updatesCount+1 WHERE `id`='ReportsDataPopulate' 
   
-----<hr>

<div class='type-info' data-microtime='1624903783.4764' data-memory='16777216'><span class='time'>2021-06-28 15:09:43.476439</span><span class='memory'>16.0Mb</span><span class='type'>info</span><span class='msg'>Cronjob execution ended.</span></div>-----<hr>
(mysqli): UPDATE `cronJobsLogs` SET `status`='ended', `errorStatus`='is' WHERE `id`='6553' 
   
-----<hr>
-----<hr>
(mysqli): 
				CREATE TABLE IF NOT EXISTS `zzUserTraces_202106` (
					`module` VARCHAR(250) NOT NULL DEFAULT '',
					`action` VARCHAR(100) NOT NULL DEFAULT '',
					`entityType` VARCHAR(50) NOT NULL DEFAULT '',
					`entityOperation` VARCHAR(50) NOT NULL DEFAULT '',
					`idEntity` VARCHAR(100) NOT NULL DEFAULT '',
					`extraData` TEXT NOT NULL,
					`timestamp` DECIMAL(16, 6) NOT NULL DEFAULT '0',
					`idUser` SMALLINT(5) NOT NULL DEFAULT '0',
					KEY `user_time` (`idUser`,`timestamp`),
					KEY `timestamp` (`timestamp`)
				) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
			 
   
-----<hr>
-----<hr>
(mysqli): INSERT INTO `zzUserTraces_202106` ( `module`, `action`, `entityType`, `entityOperation`, `idEntity`, `extraData`, `timestamp`, `idUser` ) VALUES ('', '', 'CronJob', 'update', 'ReportsDataPopulate', '', '1624903783.32267600', 0), ('Modules/Admin/CronJobs/Runner', NULL, '', '', '', '', '1624903783.32312200', 0), ('Modules/Admin/CronJobs/Runner', NULL, 'CronJob', 'update', 'ReportsDataPopulate', '', '1624903783.33258400', 0), ('Modules/Admin/CronJobs/Runner', NULL, 'App\\ReportsData\\Params', 'save', '', '', '1624903783.33438900', 0), ('Modules/Admin/CronJobs/Runner', NULL, 'CronJob', 'update', 'ReportsDataPopulate', '', '1624903783.42203800', 0), ('Modules/Admin/CronJobs/Runner', NULL, 'App\\ReportsData\\Params', 'save', '', '', '1624903783.46085200', 0), ('Modules/Admin/CronJobs/Runner', NULL, 'CronJob', 'update', 'ReportsDataPopulate', '', '1624903783.46847700', 0) 
   
-----<hr>