WordPress import media from wp_content/uploads

functions.php

/* Import media present on the wp_uploads folder */
// https://codex.wordpress.org/Function_Reference/wp_insert_attachment
if($_GET['rohs_run']) {
	echo 'RUN';
	// Get WP uploads dir
	$wp_upload_dir = wp_upload_dir();

	// Init recursive Obj
	$di = new RecursiveDirectoryIterator($wp_upload_dir['path'], RecursiveDirectoryIterator::SKIP_DOTS);
	foreach (new RecursiveIteratorIterator($di) as $filename => $file) {
		// get filetype for attachment meta
		$filetype = wp_check_filetype( $file->getPathname(), null );
		// attachment meta
		$attachment = array(
			'guid'           => $wp_upload_dir['url'] . '/' . $filename, 
			'post_mime_type' => $filetype['type'],
			'post_title'     => preg_replace( '/\.[^.]+$/', '', $filename ),
			'post_content'   => '',
			'post_status'    => 'inherit'
		);

		// Insert the attachment.
		$attach_id = wp_insert_attachment( $attachment, $filename );
		
		// echo $attach_id;
	}
}

Don't forget to change max exec time and default_socket_timeout

Some useful commands

DELETE FROM $posts WHERE post_type = 'attachment' AND guid LIKE '%uploads/products%'
DELETE FROM $posts WHERE post_type = 'attachment' AND guid LIKE '%wc-logs%'
DELETE FROM $posts WHERE post_type = 'attachment' AND guid LIKE '%thumb%'