SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000661s ]
SHOW FULL COLUMNS FROM `sys_footer_nav` [ RunTime:0.000490s ]
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 = "zh-cn" 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.000578s ]
SHOW FULL COLUMNS FROM `sys_contact` [ RunTime:0.000444s ]
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 = "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.000391s ]
SHOW FULL COLUMNS FROM `sys_social` [ RunTime:0.000427s ]
SELECT `id`,`name`,`qr_code`,`link`,`sort` FROM `sys_social` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000264s ]
SHOW FULL COLUMNS FROM `sys_investor_relation` [ RunTime:0.000487s ]
SELECT ir.id,ir.cover_image,ir.sort,ir.status,COALESCE(NULLIF(irt.content, ""), NULLIF(ird.content, ""), "") as content,COALESCE(NULLIF(irt.team, ""), NULLIF(ird.team, ""), "") as team,COALESCE(NULLIF(irt.highlights, ""), NULLIF(ird.highlights, ""), "") as highlights FROM `sys_investor_relation` `ir` LEFT JOIN `sys_investor_relation_translate` `irt` ON `irt`.`investor_relation_id`=ir.id AND irt.lang = "zh-cn" LEFT JOIN `sys_investor_relation_translate` `ird` ON `ird`.`investor_relation_id`=ir.id AND ird.lang = "zh-cn" WHERE `ir`.`status` = '1' ORDER BY `ir`.`sort` ASC,`ir`.`id` DESC LIMIT 1 [ RunTime:0.000509s ]
SHOW FULL COLUMNS FROM `sys_ad` [ RunTime:0.000464s ]
SELECT `a`.`id`,`a`.`pos_id`,`a`.`name`,`a`.`description`,`a`.`pic`,`a`.`video`,`a`.`url`,`a`.`sort`,`a`.`starttime`,`a`.`endtime`,ap.size as pos_size FROM `sys_ad` `a` LEFT JOIN `sys_ad_pos` `ap` ON `ap`.`id`=`a`.`pos_id` WHERE `a`.`status` = '1' AND `a`.`module` = 'home' AND `a`.`pos_id` = '7' AND ( ( (a.starttime = 0 OR a.starttime IS NULL OR a.starttime <= 1777199909) ) ) AND ( ( (a.endtime = 0 OR a.endtime IS NULL OR a.endtime >= 1777199909) ) ) ORDER BY `a`.`sort` ASC,`a`.`id` DESC LIMIT 1 [ RunTime:0.000417s ]
