Database search with multi joins
To speed up query I would recommend indexes on the columns you join in:


records.id, records.type, records.label (combined index)
records_labels.id
records_types.id
records_serial.record


Depending on the data in records_serial.serial and records_barcode.* (which column do you want to query here?) it may be also useful to add indexes here.

That index suggestion is optimized for this single query. You should also consider the disadvantages for other queries.