Looking at my logs I found a whole series of (fairly slow) requests in my logs and I'd like to know what they are? I imagine they're from a cron because they arrived en masse this lunchtime.
SELECT count(item.id) AS total FROM item
WHERE item.uid = 2 AND item_type = 0
and item_wall = 1
AND author_xchan = 'y2ldLZ1xrPLkBMXBzV4qcmXKi8p62d4WKasr6ubw7wkb9LPkWtr52PM6jRNq7lzFMTzKQKjIRppYJoAU_hIEPg' and item_private = 0 and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
and item.item_unpublished = 0 and item.item_pending_remove = 0 and item.item_blocked = 0 and item.item_delayed = 0 and not verb in ('http://activitystrea.ms/schema/1.0/follow', 'http://activitystrea.ms/schema/1.0/stop-following') AND ( author_xchan = 'https://domaine.tld/actor' OR owner_xchan = 'https://domaine.tld/actor' OR
(( NOT (deny_cid REGEXP '<https://domaine.tld/actor>' OR deny_gid REGEXP '<<>>')
AND ( allow_cid REGEXP '<https://domaine.tld/actor>' OR allow_gid REGEXP '<<>>' OR ( allow_cid = '' AND allow_gid = '' AND item_private = 0 ))
)))
AND item.created >= '0001-01-01 00:00:00';
Thank you in advance,