Read values from S7 component to mysql query

Please export your flow again, read this post and edit your post.

First determine the debug output of your node.

This line:
msg.topic = "INSERT into Temps(Temp1) VALUES ('str1')"; //

str1 inserted as a string, not the data/object/array that you are looking for.

It should be something like

VALUES ('"+str1+"')"