- تاریخ ثبتنام
- 2020-06-26
- نوشتهها
- 21,420
- راهحلها
- 27
- پسندها
- 3,264
- امتیازها
- 113
- سن
- 27
- محل سکونت
- England
- وب سایت
- xenforo.xyz
I'm fairly certain this query is coming from a new posts widget, but not 100% certain. Looks like there is no
Code:
This is the full query, with most of the node IDs excluded since it was quite a long list, and makes reading through the query quite a bit more difficult:
Code:
node_id index on xf_thread, and there's also an issue with this portion: portionCode:
(`xf_forum_Forum_2`.`find_new` = 1)This is the full query, with most of the node IDs excluded since it was quite a long list, and makes reading through the query quite a bit more difficult:
Code:
SELECT `xf_thread`.*, `xf_poll_Poll_1`.*...
نام موضوع : Widget query causing table locks
