The first part of the string, Xara Designer Pro Plus 21 , is a legitimate search term or data entry. In an attack, this is often the expected input that the application's backend is designed to process. The single quote ( ' ) that follows it is the "breakout" character; it attempts to close the application's original SQL string so that the database will interpret the following text as a new command.
The string you provided appears to be a payload. This specific snippet is designed to test if a web application's database is vulnerable by forcing a deliberate delay in the server's response. Article: Anatomy of a Blind SQL Injection Payload The first part of the string, Xara Designer
The segment and(select 1)>0 serves as a simple "Always True" condition. Blind SQL Injection | OWASP Foundation The string you provided appears to be a payload