SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000672s ]
SHOW FULL COLUMNS FROM `sys_contact` [ RunTime:0.000563s ]
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.000508s ]
SHOW FULL COLUMNS FROM `sys_social` [ RunTime:0.000481s ]
SELECT `id`,`name`,`qr_code`,`link`,`sort` FROM `sys_social` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000340s ]
SHOW FULL COLUMNS FROM `sys_support_material` [ RunTime:0.000607s ]
SELECT COUNT(*) AS think_count FROM `sys_support_material` `sm` LEFT JOIN `sys_support_material_translate` `smt` ON `smt`.`support_material_id`=sm.id AND smt.lang = "zh-cn" LEFT JOIN `sys_support_material_translate` `smd` ON `smd`.`support_material_id`=sm.id AND smd.lang = "zh-cn" WHERE `sm`.`status` = '1' [ RunTime:0.000531s ]
SELECT sm.id,sm.file_url,sm.file_size,sm.update_date,sm.doc_type,sm.version,sm.page_count,sm.sort,sm.addtime,sm.updatetime,COALESCE(NULLIF(smt.title, ""), NULLIF(smd.title, ""), "") as title,COALESCE(NULLIF(smt.doc_type_label, ""), NULLIF(smd.doc_type_label, ""), NULLIF(sm.doc_type, ""), "") as doc_type_label FROM `sys_support_material` `sm` LEFT JOIN `sys_support_material_translate` `smt` ON `smt`.`support_material_id`=sm.id AND smt.lang = "zh-cn" LEFT JOIN `sys_support_material_translate` `smd` ON `smd`.`support_material_id`=sm.id AND smd.lang = "zh-cn" WHERE `sm`.`status` = '1' ORDER BY `sm`.`sort` ASC,`sm`.`id` DESC LIMIT 0,8 [ RunTime:0.000516s ]
SELECT sm.doc_type,MAX(COALESCE(NULLIF(smt.doc_type_label, ""), NULLIF(smd.doc_type_label, ""), NULLIF(sm.doc_type, ""), "")) as doc_type_label,MIN(sm.sort) as min_sort,MAX(sm.id) as max_id FROM `sys_support_material` `sm` LEFT JOIN `sys_support_material_translate` `smt` ON `smt`.`support_material_id`=sm.id AND smt.lang = "zh-cn" LEFT JOIN `sys_support_material_translate` `smd` ON `smd`.`support_material_id`=sm.id AND smd.lang = "zh-cn" WHERE `sm`.`status` = '1' GROUP BY `sm`.`doc_type` ORDER BY `min_sort` ASC,`max_id` DESC [ RunTime:0.000487s ]
SHOW FULL COLUMNS FROM `sys_support_video` [ RunTime:0.000557s ]
SELECT COUNT(*) AS think_count FROM `sys_support_video` `sv` LEFT JOIN `sys_support_video_translate` `svt` ON `svt`.`support_video_id`=sv.id AND svt.lang = "zh-cn" LEFT JOIN `sys_support_video_translate` `svd` ON `svd`.`support_video_id`=sv.id AND svd.lang = "zh-cn" WHERE `sv`.`status` = '1' [ RunTime:0.000443s ]
SELECT sv.id,sv.cover_image,sv.video_url,sv.duration,sv.play_count,sv.update_date,sv.sort,sv.addtime,sv.updatetime,COALESCE(NULLIF(svt.title, ""), NULLIF(svd.title, ""), "") as title,COALESCE(NULLIF(svt.category_label, ""), NULLIF(svd.category_label, ""), "") as category_label FROM `sys_support_video` `sv` LEFT JOIN `sys_support_video_translate` `svt` ON `svt`.`support_video_id`=sv.id AND svt.lang = "zh-cn" LEFT JOIN `sys_support_video_translate` `svd` ON `svd`.`support_video_id`=sv.id AND svd.lang = "zh-cn" WHERE `sv`.`status` = '1' ORDER BY `sv`.`sort` ASC,`sv`.`id` DESC LIMIT 0,6 [ RunTime:0.000409s ]
SHOW FULL COLUMNS FROM `sys_ad` [ RunTime:0.000493s ]
SELECT `id`,`name`,`description`,`pic`,`video`,`url`,`sort`,`starttime`,`endtime` FROM `sys_ad` WHERE `status` = 1 AND `module` = 'home' AND `pos_id` = 8 AND ( ( (starttime = 0 OR starttime IS NULL OR starttime <= 1776432467) ) ) AND ( ( (endtime = 0 OR endtime IS NULL OR endtime >= 1776432467) ) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000409s ]
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.000360s ]