cleanupKeywords example

$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(), \'";\')); ';
Home | Imprint | This part of the site doesn't use cookies.