SHOW FULL COLUMNS FROM `cms_fragment` [ RunTime:0.000613s ]
SELECT * FROM `cms_fragment` WHERE `key` = 'base_config' LIMIT 1 [ RunTime:0.000359s ]
SHOW FULL COLUMNS FROM `cms_seo` [ RunTime:0.000619s ]
SELECT * FROM `cms_seo` WHERE `nav_type` = 'fortune' LIMIT 1 [ RunTime:0.000365s ]
SELECT * FROM `cms_seo` WHERE `status` = 1 AND `is_show_nav` = 1 ORDER BY `sort` DESC [ RunTime:0.000412s ]
SHOW FULL COLUMNS FROM `cms_news` [ RunTime:0.000937s ]
SELECT * FROM `cms_news` WHERE `status` = 1 AND `issued_time` BETWEEN '2025-06-16 10:00:00' AND '2025-06-17 23:59:59' ORDER BY `look_num` DESC,`sort` DESC,`id` DESC LIMIT 10 [ RunTime:0.059450s ]
SHOW FULL COLUMNS FROM `cms_news_classify` [ RunTime:0.000707s ]
SELECT * FROM `cms_news_classify` WHERE `status` = 1 AND `nav_type` = 'fortune' AND `sidebar` = 1 ORDER BY `sort` DESC LIMIT 4 [ RunTime:0.000556s ]
SHOW FULL COLUMNS FROM `cms_stars` [ RunTime:0.000737s ]
SELECT * FROM `cms_stars` WHERE `start_month` <= '06-17' AND `end_month` >= '06-17' LIMIT 1 [ RunTime:0.000475s ]
SELECT * FROM `cms_stars` WHERE `end_month` = '05-20' LIMIT 1 [ RunTime:0.000417s ]
SELECT * FROM `cms_stars` WHERE `start_month` = '06-22' LIMIT 1 [ RunTime:0.000407s ]
SELECT * FROM `cms_stars` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000605s ]
SELECT * FROM `cms_news` WHERE `status` = 1 AND `nav_type` = 'aspect' ORDER BY `issued_time` DESC,`look_num` DESC,`sort` DESC LIMIT 8 [ RunTime:0.061868s ]
SELECT * FROM `cms_news` WHERE `status` = 1 AND `nav_type` = 'emotion' ORDER BY `look_num` DESC,`sort` DESC LIMIT 8 [ RunTime:0.060259s ]
SELECT * FROM `cms_news` WHERE `status` = 1 AND `nav_type` = 'quotation' ORDER BY `sort` DESC,`look_num` DESC,`id` DESC LIMIT 8 [ RunTime:0.058925s ]
SHOW FULL COLUMNS FROM `cms_flink` [ RunTime:0.000670s ]
SELECT * FROM `cms_flink` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000375s ]
SELECT * FROM `cms_news` WHERE `issued_time` <= '2025-06-17 12:41:37' AND `examine_status` = 1 AND `id` = 3731 LIMIT 1 [ RunTime:0.000607s ]
SHOW FULL COLUMNS FROM `cms_keyword` [ RunTime:0.000629s ]
SELECT `name`,`jump_url`,`jump_way`,`color` FROM `cms_keyword` WHERE `status` = 1 AND `nav_type` = 'fortune' [ RunTime:0.000346s ]
SHOW FULL COLUMNS FROM `cms_access_admin` [ RunTime:0.000607s ]
SELECT * FROM `cms_access_admin` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000350s ]
SELECT `value` FROM `cms_fragment` WHERE `key` = 'upload_config' LIMIT 1 [ RunTime:0.000311s ]
SHOW FULL COLUMNS FROM `cms_news_classify_img` [ RunTime:0.000603s ]
SELECT * FROM `cms_news_classify_img` WHERE `classify_id` = 14 AND `stars_id` = 4 LIMIT 1 [ RunTime:0.000379s ]
SELECT * FROM `cms_stars` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000432s ]
SELECT `nav_name` FROM `cms_seo` WHERE `nav_type` = 'fortune' LIMIT 1 [ RunTime:0.000317s ]
UPDATE `cms_news` SET `look_num` = 869 WHERE `id` = 3731 [ RunTime:0.003368s ]
SELECT * FROM `cms_news` WHERE `issued_time` <= '2025-06-17 12:41:37' AND `id` < 3731 AND `examine_status` = 1 AND `status` = 1 AND `nav_type` = 'fortune' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000715s ]
SELECT * FROM `cms_news` WHERE `issued_time` <= '2025-06-17 12:41:37' AND `id` > 3731 AND `examine_status` = 1 AND `status` = 1 AND `nav_type` = 'fortune' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000682s ]
SELECT * FROM `cms_news` WHERE `status` = 1 AND `examine_status` = 1 AND `stars_id` = 4 AND `issued_time` <= '2025-06-17 12:41:37' AND `id` <> 3731 AND ( 1=1 or title|content like '%金牛座今日运势%' or title|content like '%织女网金牛座今日运势%' or title|content like '%星座运势2023年12月7日%' or title|content like '%金牛座今日幸运数字、幸运颜色、开运方位%' or title|content like '%金牛座今日爱情运势、事业运势、财运运势%' ) ORDER BY `look_num` DESC LIMIT 10 [ RunTime:0.060128s ]
