Кеширование тяжёлых запросов
Posted: Tue Sep 05, 2023 9:23 am
Можно ли дополнительно закешировать вывод похожих по тегам?
<thumb num=1-23 tag=CURRENT_ITEM_TAGS_COMBINED exclude_current_thumb=true>
По сути достаточно обновления раз в неделю
<thumb num=1-23 tag=CURRENT_ITEM_TAGS_COMBINED exclude_current_thumb=true>
По сути достаточно обновления раз в неделю
Code: Select all
Id: 9247709
User:
Host: localhost
db:
Command: Query
Time: 324
State: Sending data
Info: SELECT gs.gallery_id, gs.thumb_id, gi.sponsor_id, gi.content_count, gi.content_type, gs.total_shows, gs.total_clicks, gs.total_ctr, gt.thumb_url, gt.source_thumb_url, gd.*, gi.content_count, gi.crop_profile_id, gs.activation_date, gi.added_date, gi.duration, gi.url, gi.gallery_total_shows, gi.sponsor_id, gi.source_url, gi.custom_gallery FROM rot_gallery_stats2 as gs JOIN rot_gallery_info as gi on gi.gallery_id = gs.gallery_id
JOIN rot_gallery_data2 as gd on gd.gallery_id = gs.gallery_id
JOIN rot_gal2tag on rot_gal2tag.gallery_id = gs.gallery_id
JOIN rot_thumbs as gt on gt.thumb_id = gs.thumb_id
WHERE 1 = 1 AND gi.gallery_status = 'active' AND gi.gallery_type = 0 and gs.best_thumb = 'yes' and gs.group_id = 0 AND gs.gallery_id IN (SELECT gallery_id FROM rot_gal2tag WHERE tag_id IN ('10','15','46','129','131','132','135','136') and rot_gal2tag.site_id = '1' ) GROUP BY gs.gallery_id, gs.thumb_id ORDER BY tested_thumb DESC, gs.total_ctr DESC LIMIT 0, 24# queryitems