SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000750s ]
SHOW FULL COLUMNS FROM `sys_contact` [ RunTime:0.000640s ]
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.000587s ]
SHOW FULL COLUMNS FROM `sys_social` [ RunTime:0.000568s ]
SELECT `id`,`name`,`qr_code`,`link`,`sort` FROM `sys_social` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000408s ]
SHOW FULL COLUMNS FROM `sys_news` [ RunTime:0.000600s ]
SELECT COUNT(*) AS think_count 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' [ RunTime:0.000722s ]
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' ORDER BY `n`.`publish_time` DESC,`n`.`sort` ASC,`n`.`id` DESC LIMIT 0,7 [ RunTime:0.000552s ]
SHOW FULL COLUMNS FROM `sys_ad` [ RunTime:0.000606s ]
SELECT `id`,`name`,`description`,`pic`,`video`,`url`,`sort`,`starttime`,`endtime` FROM `sys_ad` WHERE `status` = 1 AND `module` = 'home' AND `pos_id` = 6 AND ( ( (starttime = 0 OR starttime IS NULL OR starttime <= 1776432560) ) ) AND ( ( (endtime = 0 OR endtime IS NULL OR endtime >= 1776432560) ) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000482s ]
