Status Cron executed with success Cron executed with success
Run Date 20-Dec-2024 07:00
Cron Output
Query No 12
Query Info 1) SELECT id FROM xyz_recipe WHERE status = 'R' AND updateTime < 1732082401 (0.0321 seconds)
2) DELETE FROM xyz_log_cron WHERE runTime < 1733378401 (0.0019 seconds) ----> 1 entries affected
3) DELETE FROM xyz_log_error WHERE recordTime < 1733378401 (0.0114 seconds) ----> 319 entries affected
4) DELETE FROM xyz_comment_notification WHERE addTime < 1729490401 (0.0003 seconds) ----> 0 entries affected
5) SELECT SUM(views) AS total_views FROM xyz_article LIMIT 0, 1 (0.0126 seconds)
6) SELECT COUNT(id) AS published FROM xyz_article WHERE pubTime >= '1734562800' AND status = 'A' LIMIT 0, 1 (0.0104 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 ('1734674401', '2844', '6275486', '0') (0.0007 seconds) ----> 1 entries affected
9) SELECT SUM(views) AS total_views FROM xyz_recipe LIMIT 0, 1 (0.0274 seconds)
10) SELECT COUNT(id) AS published FROM xyz_recipe WHERE pubTime >= '1734562800' AND status = 'A' LIMIT 0, 1 (0.0302 seconds)
11) SELECT total_views AS yesterday_views FROM xyz_recipe_history ORDER BY id DESC LIMIT 1 (0.0008 seconds)
12) INSERT INTO xyz_recipe_history (recordTime, views, total_views, published) VALUES ('1734674401', '10656', '61752201', '0') (0.0007 seconds) ----> 1 entries affected