attachment_url_to_postid( string $url ): int

5489function attachment_url_to_postid( $url ) {5490	global $wpdb;5491 5492	/**5493	 * Filters the attachment ID to allow short-circuit the function.5494	 *5495	 * Allows plugins to short-circuit attachment ID lookups. Plugins making5496	 * use of this function should return:5497	 *5498	 * - 0 (integer) to indicate the attachment is not found,5499	 * - attachment ID (integer) to indicate the attachment ID found,5500	 * - null to indicate WordPress should proceed with the lookup.5501	 *5502	 * Warning: The post ID may be null or zero, both of which cast to a5503	 * boolean false. For information about casting to booleans see the5504	 * {@link https://www.php.net/manual/en/language.types.boolean.php PHP documentation}.5505	 * Use the === operator for testing the post ID when developing filters using5506	 * this hook.5507	 *5508	 * @since 6.7.05509	 *5510	 * @param int|null $post_id The result of the post ID lookup. Null to indicate5511	 *                          no lookup has been attempted. Default null.5512	 * @param string   $url     The URL being looked up.5513	 */5514	$post_id = apply_filters( 'pre_attachment_url_to_postid', null, $url );5515	if ( null !== $post_id ) {5516		return (int) $post_id;5517	}5518 5519	$dir  = wp_get_upload_dir();5520	$path = $url;5521 5522	$site_url   = parse_url( $dir['url'] );5523	$image_path = parse_url( $path );5524 5525	// Force the protocols to match if needed.5526	if ( isset( $image_path['scheme'] ) && ( $image_path['scheme'] !== $site_url['scheme'] ) ) {5527		$path = str_replace( $image_path['scheme'], $site_url['scheme'], $path );5528	}5529 5530	if ( str_starts_with( $path, $dir['baseurl'] . '/' ) ) {5531		$path = substr( $path, strlen( $dir['baseurl'] . '/' ) );5532	}5533 5534	$sql = $wpdb->prepare(5535		"SELECT post_id, meta_value FROM $wpdb->postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = %s",5536		$path5537	);5538 5539	$results = $wpdb->get_results( $sql );5540	$post_id = null;5541 5542	if ( $results ) {5543		// Use the first available result, but prefer a case-sensitive match, if exists.5544		$post_id = reset( $results )->post_id;5545 5546		if ( count( $results ) > 1 ) {5547			foreach ( $results as $result ) {5548				if ( $path === $result->meta_value ) {5549					$post_id = $result->post_id;5550					break;5551				}5552			}5553		}5554	}5555 5556	/**5557	 * Filters an attachment ID found by URL.5558	 *5559	 * @since 4.2.05560	 *5561	 * @param int|null $post_id The post_id (if any) found by the function.5562	 * @param string   $url     The URL being looked up.5563	 */5564	return (int) apply_filters( 'attachment_url_to_postid', $post_id, $url );5565}
When	Instructions	Calls it makes
`$post_id !== null`	12	`apply_filters()`
`$post_id === null`	51–65	`apply_filters(), wp_get_upload_dir(), parse_url(), parse_url(), ->prepare(), ->get_results(), apply_filters()`
`$post_id === null`	58–80	`apply_filters(), wp_get_upload_dir(), parse_url(), parse_url(), ->prepare(), ->get_results(), reset(), apply_filters()`
PHP	Compiled	Executed	Branches	Notes
8.6-dev	82	12–80	9
8.5	82	12–80	9
8.4	82	12–80	9	9 fewer instructions than PHP 8.3
8.3	91	12–89	9
8.2	91	12–89	9
8.1	91	12–89	9
7.4	91	12–89	9