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.033469s ]
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.034853s ]
SELECT `id`, `name`, `bg` FROM `tc_guanzhu_cat` ORDER BY `sort` ASC, `id` ASC [ RunTime:0.001103s ]
SELECT `cat_id`, `uname` FROM `tc_guanzhu` ORDER BY `sort` ASC, `id` ASC [ RunTime:0.001357s ]
SHOW FULL COLUMNS FROM `cos_images` [ RunTime:0.001434s ]
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.001108s ]
SHOW FULL COLUMNS FROM `tc_ai_hot_searches` [ RunTime:0.001118s ]
SELECT `keyword` FROM `tc_ai_hot_searches` ORDER BY `hits` DESC,`last_at` DESC LIMIT 10 [ RunTime:0.000614s ]
站长微信
微信群
