$sqlIndex = "INSERT IGNORE INTO s_search_index (keywordID, elementID, fieldID)\n\n" .
$sqlIndex;
$this->connection->
executeStatement($sqlIndex);
$sqlIndex =
[];
} } } } $this->
cleanupIndex();
$this->
cleanupKeywords();
} /**
* Updates the last update timestamp in the database
*/
private function setNextUpdateTimestamp(): void
{ $sql = '
SET @parent = (SELECT id FROM s_core_config_elements WHERE name = \'fuzzysearchlastupdate\');
DELETE FROM `s_core_config_values` WHERE element_id = @parent;
INSERT INTO `s_core_config_values` (`element_id`, `shop_id`, `value`) VALUES
(@parent, 1, CONCAT(\'s:\', LENGTH(NOW()), \':"\', NOW(), \'";\'));
';