Laravel update jion problem

clipboard.png
I used this update statement in three scenarios
the first two scenarios that I commented out are updated without a problem
when the third scenario is updated, update-time has been updated, but status has not been updated
I don"t quite understand why there is such a problem
when I use the second sql statement, that is, when I don"t use join, both update_time and status can be executed.
my question now is why I use the annotated writing method: one or two scenarios, there is no problem, and the third scenario is not a problem, and I have come up with a sql statement to execute it, and there is no problem to update it all to

.
Oct.28,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3e132-2bc39.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3e132-2bc39.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?