SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000834s ]
SHOW FULL COLUMNS FROM `sys_footer_nav` [ RunTime:0.000504s ]
SELECT f.id,f.pid,f.sort,f.status,COALESCE(NULLIF(ft.name, ""), NULLIF(fd.name, ""), "") as name,COALESCE(NULLIF(ft.url, ""), NULLIF(fd.url, ""), "") as url FROM `sys_footer_nav` `f` LEFT JOIN `sys_footer_nav_translate` `ft` ON `ft`.`footer_nav_id`=f.id AND ft.lang = "en-us" LEFT JOIN `sys_footer_nav_translate` `fd` ON `fd`.`footer_nav_id`=f.id AND fd.lang = "zh-cn" WHERE `f`.`status` = '1' ORDER BY `f`.`sort` ASC,`f`.`id` ASC [ RunTime:0.000527s ]
SHOW FULL COLUMNS FROM `sys_contact` [ RunTime:0.000456s ]
SELECT c.id,c.phone,c.email,c.customer_service_qr,ct.address as current_address,cd.address as default_address,ct.content as current_content,cd.content as default_content,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 = "en-us" 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.000430s ]
SHOW FULL COLUMNS FROM `sys_social` [ RunTime:0.000544s ]
SELECT `id`,`name`,`qr_code`,`link`,`sort` FROM `sys_social` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000332s ]
SHOW FULL COLUMNS FROM `sys_news` [ RunTime:0.000555s ]
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 = "en-us" 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 = "en-us" 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` = '10' LIMIT 1 [ RunTime:0.000589s ]
UPDATE `sys_news` SET `view_count` = `view_count` + 1 WHERE `id` = 10 [ RunTime:0.006322s ]
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 = "en-us" 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 = "en-us" 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` <> '10' AND ( `n`.`publish_time` > '1777005102' OR ( `n`.`publish_time` = '1777005102' AND `n`.`sort` < '0' ) OR ( `n`.`publish_time` = '1777005102' AND `n`.`sort` = '0' AND `n`.`id` > '10' ) ) ORDER BY `n`.`publish_time` ASC,`n`.`sort` DESC,`n`.`id` ASC LIMIT 1 [ RunTime:0.000706s ]
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 = "en-us" 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 = "en-us" 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` <> '10' AND ( `n`.`publish_time` < '1777005102' OR ( `n`.`publish_time` = '1777005102' AND `n`.`sort` > '0' ) OR ( `n`.`publish_time` = '1777005102' AND `n`.`sort` = '0' AND `n`.`id` < '10' ) ) ORDER BY `n`.`publish_time` DESC,`n`.`sort` ASC,`n`.`id` DESC LIMIT 1 [ RunTime:0.000757s ]
2026-04-24
