امتیازها
113
راهحلها
27
- محل سکونت
- England
- نوشتهها
- 26,276
- تاریخ ثبتنام
- ۱۳۹۹٫۰۴٫۰۶
- پسندها
- 3,286
- سن
- 29
- وب سایت
- xenforo.xyz
- نسخه PHP
- 7.3
- نسخه زنفورو
- xenforo 2.2
I have a site that is pretty heavily modified and definitely has a lot of attachments. Does anyone know what might be running this query? It could be an add-on as well. I'm looking to speed it up, the query can take upwards of 45 seconds sometimes.
Code:
Read more
Code:
EXPLAIN SELECT xf_attachment.attachment_id, xf_attachment.content_type, xf_attachment.content_id, xf_attachment_data.data_id FROM xf_attachment INNER JOIN xf_attachment_data ON xf_attachment_data.data_id = xf_attachment.data_id INNER JOIN...Read more