Changeset 11352 for trunk/src/bp-xprofile/classes/class-bp-xprofile-field.php

Timestamp:

12/29/2016 02:16:02 AM (8 years ago)

Author:

boonebgorges

Message:

XProfile: Add caching for fetching a field ID by name.

Fixes #7404.

File:

• trunk/src/bp-xprofile/classes/class-bp-xprofile-field.php (modified) (1 diff)

trunk/src/bp-xprofile/classes/class-bp-xprofile-field.php

@@ -918 +918 @@
         }
 
-        $sql = $wpdb->prepare( "SELECT id FROM {$bp->profile->table_name_fields} WHERE name = %s AND parent_id = 0", $field_name );
-
-        $query = $wpdb->get_var( $sql );
-
-        return is_numeric( $query ) ? (int) $query : $query;
+        $id = bp_core_get_incremented_cache( $field_name, 'bp_xprofile_fields_by_name' );
+        if ( false === $id ) {
+            $sql = $wpdb->prepare( "SELECT id FROM {$bp->profile->table_name_fields} WHERE name = %s AND parent_id = 0", $field_name );
+            $id = $wpdb->get_var( $sql );
+            bp_core_set_incremented_cache( $field_name, 'bp_xprofile_fields_by_name', $id );
+        }
+
+        return is_numeric( $id ) ? (int) $id : $id;
     }