have been independently from each other transmitted through the described way. One has a very low fee of 1 sat/vB and the other one has a fee of 20 sat/vB. The latter one most likely will be confirmed in the next hour while the first one likely will stay unconf for weeks or months and never gets a confirmation. Will only the ladder one appear in Bitcoin Core ?
Since the fee for the first transaction is very low, it might not show up on Bitcoin core or any block explorer. It will have to remain unconfirmed until it is rebroadcasted with a higher fee. Or might even be dropped after awhile and returns to his wallet.
Question:
What would John's full node see when John fires up Bitcoin core? Does it notice anything at all? Does John's full node poll all his connected node partners at regular intervals and see this unconfirmed TX? Would John now see a lower account balance in his full node, even though the TX was not performed on his full node but is still known in the network and even though it is unconfirmed? Or will John's full node never seen anything as long as the TX gets a confirmation ?
John's full node, doesn't immediately notice a transaction until it's confirmed or added to a block. Because John didn't use his own node for this, but instead used a different Blockchain explorer, the transaction needs to pass through the mempool of that service's node. Other nodes connected to the network might also see the transaction while it's in the mempool. However, John's Bitcoincore full node won't show the updated balance until the transaction is confirmed or added to a block.