bulk_edit_posts should honor the show_in_quick_edit property of taxonomies

[Chouby]

When bulk editing posts, several database queries are related to taxonomies for which show_in_quick_edit is set to false. Since the terms are not modified, these queries uselessly harm the performance.

This is because bulk_edit_posts does not check this property when building arguments to pass to wp_update_post.

[sabernhardt]

simple refresh

[sabernhardt]

@Chouby Your approach looks good. I refreshed the patch to work with the current file.

[costdev]

Patch refreshed against trunk.

[webcommsat]

Adding summary from @nalininonstopnewsuk as she is unable to add changes to the ticket.

• This has a patch and appears just to need testing. Request to promote it at devchat on 16 March 2022.
• Any additional updates requested to @sabernhardt to try and get this into a future release, and to @chouby if there was any update for the ticket

Nalini:speech_balloon: 20:52
If this is still live, could it be added to open floor for dev chat this week to get some testing of the patch to move it forward @marybaum? (edited

[marybaum]

Pending testing from @meher. Slack was down for a lot of India last week, wo presumably she'll catch up in due course.

[marybaum]

In a scrub of the component, @webcommsat, @arslan and I tested the latest .diff from @costdev, and it works. Recommend commit!

[SergeyBiryukov]

In 53449:

Quick/Bulk Edit: Check the show_in_quick_edit taxonomy property when processing the data for bulk edited posts.

Previously, setting the show_in_quick_edit property to false removed the taxonomy from the inline edit form, but several taxonomy-related database queries were still being performed in bulk_edit_posts() when building the arguments to pass to wp_update_post(), even though terms were not modified.

This commit improves performance by avoiding unnecessary database queries when show_in_quick_edit is false, and mirrors a similar check in the get_inline_data() function.

Follow-up to [13535], [14580], [31307], [52841], [53368].

Props Chouby, sabernhardt, costdev, nalininonstopnewsuk, webcommsat, marybaum, meher, wparslan, SergeyBiryukov.
Fixes #42474.