Status Cron executed with success Cron executed with success
Run Date 23-Dec-2024 07:00
Cron Output
Query No 12
Query Info 1) SELECT id FROM xyz_recipe WHERE status = 'R' AND updateTime < 1732341601 (0.0281 seconds)
2) DELETE FROM xyz_log_cron WHERE runTime < 1733637601 (0.0015 seconds) ----> 1 entries affected
3) DELETE FROM xyz_log_error WHERE recordTime < 1733637601 (0.0132 seconds) ----> 507 entries affected
4) DELETE FROM xyz_comment_notification WHERE addTime < 1729749601 (0.0004 seconds) ----> 0 entries affected
5) SELECT SUM(views) AS total_views FROM xyz_article LIMIT 0, 1 (0.0079 seconds)
6) SELECT COUNT(id) AS published FROM xyz_article WHERE pubTime >= '1734822000' AND status = 'A' LIMIT 0, 1 (0.0074 seconds)
7) SELECT total_views AS yesterday_views FROM xyz_article_history ORDER BY id DESC LIMIT 1 (0.0009 seconds)
8) INSERT INTO xyz_article_history (recordTime, views, total_views, published) VALUES ('1734933601', '1242', '6278890', '0') (0.0089 seconds) ----> 1 entries affected
9) SELECT SUM(views) AS total_views FROM xyz_recipe LIMIT 0, 1 (0.0367 seconds)
10) SELECT COUNT(id) AS published FROM xyz_recipe WHERE pubTime >= '1734822000' AND status = 'A' LIMIT 0, 1 (0.0281 seconds)
11) SELECT total_views AS yesterday_views FROM xyz_recipe_history ORDER BY id DESC LIMIT 1 (0.0011 seconds)
12) INSERT INTO xyz_recipe_history (recordTime, views, total_views, published) VALUES ('1734933601', '7835', '61777677', '0') (0.0007 seconds) ----> 1 entries affected