SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000712s ]
SHOW FULL COLUMNS FROM `sys_contact` [ RunTime:0.000568s ]
SELECT c.id,c.phone,c.email,c.customer_service_qr,COALESCE(NULLIF(ct.address, ""), NULLIF(cd.address, ""), "") as address,COALESCE(NULLIF(ct.content, ""), NULLIF(cd.content, ""), "") as content FROM `sys_contact` `c` LEFT JOIN `sys_contact_translate` `ct` ON `ct`.`contact_id`=c.id AND ct.lang = "zh-cn" LEFT JOIN `sys_contact_translate` `cd` ON `cd`.`contact_id`=c.id AND cd.lang = "zh-cn" WHERE `c`.`status` = '1' ORDER BY `c`.`id` ASC LIMIT 1 [ RunTime:0.000545s ]
SHOW FULL COLUMNS FROM `sys_social` [ RunTime:0.000540s ]
SELECT `id`,`name`,`qr_code`,`link`,`sort` FROM `sys_social` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000378s ]
SHOW FULL COLUMNS FROM `sys_news` [ RunTime:0.000589s ]
SELECT n.id,n.category_id,n.cover_image,n.author,n.publish_time,n.view_count,n.sort,n.addtime,n.updatetime,COALESCE(NULLIF(nt.title, ""), NULLIF(nd.title, ""), "") as title,COALESCE(NULLIF(nt.content, ""), NULLIF(nd.content, ""), "") as content,COALESCE(NULLIF(nct.name, ""), NULLIF(ncd.name, ""), "") as category_name FROM `sys_news` `n` LEFT JOIN `sys_news_translate` `nt` ON `nt`.`news_id`=n.id AND nt.lang = "zh-cn" LEFT JOIN `sys_news_translate` `nd` ON `nd`.`news_id`=n.id AND nd.lang = "zh-cn" LEFT JOIN `sys_news_category_translate` `nct` ON `nct`.`category_id`=n.category_id AND nct.lang = "zh-cn" LEFT JOIN `sys_news_category_translate` `ncd` ON `ncd`.`category_id`=n.category_id AND ncd.lang = "zh-cn" WHERE `n`.`status` = '1' AND `n`.`id` = '6' LIMIT 1 [ RunTime:0.000624s ]
UPDATE `sys_news` SET `view_count` = `view_count` + 1 WHERE `id` = 6 [ RunTime:0.009344s ]
SELECT n.id,n.category_id,n.cover_image,n.author,n.publish_time,n.view_count,n.sort,n.addtime,n.updatetime,COALESCE(NULLIF(nt.title, ""), NULLIF(nd.title, ""), "") as title,COALESCE(NULLIF(nt.content, ""), NULLIF(nd.content, ""), "") as content,COALESCE(NULLIF(nct.name, ""), NULLIF(ncd.name, ""), "") as category_name FROM `sys_news` `n` LEFT JOIN `sys_news_translate` `nt` ON `nt`.`news_id`=n.id AND nt.lang = "zh-cn" LEFT JOIN `sys_news_translate` `nd` ON `nd`.`news_id`=n.id AND nd.lang = "zh-cn" LEFT JOIN `sys_news_category_translate` `nct` ON `nct`.`category_id`=n.category_id AND nct.lang = "zh-cn" LEFT JOIN `sys_news_category_translate` `ncd` ON `ncd`.`category_id`=n.category_id AND ncd.lang = "zh-cn" WHERE `n`.`status` = '1' AND `n`.`id` <> '6' AND ( `n`.`publish_time` > '1776416148' OR ( `n`.`publish_time` = '1776416148' AND `n`.`sort` < '0' ) OR ( `n`.`publish_time` = '1776416148' AND `n`.`sort` = '0' AND `n`.`id` > '6' ) ) ORDER BY `n`.`publish_time` ASC,`n`.`sort` DESC,`n`.`id` ASC LIMIT 1 [ RunTime:0.000696s ]
SELECT n.id,n.category_id,n.cover_image,n.author,n.publish_time,n.view_count,n.sort,n.addtime,n.updatetime,COALESCE(NULLIF(nt.title, ""), NULLIF(nd.title, ""), "") as title,COALESCE(NULLIF(nt.content, ""), NULLIF(nd.content, ""), "") as content,COALESCE(NULLIF(nct.name, ""), NULLIF(ncd.name, ""), "") as category_name FROM `sys_news` `n` LEFT JOIN `sys_news_translate` `nt` ON `nt`.`news_id`=n.id AND nt.lang = "zh-cn" LEFT JOIN `sys_news_translate` `nd` ON `nd`.`news_id`=n.id AND nd.lang = "zh-cn" LEFT JOIN `sys_news_category_translate` `nct` ON `nct`.`category_id`=n.category_id AND nct.lang = "zh-cn" LEFT JOIN `sys_news_category_translate` `ncd` ON `ncd`.`category_id`=n.category_id AND ncd.lang = "zh-cn" WHERE `n`.`status` = '1' AND `n`.`id` <> '6' AND ( `n`.`publish_time` < '1776416148' OR ( `n`.`publish_time` = '1776416148' AND `n`.`sort` > '0' ) OR ( `n`.`publish_time` = '1776416148' AND `n`.`sort` = '0' AND `n`.`id` < '6' ) ) ORDER BY `n`.`publish_time` DESC,`n`.`sort` ASC,`n`.`id` DESC LIMIT 1 [ RunTime:0.000640s ]