WP_Query::generate_cache_key( array $args, string $sql ): string

4874	protected function generate_cache_key( array $args, $sql ) {4875		global $wpdb;4876 4877		unset(4878			$args['cache_results'],4879			$args['fields'],4880			$args['lazy_load_term_meta'],4881			$args['update_post_meta_cache'],4882			$args['update_post_term_cache'],4883			$args['update_menu_item_cache'],4884			$args['suppress_filters']4885		);4886 4887		if ( empty( $args['post_type'] ) ) {4888			if ( $this->is_attachment ) {4889				$args['post_type'] = 'attachment';4890			} elseif ( $this->is_page ) {4891				$args['post_type'] = 'page';4892			} else {4893				$args['post_type'] = 'post';4894			}4895		} elseif ( 'any' === $args['post_type'] ) {4896			$args['post_type'] = array_values( get_post_types( array( 'exclude_from_search' => false ) ) );4897		}4898		$args['post_type'] = (array) $args['post_type'];4899		// Sort post types to ensure same cache key generation.4900		sort( $args['post_type'] );4901 4902		if ( isset( $args['post_status'] ) ) {4903			$args['post_status'] = (array) $args['post_status'];4904			// Sort post status to ensure same cache key generation.4905			sort( $args['post_status'] );4906		}4907 4908		// Add a default orderby value of date to ensure same cache key generation.4909		if ( ! isset( $q['orderby'] ) ) {4910			$args['orderby'] = 'date';4911		}4912 4913		$placeholder = $wpdb->placeholder_escape();4914		array_walk_recursive(4915			$args,4916			/*4917			 * Replace wpdb placeholders with the string used in the database4918			 * query to avoid unreachable cache keys. This is necessary because4919			 * the placeholder is randomly generated in each request.4920			 *4921			 * $value is passed by reference to allow it to be modified.4922			 * array_walk_recursive() does not return an array.4923			 */4924			static function ( &$value ) use ( $wpdb, $placeholder ) {4925				if ( is_string( $value ) && str_contains( $value, $placeholder ) ) {4926					$value = $wpdb->remove_placeholder_escape( $value );4927				}4928			}4929		);4930 4931		ksort( $args );4932 4933		// Replace wpdb placeholder in the SQL statement used by the cache key.4934		$sql = $wpdb->remove_placeholder_escape( $sql );4935		$key = md5( serialize( $args ) . $sql );4936 4937		$last_changed = wp_cache_get_last_changed( 'posts' );4938		if ( ! empty( $this->tax_query->queries ) ) {4939			$last_changed .= wp_cache_get_last_changed( 'terms' );4940		}4941 4942		return "wp_query:$key:$last_changed";4943	}