SELECT COUNT(*) AS c FROM (SELECT 1 FROM `cos_images` WHERE `shop_id` = 0 AND `uname` <> '' AND `uname` IS NOT NULL AND (`filename` LIKE '%抄底%' OR `uname` LIKE '%抄底%') AND `uploaded_at` >= COALESCE((SELECT DATE(MAX(`uploaded_at`)) - INTERVAL '2' DAY FROM `cos_images` WHERE `shop_id` = 0 AND `uname` <> '' AND `uname` IS NOT NULL), CURDATE()) GROUP BY `uname`, DATE(`uploaded_at`)) t [ RunTime:0.025034s ]
SELECT `uname`, DATE(`uploaded_at`) AS d, COUNT(*) AS c, MAX(`uploaded_at`) AS last_update
FROM `cos_images` WHERE `shop_id` = 0 AND `uname` <> '' AND `uname` IS NOT NULL AND (`filename` LIKE '%抄底%' OR `uname` LIKE '%抄底%') AND `uploaded_at` >= COALESCE((SELECT DATE(MAX(`uploaded_at`)) - INTERVAL '2' DAY FROM `cos_images` WHERE `shop_id` = 0 AND `uname` <> '' AND `uname` IS NOT NULL), CURDATE())
GROUP BY `uname`, DATE(`uploaded_at`)
ORDER BY last_update DESC, `uname` ASC
LIMIT 0, 24 [ RunTime:0.020408s ]
SHOW FULL COLUMNS FROM `cos_images` [ RunTime:0.001006s ]
SELECT `object_key`,`filename`,`uploaded_at`,`id` FROM `cos_images` WHERE `shop_id` = 0 AND `uname` = '抄底' AND `uploaded_at` BETWEEN '2026-11-02 00:00:00' AND '2026-11-02 23:59:59' ORDER BY `uploaded_at` DESC,`id` DESC LIMIT 200 [ RunTime:0.000873s ]
SELECT `object_key`,`filename`,`uploaded_at`,`id` FROM `cos_images` WHERE `shop_id` = 0 AND `uname` = '和信' AND `uploaded_at` BETWEEN '2026-10-31 00:00:00' AND '2026-10-31 23:59:59' ORDER BY `uploaded_at` DESC,`id` DESC LIMIT 200 [ RunTime:0.006327s ]
SELECT `object_key`,`filename`,`uploaded_at`,`id` FROM `cos_images` WHERE `shop_id` = 0 AND `uname` = '抄底' AND `uploaded_at` BETWEEN '2026-10-31 00:00:00' AND '2026-10-31 23:59:59' ORDER BY `uploaded_at` DESC,`id` DESC LIMIT 200 [ RunTime:0.006382s ]
SELECT `id`, `name`, `bg` FROM `tc_guanzhu_cat` ORDER BY `sort` ASC, `id` ASC [ RunTime:0.000743s ]
SELECT `cat_id`, `uname` FROM `tc_guanzhu` ORDER BY `sort` ASC, `id` ASC [ RunTime:0.000497s ]
SELECT `uname` FROM `cos_images` WHERE `shop_id` = 0 AND `uname` <> '' AND `uploaded_at` BETWEEN '2026-11-02 00:00:00' AND '2026-11-02 23:59:59' GROUP BY `uname` [ RunTime:0.000800s ]
SHOW FULL COLUMNS FROM `tc_ai_hot_searches` [ RunTime:0.000962s ]
SELECT `keyword` FROM `tc_ai_hot_searches` ORDER BY `hits` DESC,`last_at` DESC LIMIT 10 [ RunTime:0.000376s ]
站长微信
微信群
