Let me try to explain how the LRCC desktop app works, which should then answer your question about duplicates:
When you add images to LRCC desktop, whether from a memory card or existing hard drive folder, it first of all COPIES all the files being imported into it's own "space" on the local hard drive (the default would be the system drive, but it's possible to change this location in the app preferences). Once copied into it's own "space", the images will then start to upload to the cloud, using that copy. The original images on the card or hard drive folder are no longer used by, or of any concern to, the LRCC app, and it's the user's responsibility to "manage" those, i.e. keep or delete as required. If you are only intending to use these images in LRCC and the cloud, you might therefore consider whether there's any point in going to the trouble of copying them from the SD card to a carefully named folder on the hard drive, rather than importing directly from the SD card.
Getting back to the LRCC desktop app, once the images have been synced up to the cloud the decision on what to to about the copies in the LRCC's space is determined by the choice the user makes regarding the option in Preferences>Local Storage tab>Store a copy of all originals at the specified location (the location being either the default or user specified as mentioned earlier). If that option is checked, the newly added photos will be retained as the local copy, if the option is unchecked the newly added photos will be eligible for deletion by LRCC which will happen gradually over time.
That explanation should answer part of your question, i.e. if you copy the images from your SD card to hard drive, and them add them to LRCC, then at that point yes those images will exist as duplicates on the drive.
The second part of your question is about what happens if you've added some images to LRCC on your phone before you attempt to add the entire contents of the SD card or hard drive folder to the LRCC desktop app. Provided the upload sync from the phone has completed, then my expectation is that when you try to import/add the same images to the desktop app, LRCC will not allow that for those few already-synced files, as it will correctly identify them as duplicates. So I do not believe you would end up with duplicates in the LRCC catalog. You may want to test that, but that should be easy enough to do.